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 used 
for writing)?
Thank you for help
Ismael

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


[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 list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


[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


___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users