The paradox is that every device I use interrupts me non-stop with modal dialogs ad nauseam.
But the production delete? You said,"drop", we said, "gone".
Either production database deletes need to adopt alert fatigue or the ops are already so fatigued that it doesn't matter.
Even fatigued, "DELETE 1182900" tends to stick out, if you're used to, and expecting to, see "DELETE 1".
("BEGIN" appears to be PostgreSQLism, "START TRANSACTION" is more standard.)
Also frankly I think most software does it wrong, if it is possible it shouldn't ask before delete but just allow to undo the step easily. Then work can go fast and uninterrupted while still being resilient to mistakes. Obviously not possible everywhere but where it is it should be the default.
Obviously. When undoing is not easy or possible automatically, there is the "Are you really really sure?" dialog.
Pop-up warnings that are too common are a problem itself. People get so used to accepting them immediately that they stop serving their purpose and just become an annoyance. With one exception: they can prevent misclicks.
https://en.wikipedia.org/wiki/Alarm_fatigue
The misclick point is beyond truth, particularly given the storm of marketing that is mobile web.