Search Articles

Search Results: ConcurrencyControl

Taming SQLite Concurrency: How Jellyfin Engineered Locking Strategies for Stability

Taming SQLite Concurrency: How Jellyfin Engineered Locking Strategies for Stability

Jellyfin reveals its battle-tested framework for solving elusive SQLite locking errors that plagued its media server. Discover how EF Core interceptors enable three distinct concurrency strategies—from optimistic retries to pessimistic locks—offering developers a blueprint for resilient database operations.
Morty: How Re-Execution Shatters Concurrency Limits in Distributed Databases

Morty: How Re-Execution Shatters Concurrency Limits in Distributed Databases

A groundbreaking EuroSys '23 paper introduces Morty, a system that revolutionizes serializable transactions by selectively re-executing only stale portions of workloads instead of aborting entire operations. This approach slashes contention-induced delays, achieving up to 96x higher throughput than Spanner-style systems under load. Morty's fusion of continuation-passing style APIs and speculative ordering offers a paradigm shift for high-performance distributed databases.