Posts

All the articles I've posted.

• Preventing Overlapping Data in PostgreSQL - What Goes Into an Exclusion Constraint

  Posted on:20 October 2024  at 

  How can you prevent overlapping date ranges? Exclusion constraints do it at the database layer

• Quick CSV to SQLite with DuckDB

  Posted on:30 September 2024  at 

  Quickly creating SQLite databases with DuckDB, without writing schemas

• Psycopg Database Connections with FastAPI

  Posted on:28 July 2024  at 

  Sharing database connections between requests with FastAPI

• Refactoring list logic using Python sets

  Posted on:24 November 2023  at 

  Replacing loops and ifs with Python sets for a speedup and better readability.

• Starting a new Python project - an opinionated starter guide

  Posted on:2 November 2023  at 

  An opinionated mini-guide to setup a new Python project from scratch with *most* of the tooling you will need.