Enter your SQLite question at the top of this page and click Get An Answer.
Tell us how quickly you want your SQLite question answered.
Connect with your programmer via online chat or telephone call.
Hi everyone,
I am sort of new to sqlite .. i used it as a database for a php project i am doing .. as you expect whenever two writes operations are done simultaneously one fails reporting "database is locked" ..
I just need to know how to handle this sqlite locking mechanism in PHP .. can I repeat querying if the database was found locked? .. how can i figure out the database is locked and handle it from PHP?
thanks in advance ..
Thank you for your question. I'll do my best to assist you.
You can manage concurrency using the transaction/locking mechanism of sqlite. It is quite as same as in other query languages. Still for your references I am providing two links that you can refer to get some working example/codes for the same:
http://www.sqlite.org/lockingv3.html
http://linuxgazette.net/109/chirico1.html
I hope this answers your question. If it does, please click the Accept Answer button below the answer. If you have any follow-up questions, please post your comments below this answer.
Thanks again.
Dev
Testimonials
Byron Narciso
Programmer
Whether you have a quick question while preparing your taxes, troubleshooting a computer problem, or need to hire an attorney, ExpertHelp is the most convenient and affordable way to connect with the right service professional to get the job done.
ExpertHelp has been in business since 2011, is an A+ Rated Better Business Bureau accredited member, and offers a 100% satisfaction guarantee on every question you ask!