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

[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.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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, I don't want anybody to view/edit the database contents from any
>> database browsers.
>> Could you please suggest me, how can i achieve this?
>
>Since an SQLite database is a file, you could just set the file system
>privileges to read-only.

That would prevent write access for the application.

Depending on the circumstances, it might be possible to use ACL or
user:group ownership and account/group/other permissions to black access
to the database file for every user:group, except the application
user:group.

Another possibility is database encryption, in a way that only the
application can know the key. See http://sqlite.org/support.html

-- 
Groet, Cordialement, Pozdrawiam, Regards,

Kees Nuyt

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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
> database browsers.
> Could you please suggest me, how can i achieve this?

Since an SQLite database is a file, you could just set the file system
privileges to read-only.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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 this?

Thanks in advance and looking forward to hear from you.

Sincerely,
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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, something at the OS level thinks something has an exclusive
lock on the file.
- What precisely is telling you the database is locked?  Custom error
handler, or can you access via the sqlite command line?

Best bet, as mentioned, is to reboot and see what happens.  If you still
can't get access, I'm pointing my finger at corruption.


On Fri, Feb 8, 2013 at 7:17 AM, Simon Slavin  wrote:

>
> 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 the operating system
> and rebooting the computer (if you can't find a simpler way) should unlock
> everything.
>
> If you are getting an error message of some kind from a SQLite function,
> tell us what it is and we may be able to help you.  If your error message
> is coming from your OS we probably can't.
>
> > Is there some method to ensure that if the indexing process is
> interrupted
> > that sqlite rolls back - I have jounalling on and journal mode is set to
> > delete.
>
> As part of opening a database SQLite will automatically notice and
> rollback all incomplete commands including indexing.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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 the operating system and rebooting the 
computer (if you can't find a simpler way) should unlock everything.

If you are getting an error message of some kind from a SQLite function, tell 
us what it is and we may be able to help you.  If your error message is coming 
from your OS we probably can't.

> Is there some method to ensure that if the indexing process is interrupted
> that sqlite rolls back - I have jounalling on and journal mode is set to
> delete.

As part of opening a database SQLite will automatically notice and rollback all 
incomplete commands including indexing.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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 normally only ever be read by a single instance of my
program and after the database has been created and the user starts to
interact with it the updates are generally quite minimal

The db is over a GB in size and I believe that I can use an sqlite backup
to create a new unlocked copy but this is a bit slow and cumbersome.

Is there a faster method for clearing a lock?

Is there some method to ensure that if the indexing process is interrupted
that sqlite rolls back - I have jounalling on and journal mode is set to
delete.

Thanks.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users