Re: [sqlite] [Query] Sqlite

[Brian Curley]

What's your question on SQLite?

(The sqlite-users@sqlite.org address is fairly straightforward.  It's sort
of like a forum style of help, where you ask your question via e-mail and
90-95% of the answers come from roughly 10 seemingly never-sleeping experts
from around the English-speaking world. The other 5-10% of the answers come
from dozens of other experts and heavy users, very few of which are
completely off-track.  Beyond that, it's all archived online for future
reference, so you might actually find your question was already posed and
answered in the past.)

On Thu, Nov 1, 2012 at 7:28 AM, Rajkumar  wrote:

> Sir/Madam,
>
> I am preparing to develop two applications using following technologies:
>
> 1. Adobe AIR + Android +Sqlite
> 2. QT + Embedded Linux + Sqlite
>
> Before I start my development, I would like to clarify few things on sqlite
> as I am new to this.
>
> Kindly acquaint me how getting help works with "sqlite-users@sqlite.org".
>
> --
> Regards,
> Raj
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Regards.

Brian P Curley
  home: 845 778-5937
  cell: 845 548-4377
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Query Sqlite lock state

[Marcus Grimm]

Igor Tandetnik wrote:
> "Marcus Grimm" <[EMAIL PROTECTED]> wrote
> in message news:[EMAIL PROTECTED]
>> is there a way to query if the database file is currently locked ?
> 
> How would it help? Between the time you would obtain this information, 
> and the time you could act on it, the answer may very well change.

yes, you are right. good point

> 
> Just try whatever operation you need to perform, and check for failure.

or probably by using a transaction as well, as JS suggested, anyway, I'll try

Thanks for the feedback

Marcus

> 
> Igor Tandetnik 
> 
> 
> 
> ___
> 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] Query Sqlite lock state

[Marcus Grimm]

John Stanton wrote:
> How about performing your backup inside an exlclusive transaction?

hm, good idea! ;)

Probably that will lock the file (i.e. the database) and protect
from a FileCopy, anyway: I'll try that.

Thanks for the reply

Marcus


> 
> Marcus Grimm wrote:
>> Hello all,
>>
>> is there a way to query if the database file is currently locked ?
>>
>> Background:
>> My application may run for weeks (hopefully) and uses EXCLUSIVE
>> transactions in some threads. On a daily basis I would like to copy
>> the database file for backup purpose. I assume that this will fail
>> when there is an exclusive transaction ongoing. It would be more
>> elegant to ask sqlite rather than test against a FileCopy failure.
>>
>> I found the "PRAGMA locking_mode" statement, is this the one to use ?
>>
>> Thank you
>>
>> Marcus
>>
>> ___
>> 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
> 

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

Re: [sqlite] Query Sqlite lock state

[Igor Tandetnik]

"Marcus Grimm" <[EMAIL PROTECTED]> wrote
in message news:[EMAIL PROTECTED]
> is there a way to query if the database file is currently locked ?

How would it help? Between the time you would obtain this information, 
and the time you could act on it, the answer may very well change.

Just try whatever operation you need to perform, and check for failure.

Igor Tandetnik 



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

Re: [sqlite] Query Sqlite lock state

[John Stanton]

How about performing your backup inside an exlclusive transaction?

Marcus Grimm wrote:
> Hello all,
> 
> is there a way to query if the database file is currently locked ?
> 
> Background:
> My application may run for weeks (hopefully) and uses EXCLUSIVE
> transactions in some threads. On a daily basis I would like to copy
> the database file for backup purpose. I assume that this will fail
> when there is an exclusive transaction ongoing. It would be more
> elegant to ask sqlite rather than test against a FileCopy failure.
> 
> I found the "PRAGMA locking_mode" statement, is this the one to use ?
> 
> Thank you
> 
> Marcus
> 
> ___
> 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

[sqlite] Query Sqlite lock state

[Marcus Grimm]

Hello all,

is there a way to query if the database file is currently locked ?

Background:
My application may run for weeks (hopefully) and uses EXCLUSIVE
transactions in some threads. On a daily basis I would like to copy
the database file for backup purpose. I assume that this will fail
when there is an exclusive transaction ongoing. It would be more
elegant to ask sqlite rather than test against a FileCopy failure.

I found the "PRAGMA locking_mode" statement, is this the one to use ?

Thank you

Marcus

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