News for hackers. Stuff that matters.
Re:SQLite is not a toy database by lsb on Thursday March 25, 2021 @01:38PM (#26583116)
If you are in WAL mode, you can have unlimited readers as one writer is writing.
Re:SQLite is not a toy database by mastre_ on Thursday March 25, 2021 @03:05PM (#26584091)
Also, another issue when not in WAL mode is that a long read will actually have a write lock and block writes.