Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: DBD::SqLite issue while accessing DB from multiple processes

by dsheroh (Parson)
on Feb 05, 2014 at 08:51 UTC ( #1073532=note: print w/ replies, xml ) Need Help??


in reply to DBD::SqLite issue while accessing DB from multiple processes

SQLite isn't really designed to handle concurrency. If you're dead-set on accessing an SQLite database from multiple processes, then you're going to need to write the code to detect and handle errors of this type for yourself.

The saner approach would be to switch to a database engine which is designed to handle concurrency, such as PostgreSQL, MySQL, etc. It would be much easier, plus it would provide a solution which is vastly more robust than any kind of homebrew concurrency handling is likely to be.


Comment on Re: DBD::SqLite issue while accessing DB from multiple processes

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (10)
As of 2014-11-28 16:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My preferred Perl binaries come from:














    Results (198 votes), past polls