News for hackers. Stuff that matters.
Re:PostgreSQL IDE in VS Code by schrodinger on Friday May 23, 2025 @10:27PM (#44078300)
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.
Re:PostgreSQL IDE in VS Code by int_19h on Saturday May 24, 2025 @03:39AM (#44079483)
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.
Re:PostgreSQL IDE in VS Code by mnahkies on Saturday May 24, 2025 @05:35AM (#44079911)
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.