note 41141 added to ref.sqlite
| From: | cricket at djcricket dot com | Date: | Wed, 31 Mar 2004 14:30:13 +0000 |
| Subject: | note 41141 added to ref.sqlite | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-67419@lists.php.net to get a copy of this message | ||
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.
----
Manual Page -- http://www.php.net/manual/en/ref.sqlite.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+41141
Delete -- http://master.php.net/manage/user-notes.php?action=delete+41141&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+41141&report=yes
Search -- http://master.php.net/manage/user-notes.php