News for hackers. Stuff that matters.
Re:Ask HN: What tooling do you use for SQL/DB migrations by gregjor on Wednesday July 03, 2024 @09:37AM (#40865847)
We write the migrations in SQL, committed as part of the pull request. Migrations tested on copies of production database along with the code changes. Automatically applied by a script when a pull request gets merged/deployed. No special tooling really, just a couple of SQL files.

We have a SQL preprocessor that lets us refer to environment globals and class constants in SQL, so we're not hard-coding magic numbers and strings in the SQL. It resolves those with reflection on the code and replaces the named globals/constants before sending the SQL to the database.

Re:Ask HN: What tooling do you use for SQL/DB migrations by stop50 on Wednesday July 03, 2024 @10:09AM (#40866097)
since we use django, its own migration works best.