Re: [sqlite] SQlite database corrupt , PHP and multithread C program accessing same database

Both processes on a single computer accessing a local file system. The sqlite file is store in USB drive , and I notice if the database corrupt , the journal or shm file is also corrupt .  On Thursday, June 23, 2016 12:48 PM, Scott Robison wrote: On Jun

Re: [sqlite] SQlite database corrupt , PHP and multithread C program accessing same database

On Jun 22, 2016 9:25 PM, "mon siong" wrote: > > > PHP use 3.7.7.1 and my c program use 3.8.4.3 . Different version of sqlite is fine ? > I tried WAL and Delete Journal Mode , both type cause the db to corrupt . > > Under which scenario, two different global variables will be

Re: [sqlite] SQlite database corrupt , PHP and multithread C program accessing same database

On Wed, Jun 22, 2016 at 8:13 PM, Simon Slavin wrote: > On 23 Jun 2016, at 3:52am, mon siong wrote: >> PHP is using sqlite3 library (http://php.net/manual/en/book.sqlite3.php) >> and C program is handle the sqlite using Serialized. >> >> Both of them are

[sqlite] System.Data.SQLite version 1.0.102.0 released

System.Data.SQLite version 1.0.102.0 (with SQLite 3.13.0) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the

Re: [sqlite] SQlite database corrupt , PHP and multithread C program accessing same database

PHP use 3.7.7.1 and my c program use 3.8.4.3 . Different version of sqlite is fine ? I tried WAL and Delete Journal Mode , both type cause the db to corrupt . Under which scenario, two different global variables will be used ? On Thursday, June 23, 2016 11:13 AM, Simon Slavin

Re: [sqlite] SQlite database corrupt , PHP and multithread C program accessing same database

On 23 Jun 2016, at 3:52am, mon siong wrote: > PHP is using sqlite3 library (http://php.net/manual/en/book.sqlite3.php) > and C program is handle the sqlite using Serialized. > > Both of them are accessing the same DB at the same time . This can cause DB > corrupt ? No.

[sqlite] SQlite database corrupt , PHP and multithread C program accessing same database

 Hello My sqlite database corrupt recently, I suspecting this is due to the two different instances of SQLIte running on unix . And two different global variables is used . (By refering to the thread: http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/2016-May/066648.html) We

[sqlite] SQLITE_OMIT_VIRTUALTABLE compilation error

Hello, When using SQLITE_OMIT_VIRTUALTABLE compilation option, there is a compilation error in where.c!whereLoopAddAll (with whereLoopAddVirtual()) ){ ) I think you must enclose it in : #ifndef SQLITE_OMIT_VIRTUALTABLE if( IsVirtual(pItem->pTab) ){ struct SrcList_item *p;