TLDR Tech / Dev
PSA: Write Transactions are a Footgun with SQLx and SQLite
Using async write transactions that yield with `await` in SQLx with SQLite is a footgun, as it holds the exclusive SQLite write lock across `await`s, leading to lock starvation and performance degradation.
Read the full story