Re: [sqlite] SQLITE_OPEN_READONLY in PHP

2018-10-21 Thread p...@geniais.com
Thanks to Simon Slavin and Tim Streater All replies works fine. Thank you very much Ismael ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLITE_OPEN_READONLY in PHP

2018-10-20 Thread p...@geniais.com
Hello, I'm using a C compiled program to write exclusively to a database, and a php script for reading only (that communicates via socket). I know I can use sqlite3_open_v2() with SQLITE_OPEN_READONLY in C, but there is a way to open a database for readonly in php (since just one C program is

[sqlite] database is locked

2018-10-20 Thread p...@geniais.com
Hello, I'm using exec() to simply get true/false result (just reading) and I'm receiving this error, even in WAL mode: SQLite3::exec(): database is locked in ... on line 47 Any help will be apreciated Thank you Ismael ___ sqlite-users mailing

[sqlite] read and write locking

2018-10-01 Thread p...@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 ___