note 116005 modified in sqlite3.exec by salathe
| From: | salathe@php.net | Date: | Fri, 07 Nov 2014 10:21:56 +0000 |
| Subject: | note 116005 modified in sqlite3.exec by salathe | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-200807@lists.php.net to get a copy of this message | ||
If you use WAL (Write-Ahead Log) (link to sqlite doc for this: http://sqlite.org/wal.html ), it needs write acces because of
the implementation of multi-thread access to one db. You can turn it off, if you do not want to give
the dir write access, but you can also create a certain file it needs (see the link for a
description, as it is explained very well there) that you need write access to and you may get away
using WAL without giving write accesss to the dir.
--was--
If you see one or more notes here stating that you need write access to the directory your db is in,
than consider them explained. If you do not see any of them, just ignore the first paragraph in this
note.
So, if you use WAL (Write-Ahead Log) (link to sqlite doc for this: http://sqlite.org/wal.html ), it needs write acces because of
the implementation of multi-thread access to one db. You can turn it off, if you do not want to give
the dir write access, but you can also create a certain file it needs (see the link for a
description, as it is explained very well there) that you need write access to and you may get away
using WAL without giving write accesss to the dir.
http://php.net/manual/en/sqlite3.exec.php