in reply to Re: Multiuser app with SQLite, Dancer2 and CLI
in thread Multiuser app with SQLite, Dancer2 and CLI
I expect to have much more read accesses than write.
I use AutoCommit => 0, so immediate transactions are used by default. But you made me go through SQLite's documentation (again) : since the DB cannot be read at all while locked for writing, I'll have to deal with SQLITE_BUSY.
In the end, usability will depend mostly on the DB/schema design (fast or slow updates). I'll stick to SQLite for now since I don't have any real-case metrics.
Thanks.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^3: Multiuser app with SQLite, Dancer2 and CLI
by kaldor (Beadle) on Apr 03, 2019 at 19:23 UTC |