News for hackers. Stuff that matters.

A comment on For Want of a JOIN. Parent comment

Re:For Want of a JOIN by joeblubaugh on Thursday December 22, 2022 @10:47AM (#34094529)
How easy is it to verify that the configuration of your database matches a checked-in configuration or source file these days? My beef with a lot of installed procedures in a SQL database comes down to deployment and rollback difficulty.
[ Parent | on HN ]
Re:For Want of a JOIN by mh- on Thursday December 22, 2022 @11:53AM (#34095449)
Depends on the DBMS, but pt-config-diff works well for MySQL.

edit: This will only help for configuration, not procedures.

https://docs.percona.com/percona-toolkit/pt-config-diff.html

[ Parent | on HN ]
Re:For Want of a JOIN by Wicher on Thursday December 22, 2022 @11:02PM (#34102221)
For Postgres views, materialized views, functions and triggers I've made a tool that can do that, DBSamizdat:

https://sr.ht/~nullenenenen/DBSamizdat

[ Parent | on HN ]