[Richard Hipp]
If the last writer to the database file crashed and left a hot
journalhttp://www.sqlite.org/atomiccommit.html#section_4_2then the
next reader to come along must rollback that journal before it can
start reading, and that will require write access.
Can similar things happen if
On 7 Sep 2012, at 1:19pm, Steinar Midtskogen stei...@latinitas.org wrote:
[Richard Hipp]
If the last writer to the database file crashed and left a hot
journalhttp://www.sqlite.org/atomiccommit.html#section_4_2then the
next reader to come along must rollback that journal before it can
Can sqlite databases be read from a read-only media? I seem to remember
seeing something about this on the website, but can't find it.
--
˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı
___
sqlite-users mailing list
sqlite-users@sqlite.org
]
Sent: Thursday, September 06, 2012 8:39 AM
To: General Discussion of SQLite Database
Subject: EXT :[sqlite] Read-only media
Can sqlite databases be read from a read-only media? I seem to remember
seeing something about this on the website, but can't find it.
--
˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ
Can sqlite databases be read from a read-only media? I seem to remember
seeing something about this on the website, but can't find it.
Adding on to Michael's reply, you may need to ensure that you have a writeable
location for the temp_store depending on what queries you issue.
On Thu, Sep 6, 2012 at 9:39 AM, Baruch Burstein bmburst...@gmail.comwrote:
Can sqlite databases be read from a read-only media? I seem to remember
seeing something about this on the website, but can't find it.
Usually.
If the last writer to the database file crashed and left a hot
On 6 Sep 2012, at 3:13pm, Richard Hipp d...@sqlite.org wrote:
If the last writer to the database file crashed and left a hot
journalhttp://www.sqlite.org/atomiccommit.html#section_4_2then the
next reader to come along must rollback that journal before it can
start reading, and that will
On Thu, Sep 6, 2012 at 10:26 AM, Simon Slavin slav...@bigfraud.org wrote:
On 6 Sep 2012, at 3:13pm, Richard Hipp d...@sqlite.org wrote:
Suppose you open a database in read-only mode (using SQLITE_OPEN_READONLY)
and SQLite finds a hot journal for it. Is tidying up the hot journal done
even
On 6 Sep 2012, at 3:40pm, Richard Hipp d...@sqlite.org wrote:
When SQLITE_OPEN_READONLY is used, then the file might as well be on CDROM
as far as SQLite is concerned. It won't write to it. Even to rollback a
hot journal.
Thanks. That makes sense.
Simon.
On Thu, Sep 6, 2012 at 5:26 PM, Simon Slavin slav...@bigfraud.org wrote:
On 6 Sep 2012, at 3:13pm, Richard Hipp d...@sqlite.org wrote:
If the last writer to the database file crashed and left a hot
journalhttp://www.sqlite.org/atomiccommit.html#section_4_2then the
next reader to come
10 matches
Mail list logo