Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

Re^2: Multiuser app with SQLite, Dancer2 and CLI

by Anonymous Monk
on Dec 07, 2018 at 15:21 UTC ( #1226897=note: print w/replies, xml ) Need Help??

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.


Replies are listed 'Best First'.
Re^3: Multiuser app with SQLite, Dancer2 and CLI
by kaldor (Sexton) on Apr 03, 2019 at 19:23 UTC

    That was me posting here, by mistake as anonymous.

    Again, thank you all for your answers.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1226897]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (5)
As of 2022-12-05 08:20 GMT
Find Nodes?
    Voting Booth?

    No recent polls found