Hacker News new | ask | show | jobs
by o1lab 2142 days ago
>> 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.