News for hackers. Stuff that matters.

A comment on How I destroyed the company's DB (a stupid SQL mistake). Parent comment

Re:How I destroyed the company's DB (a stupid SQL mistake) by syslog on Monday January 01, 2024 @01:30PM (#38834061)
A decent database has transactions, so you can rollback your fat-fingered queries.
[ Parent | on HN ]
Re:How I destroyed the company's DB (a stupid SQL mistake) by cafard on Wednesday January 03, 2024 @10:06AM (#38854898)
Postgres and SQL Server have always had transactions; but unless you frame your DML in BEGIN TRANSACTION/[COMMIT|ROLLBACK], each statement is committed as executed.

If you broke in on Oracle, where you must explicitly commit statements (unless your client sets up auto-commit), this can take some getting used to.

[ Parent | on HN ]