> Most you need to know about locking is found in:
> http://www.sqlite.org/lang_transaction.html
>
> sqlite3_exec() these statements one by one:
> ATTACH 'filename' as db2;
> BEGIN IMMEDIATE; -- or EXCLUSIVE
> (error handling/retry)
>
> -- this assumes table1 has the exact
> -- same definition
On Sat, 20 Dec 2008 07:03:48 -0500, Simon
wrote in General Discussion of SQLite
Database :
>> Use transactions, ref:
>> http://www.sqlite.org/lang_transaction.html
>> and program proper lock/error handling. The archives of this
>> mailing list contain several good examples.
>
>Yes, ok, I'll have
> Use transactions, ref:
> http://www.sqlite.org/lang_transaction.html
> and program proper lock/error handling. The archives of this
> mailing list contain several good examples.
Yes, ok, I'll have to work that way... I believe there should also be some
time
spent on a good design for these lo
On Tue, 16 Dec 2008 12:26:30 -0500, Simon
wrote in turne...@gmail.com, General
Discussion of SQLite Database :
>Hi there,
> I'm developping an application that will use several databases. One
>on disk that will hold all configuration and cache, and another in ram
>to hold all live data.
>
> On
Simon wrote:
> I'm just
> wondering if there could be a query made on a database using
> information provided in another database (ie to compare, or
> insert/copy).
http://sqlite.org/lang_attach.html
Igor Tandetnik
___
sqlite-users mailing list
sql
Hi there,
I'm developping an application that will use several databases. One
on disk that will hold all configuration and cache, and another in ram
to hold all live data.
On the same server, it is possible that multiple process will
read/write to both the disk db and the memory db. Someone
6 matches
Mail list logo