SQLITE CONCURRENCY AND WHY YOU SHOULD CARE ABOUT IT

Summary from the TLDR Dev newsletter

SQLite can suffer from database locking issues, especially during transactions. Jellyfin implemented three locking strategies: No-Lock, Optimistic locking (retry on failure), and Pessimistic locking (exclusive write lock) to mitigate these problems. The new locking strategies improved stability, providing users with options to avoid locking issues.