SQL migrations should be written in plain DDL/DML, without any SQL abstraction layer.
You will thank me when you'll have to figure out a migration gone sideways in-flight, and won't end up debugging the SQL abstraction.
SQL migrations should be written in plain DDL/DML, without any SQL abstraction layer.
You will thank me when you'll have to figure out a migration gone sideways in-flight, and won't end up debugging the SQL abstraction.
Also, thanks IntelliJ for allowing me to highlight the DB connections before I mess something up gloriously.
I really don't like getting close to customer data manually.
@Kynx my regular user does **not** have production access, luckily.
As for how to do that: