2 ms·
> I know a lot of folks are huge fans of writing pure SQL, the lack of type safety and lack of good intergration with source control (I dream of a world where d
by nextaccountic 5y ago
> I know a lot of folks are huge fans of writing pure SQL, the lack of type safety and lack of good intergration with source control (I dream of a world where database schemas, functions, security access and the rest can be saved to source control for reproducibility) scare me.
Hey there are some migration tools that play nice with source control. For example, Flyway has repeatable migrations https://flywaydb.org/documentation/tutorials/repeatable https://flywaydb.org/documentation/tutorials/repeatable, here's some links about this
https://stackoverflow.com/questions/25839666/flyway-strategy-for-migrating-frequently-changing-functions-stored-procedures https://stackoverflow.com/questions/25839666/flyway-strategy...
https://github.com/flyway/flyway/issues/819 https://github.com/flyway/flyway/issues/819
https://github.com/flyway/flyway/issues/128 https://github.com/flyway/flyway/issues/128
- tianzhou 5y agoThere's a new one in this field bytebase.com (Disclaimer, I am the author of it)