schrodinger 7 days ago

The database schema of an app is tightly coupled enough to essentially be code, and migrations are also probably checked in. This lets you see how the db schema changes over time -- likely along with the queries using the schema.

1
int_19h 6 days ago

This is only true when your app is the only thing that is using the database. In enterprise environments, databases are frequently shared between many different apps.

mnahkies 6 days ago

Sure, and in those cases you'd typically have a dedicated repository storing said schema and migrations.

It's important to manage your schema in code for various reasons from change control to standing up development databases, etc.