My trick is to forbid any non-developer type to touch the production DB with raw SQL. Most of the times they do it wrong, specially when the data model is complex and the fix involves several steps. Explain the problem to a developer and we'll build a console option (backdoor) to fix it.
My trick is to forbid any non-developer type to touch the production DB with raw SQL. Most of the times they do it wrong, specially when the data model is complex and the fix involves several steps. Explain the problem to a developer and we'll build a console option (backdoor) to fix it.
Developers too can mess up SQL. Especially because SQL is easy to learn but hard to master.
Of course, but at least we test the tool before putting it in production.