Get the latest tech news
What you need to know about SQLite
A compilation of lessons about what the SQLite database engine can and cannot do, how Ruby on Rails helps you work with SQLite, and why it may, or may not, be a good choice to back your Rails 8 app
A lot of credit for these improvements is due to Stephen Margheim (@fractaledmind) whose blog posts, talks, podcast appearances, and pull requests have helped spur a SQLite Renaissance of sorts in the Rails community. PRAGMA synchronous = NORMAL; sync writes every 1000 written pages which improves performance while sacrificing 100% durability meaning there’s a small chance a transaction committed in WAL mode could "roll back following a power loss or system crash." What transpired in that issue thread is a true joy to read: multiple developers collaborating asynchronously to help brainstorm, debug, and ultimately patch a tricky problem (how best to deal with open writable SQLite connections across a forked process).
Or read this on Hacker News