3 ms·

I don't get it. Isn't any good SQL ORM provide their own DSLs for migrations?

• orf 10y ago
  Yes. Look, take for example the Django ORM. You specify the models in a python file. These are the central source of truth for what your database tables look like. If you want to add a column or change something in the schema you then generate the migrations from that. The migrations don't drive your schema, the schema drives the migrations. Proper tools don't make you have a bunch of .SQL files that organise your database.
  • pekk 10y ago
    Devil's advocate - how is it really better to have a bunch of autogenerated Django migration files?
    • orf 10y ago
      Better than what?
  • yawaramin 10y ago
    Can the Django ORM support migrations of stored procs, custom types, and other non-tabular entities?