Re:One year of automatic DB migrations from Git
by o1lab on Tuesday August 04, 2020 @04:56AM
(#24048019)
>> I haven’t written a migration in 1+ years
This.
Above should be the goal of every database backed application framework. A really well balanced post (author is super modest).
>> Dialect support is no picnic.
Are you doing SQL statement parsing here for diff of pg ? This can lead to lot of work if you want to add other databases.
@awinter-py : have a look at our approach to schema migrations - we hand a GUI DB application to devs and it generates schema migrations as you change database. The goal is still the same - backend devs should never write schema migrations.
This.
Above should be the goal of every database backed application framework. A really well balanced post (author is super modest).
>> Dialect support is no picnic.
Are you doing SQL statement parsing here for diff of pg ? This can lead to lot of work if you want to add other databases.
@awinter-py : have a look at our approach to schema migrations - we hand a GUI DB application to devs and it generates schema migrations as you change database. The goal is still the same - backend devs should never write schema migrations.