Hasnain says:

I can’t wait for the follow up post here - this was really interesting.

“But it certainly has its trade-offs. Kicking out all other transactions whenever you need to write something can become a bottleneck for many applications that have concurrent users. When people say that SQLite doesn't scale, it's typically because they used the rollback journal.

However, SQLite continued to improve and eventually introduced the write-ahead log (WAL) journaling mode and even the wal2 journaling mode. These provide significantly better support for concurrent readers.”

Posted on 2022-08-10T16:00:14+0000