Re: [sqlite] Lock Database temporarily.

2013-01-09 Thread Christopher Vance
It sounds to me like your question has nothing to do with SQLite and everything to do with the operating system your app is (not) running on. What facilities does your OS have to stop anything or anybody writing a file? How do you propose to relax these facilities to enable your app to write the

Re: [sqlite] Lock Database temporarily.

2013-01-09 Thread sants87
Simon, To answer your question, I want to stop modification when my app is not running/alive. -- View this message in context: http://sqlite.1065341.n5.nabble.com/Lock-Database-temporarily-tp66434p66454.html Sent from the SQLite mailing list archive at Nabble.com.

Re: [sqlite] Lock Database temporarily.

2013-01-09 Thread sants87
Thanks Simon/devienne Donald, I just want my app to use the database. But as the database resides in a common easy accessible location I want to lock the database or prevent any access to it. I don't want other apps or even user using that database. I just want to block the writes. I am fine

Re: [sqlite] Lock Database temporarily.

2013-01-08 Thread Donald Griggs
Regarding:*...and I require to lock the database **from any third party modification.* I know you wrote "modification," but I wondered if you have : a) a requirement to prevent even *reading* of the database by outsider programs. b) a requirement to ALLOW *reading* of the database by

Re: [sqlite] Lock Database temporarily.

2013-01-08 Thread Simon Slavin
On 8 Jan 2013, at 3:22pm, Dominique Devienne wrote: > Perhaps Santosh meant other SQLite-using 3rd party apps, as opposed to > anyone able to modify the DB file as you mentioned. Good point. Santosh, were you concerned about someone modifying the file while your

Re: [sqlite] Lock Database temporarily.

2013-01-08 Thread Dominique Devienne
On Tue, Jan 8, 2013 at 2:17 PM, Simon Slavin wrote: > On 7 Jan 2013, at 4:46pm, sants87 wrote: > >> Hi I am using Sqlite3 for my application and I require to lock the database >> from any third party modification. Accessing database is fine but I

Re: [sqlite] Lock Database temporarily.

2013-01-08 Thread Simon Slavin
On 7 Jan 2013, at 4:46pm, sants87 wrote: > Hi I am using Sqlite3 for my application and I require to lock the database > from any third party modification. Accessing database is fine but I don't > want others to modify the same. i tried Sqlite encryption but that is not

[sqlite] Lock Database temporarily.

2013-01-08 Thread sants87
Hi I am using Sqlite3 for my application and I require to lock the database from any third party modification. Accessing database is fine but I don't want others to modify the same. i tried Sqlite encryption but that is not available for free. Is there other ways to achieve the same? Thanks