Eshwaran Venkat

12/20/2022, 2:42 PM
Hey Orchest community! Wanted to get your opinion on something. Wondering if it's good practice to administer a SQL database using "database-as-code" tools? The idea is to have the terraform equivalent for databases in order to: • Add, remove or rename columns and track these changes in git • Modify constraints and relations and track these too • Avoid using SQL clients to make changes but instead make changes from a central "skeleton" programatically • Double-down as database documentation as well Found this: but looks like it's still required to build a script that can crawl a database and generate this in the first place.
👀 1

Rick Lamers

12/20/2022, 7:27 PM
This reminds me of
Have you checked that out?

Eshwaran Venkat

12/23/2022, 3:08 PM
Nice, I thought it was only for versioning data but looks like it handles configs too. Thanks!
👌 1