note 41141 deleted from ref.sqlite by cmb

From: Date: Mon, 02 Nov 2020 14:57:05 +0000
Subject: note 41141 deleted from ref.sqlite by cmb
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-215711@lists.php.net to get a copy of this message
Note Submitter: cricket at djcricket dot com ---- To elaborate on vpupkin at comcast dot net's post about the INSERT query problem, you will be unable to execute any manipulation queries (INSERT/UPDATE/DELETE/ect) on the SQLite database file unless the directory the SQLite database file resides in is writable by the webserver. The reason for this is because SQLite needs to write a lock file to the hard drive. After a processes finishes writting, it deletes the lock file. Other processes check for the lock file before writting to the SQLite database file and if present, delay writting until the lock file is no longer present.

« previous php.notes (#215711) next »