Ha, I half-remembered this existing and tried to Google my way to it, but to no avail. Thanks so much for the pointer!

In a huge database, even a SELECT with no WHERE clause can tie up considerable resources.

I always write my WHERE clauses first whenever I do anything on a live dataset.

I always had a rule to do everything inside a transaction. Having to commit a transaction gives you just enough pause to double check what you've done.

It's funny because I bookmarked this on pinboard.in