Another db question! I'm using migration files whenever I make a change to the db. When I'm doing dev, whats a good source of truth for the current structure of the tables (column names, types and so on)? I could app switch to my db admin app but I'd prefer a quick way to reference inside VS Code #sql
@joelanman
Are you talking about DB migration and change management? Not sure about the JS world, but Flyway and Liquibase are used pretty extensively in the Java world.
Squitch is another interesting one that uses a change graph instead of a set of linear changes.
@NathanClayton No just day to day dev, needing to quickly know what the column names and types are. I now have a plugin for Vs code that lets me see this live on the db
Aah, ok. That makes sense. If you use any of the paid JetBrains IDEs, they have great DB functionality built in. In Eclipse you can install SquirrelSQL in the IDE for free, and there's the plugins for VS Code that you've got.
Add comment