4 ms·

In all seriousness, ever since SQLite got WAL support, it's been fine for light multiuser systems. I would define "multiuser" as "around ten or fewer concurrent

by gecko 10y ago

In all seriousness, ever since SQLite got WAL support, it's been fine for light multiuser systems. I would define "multiuser" as "around ten or fewer concurrent users", and I think there are some major backup considerations that go with this, but I don't think it's an inherent nonstarter.

Thetawaves 10y ago
WAL still requires a table level write lock.
- batbomb 10y ago
  SQLite uses only file locking.
  - rarrrrrr 10y ago
    That was true for a long time, but newer sqlite can do table level locking when in shared cache mode. Section 2.2 here: https://www.sqlite.org/sharedcache.html https://www.sqlite.org/sharedcache.html