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.
[ Parent
| on HN ]
There are no comments on this comment yet.