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

    That was me posting here, by mistake as anonymous.

    Again, thank you all for your answers.