Write Transactions Are a Footgun with Rust's SQLx and SQLite (opens in new tab)

Write transactions can lead to lock starvation and serious performance degradation when using SQLite with SQLx, the popular async Rust SQL library. In retros...