SQLite is a powerful database engine, but due to its design, it has limitations that should not be overlooked. Jellyfin has used a SQLite-based database for storing most of its data for years, but it has also encountered issues on many systems. In this blog post, I will explain how we address these limitations and how developers using SQLite can apply the same solutions. This will be a technical blog post intended for developers and everyone wanting to learn about concurrency. Also Jellyfin's im...