Re: [sqlite] Fwd: How to prevent View sqlite database structure and contents from database browsers

2013-02-08 Thread Kees Nuyt
On Fri, 08 Feb 2013 19:46:49 +0100, Kees Nuyt wrote: > ... to black access ... ... to block access ... Note to self: proofread thoroughly. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.or

Re: [sqlite] Fwd: How to prevent View sqlite database structure and contents from database browsers

2013-02-08 Thread Kees Nuyt
On Fri, 08 Feb 2013 14:20:20 +0100, Robert Hairgrove wrote: >On Fri, 2013-02-08 at 13:13 +, SR Volatile wrote: >> Dear Sir/Madam, >> >> I am using Sqlite for my project. Currently, Sqlite database browser able >> to view / edit sqlite database structure and content. As part of my >> project,

Re: [sqlite] Fwd: How to prevent View sqlite database structure and contents from database browsers

2013-02-08 Thread Robert Hairgrove
On Fri, 2013-02-08 at 13:13 +, SR Volatile wrote: > Dear Sir/Madam, > > I am using Sqlite for my project. Currently, Sqlite database browser able > to view / edit sqlite database structure and content. As part of my > project, I don't want anybody to view/edit the database contents from any >

[sqlite] Fwd: How to prevent View sqlite database structure and contents from database browsers

2013-02-08 Thread SR Volatile
Dear Sir/Madam, I am using Sqlite for my project. Currently, Sqlite database browser able to view / edit sqlite database structure and content. As part of my project, I don't want anybody to view/edit the database contents from any database browsers. Could you please suggest me, how can i achieve

Re: [sqlite] Unlocking locked database and preventing locking to start with

2013-02-08 Thread Stephen Chrzanowski
"Smells" like database corruption, but I can't say for certain as there could be a couple things holding back. - If a rogue thread that isn't killed has its finger on it, it could prevent further access, but that'd depend on whether you're doing a full file lock with that thread. - As mentioned, s

Re: [sqlite] Unlocking locked database and preventing locking to start with

2013-02-08 Thread Simon Slavin
On 8 Feb 2013, at 8:57am, Paul Sanderson wrote: > Is there a faster method for clearing a lock? SQLite does not use a persistent locking mechanism. It doesn't write something to the file saying "this file is locked" and refuse to open a file with that status. Lock status is maintained by th

[sqlite] Unlocking locked database and preventing locking to start with

2013-02-08 Thread Paul Sanderson
I have a user who has a locked database. I don't know why the db is locked but suspect either he killed the program when it was adding an index or my program crashed (he was using a beta version). Irrespective of wghich he has a db that is locked and I'd like to unlock it. My database would normal