Re: [sqlite] Create Read-only Database

2010-10-11 Thread Max Vlasov
On Sun, Oct 10, 2010 at 11:04 PM, Roger Binns 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 write" optio

Re: [sqlite] Create Read-only Database

2010-10-10 Thread Darren Duncan
Cory Nelson wrote: > On Sun, Oct 10, 2010 at 8:51 PM, Darren Duncan > 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 jo

Re: [sqlite] Create Read-only Database

2010-10-10 Thread Cory Nelson
On Sun, Oct 10, 2010 at 8:51 PM, Darren Duncan 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 WAL, it would fail w

Re: [sqlite] Create Read-only Database

2010-10-10 Thread Darren Duncan
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

Re: [sqlite] Create Read-only Database

2010-10-10 Thread Roger Binns
-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

Re: [sqlite] Create Read-only Database

2010-10-10 Thread Bob Keeland
Subject: Re: [sqlite] Create Read-only Database To: "General Discussion of SQLite Database" Date: Sunday, October 10, 2010, 1:53 PM On Sun, Oct 10, 2010 at 9:31 AM, Joshua Grauman wrote: > I have a database that I want to be only read-only. I read in the > optimization FAQ that this

Re: [sqlite] Create Read-only Database

2010-10-10 Thread Bob Keeland
  Bob Keeland --- On Sun, 10/10/10, Roger Binns wrote: From: Roger Binns Subject: Re: [sqlite] Create Read-only Database To: "General Discussion of SQLite Database" Date: Sunday, October 10, 2010, 2:04 PM -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/10/2010 11:53 AM, Max

Re: [sqlite] Create Read-only Database

2010-10-10 Thread Roger Binns
-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 simila

Re: [sqlite] Create Read-only Database

2010-10-10 Thread Max Vlasov
On Sun, Oct 10, 2010 at 9:31 AM, Joshua Grauman 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 write permission