read and write locking

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

read and write locking

prog@geniais.com
Hello,
When I try to do a search from one script, returns not found when
another script is writing, even though it is in another record.
How can I make the script that are writing leave free to others for read
only?

Thank you
Ismael


_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: read and write locking

David Raymond
Short version: The database will need to be in WAL mode
https://www.sqlite.org/wal.html


-----Original Message-----
From: sqlite-users [mailto:[hidden email]] On Behalf Of [hidden email]
Sent: Monday, October 01, 2018 9:57 AM
To: [hidden email]
Subject: [sqlite] read and write locking

Hello,
When I try to do a search from one script, returns not found when
another script is writing, even though it is in another record.
How can I make the script that are writing leave free to others for read
only?

Thank you
Ismael


_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users