Welcome

This is a very minimal, probably infrequently updated blog, with some tech tidbits. The main plan is to come back to these posts when I forget how to do something, but if you find it useful too, that's great. :)

Recent Posts

• 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.