3 ms·
Or write the query as a function in code, that way, everyone can know it exists, call it easily, and change it along with any other changes to your logic or sch
by Ozzie_osman 1y ago
Or write the query as a function in code, that way, everyone can know it exists, call it easily, and change it along with any other changes to your logic or schema.
- sgarland 1y agoSo now you have to launch a special debug instance of your app that doesn't accept prod traffic, but can still connect to the prod DB, so you can shell into it and call the function? You can and should store SQL queries in VCS. Everyone can still know that they're there.
- physicles 1y agoAre there good tools that can dump a database schema to files that are human- and AI-readable? We use migrations as the source of truth for the prod database schema, but they’re also a pain when you want to just see the latest version of a table or a stored procedure.
- sgarland 1y agomysqldump --nodata pg_dump --schema-only Read tool docs for other options, like restricting to a specific DB or table, but that’s the basic gist of it.