On Sun, Oct 10, 2010 at 11:04 PM, Roger Binns rog...@rogerbinns.com wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/10/2010 11:53 AM, Max Vlasov wrote:
Also if you're not content with this option, you can always open the file
(just as a general file) prior to sqlite with a deny
On Sun, Oct 10, 2010 at 9:31 AM, Joshua Grauman j...@grauman.com wrote:
I have a database that I want to be only read-only. I read in the
optimization FAQ that this will make sqlite not create a journal and so
run faster. I changed the permissions of my database file in Linux
(removed the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/10/2010 11:53 AM, Max Vlasov wrote:
Also if you're not content with this option, you can always open the file
(just as a general file) prior to sqlite with a deny write option. I'm
aware of such feature in Windows/Win32, I'm sure a similar
, 10/10/10, Roger Binns rog...@rogerbinns.com wrote:
From: Roger Binns rog...@rogerbinns.com
Subject: Re: [sqlite] Create Read-only Database
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Date: Sunday, October 10, 2010, 2:04 PM
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10
:
From: Max Vlasov max.vla...@gmail.com
Subject: Re: [sqlite] Create Read-only Database
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Date: Sunday, October 10, 2010, 1:53 PM
On Sun, Oct 10, 2010 at 9:31 AM, Joshua Grauman j...@grauman.com wrote:
I have a database that I want
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/10/2010 02:55 PM, Bob Keeland wrote:
but there are cases in which the user will, in the vast majority of cases,
not have the knowledge to update the database.
None of what I wrote has *anything* to do with users. It was entirely
scenarios
Roger Binns wrote:
Going back to Joshua's original question, by default a SQLite database is
not read-only even if you think it is. The major reason is that even if you
wanted to use it read-only, the previous program may have had it open for
writing, and may have crashed in the middle of a
On Sun, Oct 10, 2010 at 8:51 PM, Darren Duncan dar...@darrenduncan.net wrote:
I think that it should be possible to configure SQLite to be strictly
read-only
in every respect, such that if with such configuration SQLite is told to open
a
database that would need updating from a journal or
Cory Nelson wrote:
On Sun, Oct 10, 2010 at 8:51 PM, Darren Duncan dar...@darrenduncan.net
wrote:
I think that it should be possible to configure SQLite to be strictly
read-only
in every respect, such that if with such configuration SQLite is told to
open a
database that would need
I have a database that I want to be only read-only. I read in the
optimization FAQ that this will make sqlite not create a journal and so
run faster. I changed the permissions of my database file in Linux
(removed the write permission), and sqlite was still able to create a new
table. Since
10 matches
Mail list logo