Re:Node.js 16 Available Now
by btown on Tuesday April 20, 2021 @03:50PM
(#26880495)
I'm curious how you handle migrations and schema documentation, which to me are the huge benefit of using something like Django or ActiveRecord. Do you version-control at least your forward-migrations as SQL or SQL-via-Slonik? And do you have processes in place to ensure columns are documented in a central location?
[ Parent
| on HN ]
Re:Node.js 16 Available Now
by hn_throwaway_99 on Wednesday April 21, 2021 @09:44AM
(#26889586)
For migrations we actually use knex, but primarily just because it was in place first before I knew about Slonik.
Writing a migration tool is pretty trivially easy - all knex does is let you write an up migration and a down migration, and it keeps track of which migrations have been applied in a DB table. Main thing is that all of our migrations are each in an individual versioned file in our source repo.
We use postgres COMMENT functionality to apply comments to all of our table columns.