Reading all of these makes me think, the admin tool for your database of choice should probably put you inside a transaction by default, and require you to expl

Reading all of these makes me think, the admin tool for your database of choice should probably put you inside a transaction by default, and require you to explicitly commit changes. For the madmen, it could still have an auto-commit mode, but should be opt-in rather than the default.