News for hackers. Stuff that matters.
Re:Many small queries are efficient in SQLite by hnlmorg on Tuesday February 16, 2021 @06:21AM (#26152909)
My point is that using transactions should be drilled into people who work on databases and where consistency is a requirement because transactions turn multiple complex SQL requests into one atomic operation:

http://db4beginners.com/blog/relationaldb-transaction/

Re:Many small queries are efficient in SQLite by Aeolun on Thursday February 18, 2021 @07:45AM (#26179165)
Oh, I agree. It’s just that my recent experiences have included mostly people foreign to both transactions and foreign keys.