transactions

sqlite-utils 4.0rc1 is a release candidate that adds built-in database migrations (ported from sqlite-migrate) and nested transactions via db.atomic(), along with minor backwards-incompatible changes.

The article analyzes inherent concurrency bugs in SQL, such as atomicity failures, TOCTOU issues, and deadlocks, using a money transfer example to demonstrate correct locking and transaction practices.