SQLite and Concurrency: The Lockout Experienced at islistesi.com A few weeks ago, the SQLite database I use to ensure data consistency in a production ERP system gave me serious trouble with an unexpected lockout (lock) issue. Specifically, I encountered situations where certain operations would get stuck, and the system would become unresponsive, especially during high-volume transactions and concurrent access. Although this situation resembled performance problems I'd previously experienced with a large e-commerce site, the root cause was different: the limitations of SQLite's own concurrency model. In this post, I will share my personal experience with the SQLite concurrency issue I faced in the islistesi.com project, detailing the lockouts, the debugging process, and the solutions I ultimately found. While I generally prefer more advanced databases like PostgreSQL for my own projects, SQLite's simplicity and lightweight nature can sometimes be appealing in certain scenarios.…