Topic: Databases
2024
-
Postgres: Use Views to Refactor to Soft Delete
Refactors are tough, database refactors are scary. Being a bit clever can save us a lot of pain! -
Book Club 6&7/2024: Postgres
I have become further radicalized to the opinion that we should all just be using PostgreSQL -
Book Club 4/2024: I Don't Like ORMs
Object-relational mappers are more trouble than they're worth. -
Just Use PostgreSQL
With 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
-
Write Your Own RDBMS Versioned Migration Boilerplate
Versioned 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. -
Adding a Database to our Railway App
Last 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. -
Quick & Dirty Sequential IDs in MongoDB
Mongo doesn't natively support generating sequential IDs. Here's a quick & dirty solution to get you up and going if you need sequential IDs.