https://www.orchest.io/ logo
Title
e

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: https://www.dbml.org/ but looks like it's still required to build a script that can crawl a database and generate this in the first place.
👀 1
r

Rick Lamers

12/20/2022, 7:27 PM
This reminds me of https://www.dolthub.com/
Have you checked that out?
e

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