Then you have to remember to enable WAL mode. And it still has its caveats, but different ones: it's possible that the WAL file can grow without bound under certain conditions.
You know it never occurred to me that there's probably a whole new generation (experience wise at least) of programmers who 1) know SQLIte is commonly used for web backends now but 2) don't know about WAL mode.
To me the concept of SQLite in these scenarios, without the WAL, is just nuts.
To me the concept of SQLite in these scenarios, without the WAL, is just nuts.