2024

• 10.05 Postgres: Use Views to Refactor to Soft DeleteRefactors are tough, database refactors are scary. Being a bit clever can save us a lot of pain!
• 07.29 Book Club 6&7/2024: PostgresI have become further radicalized to the opinion that we should all just be using PostgreSQL
• 04.24 Book Club 4/2024: I Don't Like ORMsObject-relational mappers are more trouble than they're worth.
• 01.13 Just Use PostgreSQLWith a vast and growing ecosystem of database systems, data models, patterns, and paradigms, choosing the right one can be a long and complicated process. I prefer a simpler approach: Just use PostgreSQL.

2023

• 11.25 Write Your Own RDBMS Versioned Migration BoilerplateVersioned migrations are an essential tool for systems using an RDBMS, and it's no work at all to start your applications the right way with this pattern.
• 11.08 Adding a Database to our Railway AppLast time I looked at Railway, I got it up and running with a Blazor WASM app. Now, I'll look at adding a PostgreSQL database to it.
• 11.01 Quick & Dirty Sequential IDs in MongoDBMongo doesn't natively support generating sequential IDs. Here's a quick & dirty solution to get you up and going if you need sequential IDs.