Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

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: https://www.sqlite.org/whentouse.html

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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1226860]
help
Chatterbox?
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: (1)
As of 2020-10-25 16:43 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My favourite web site is:












    Results (249 votes). Check out past polls.

    Notices?