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

Re: Multiuser app with SQLite, Dancer2 and CLI

by thechartist (Monk)
on Dec 07, 2018 at 04:45 UTC ( #1226860=note: print w/replies, xml ) Need Help??

in reply to Multiuser app with SQLite, Dancer2 and CLI

Written for those who aren't sure when SQLite is a good solution for a website DB

SQLite should be OK for a website that doesn't require many writes to the DB.

From the SQLite project website:

SQLite will normally work fine as the database backend to a website. But if the website is write-intensive or is so busy that it requires multiple servers, then consider using an enterprise-class client/server database engine instead of SQLite. (snip next paragraph)

SQLite supports an unlimited number of simultaneous readers, but it will only allow one writer at any instant in time. For many situations, this is not a problem. Writers queue up. Each application does its database work quickly and moves on, and no lock lasts for more than a few dozen milliseconds. But there are some applications that require more concurrency, and those applications may need to seek a different solution.

  • Comment on Re: Multiuser app with SQLite, Dancer2 and CLI

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (3)
As of 2022-08-15 12:22 GMT
Find Nodes?
    Voting Booth?

    No recent polls found