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 <sc...@casaderobison.com> wrote: On Jun 22, 2016 9:25 PM, "mon siong" <monsi...@yahoo.com> 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 used ? Is either process accessing the files over a networked file system or are both processes on a single computer accessing a local file system? > > > On Thursday, June 23, 2016 11:13 AM, Simon Slavin < slav...@bigfraud.org> wrote: > > > > On 23 Jun 2016, at 3:52am, mon siong <monsi...@yahoo.com> 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. These two work correctly together. You should get no corruption from using these two together. > > Are you using any PRAGMA commands ? > > What is the result of "PRAGMA journal_mode" ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users