
Database monitoring utilities
We had some bugs in our web application and it led to bad data entering the database and eventually crashing our service. It was happening intermittently and had low priority so it wasn't patched quickly enough. To catch the errors I scripted a quick monitoring utility which ran the needed queries and compared the result sets. This became pretty useful so I created a more refined version and made it open source. It supports Postgres, SQL Server, MySQL and SQLite. Its also available as a docker image if you wanted to try it.
Source code: https://github.com/leoCorso/DBGuard-Web/releases/tag/1.0.0
Do you guys think something like this is useful? Are there any pitfalls or improvements you think of? Looking to improve the utility.
u/taohz — 3 days ago