News for hackers. Stuff that matters.
Re:We do not use foreign keys (2016) by cryptonector on Friday November 08, 2019 @06:24PM (#21487998)
2b) And keep your schema changes as incremental and backwards-compatible as possible. Add new tables, add columns to tables, but don't drop or rename anything. If you need a flag day, in PG terms just setup a new schema, use triggers to sync the two, and migrate your apps to use the new schema -- when they're all migrated, drop the sync triggers and the old schema.

There are no comments on this comment yet.