Separate Sqlite Database per Customer?

[dimitarvp]

@homanchou

And my understanding is that sqlite can only have one connection, which might be fine if you guard access using a single genserver.

SQLite has 3 modes of opening a “connection”:

1. A handle usable only by a single OS thread;
2. A handle usable by multiple OS threads;
3. Multiple handles all pointing to the same SQLite database file.

Like @warmwaffles says, you can also open the DB in wal or wal2 mode in combination with any of options 2 and 3 and then your SQLite is effectively like a local Postgres. It would still struggle if there was a big amount of writes per second – I reckon 2000 or more – but most apps needing SQLite don’t do that so…