4 ms·
I mean you could, but it’d need to be through some kind of migration system to update it.
by 0xCMP 9y ago
I mean you could, but it’d need to be through some kind of migration system to update it.
- other_herbert 9y agoFlyway for Java... For stored procedures you use the repeatable syntax that way it checks the checksum of the file and if it doesn't match what is in the migration table it will run it... Easy and always up to date... That's with Java anyway...
- zkomp 9y agoThere are several such tools, which are specialized and thus tend to perform a better job than orms (who try to do everything) But I would recommend writing, reviewing and deploying migrations by hand, esp for critical parts of the schema (automatic tools are almost guaranteed to get something wrong, with locking etc)