On 6/21/07, James Dennett <[EMAIL PROTECTED]> wrote:
> -Original Message-
> From: Andrew Finkenstadt [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 21, 2007 2:56 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] transaction best practices, post-committal headaches
>
> In my sqlite
> -Original Message-
> From: Andrew Finkenstadt [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 21, 2007 2:56 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] transaction best practices, post-committal headaches
>
> In my sqlite framework I have the concept of a transaction, which
In my sqlite framework I have the concept of a transaction, which uses a
pair of begin transaction (immediate, exclusive, normal) / end transaction
or rollback transaction statements that execute based on C++ object
construction and stack unwinding destruction. The transaction, if it's
marked as
Just forgot to mention:
Referencing in previous open/attached databases should also be possible with
foreign key constraints, when they will be enforced...
Marc
On Thu, 2007-06-21 at 11:57 +0200, Andre du Plessis wrote:
>> Is it possible to do this:
>>
>>Open DB1
>>
>>Attatch DB2
>>
On Thu, 2007-06-21 at 11:57 +0200, Andre du Plessis wrote:
>> Is it possible to do this:
>>
>>Open DB1
>>
>>Attatch DB2
>>
>> In DB1 have a trigger that does
>>
>> Insert into DB2. ?
>>
>> Theoretically it seems possible but we couldn't get it to work. Before I
>> investigate
Stefan Kuhr <[EMAIL PROTECTED]> wrote:
> Hello everyone,
>
> this might be a real dumb question, but I am relatively new to database
> programming and in particular to sqlite, so anyway, here it goes:
>
> Suppose I have a call to sqlite3_exec in my code and it calls into the
> callback function
> Suppose I have a call to sqlite3_exec in my code and it calls into the
> callback function passed as the third parameter to this sqlite3_exec call.
> Is it possible to create another sqlite3 object with a sqlite3_open to the
> same database file from within this callback? Or in other words: Can
Hello everyone,
this might be a real dumb question, but I am relatively new to database
programming and in particular to sqlite, so anyway, here it goes:
Suppose I have a call to sqlite3_exec in my code and it calls into the
callback function passed as the third parameter to this sqlite3_exec
On Thu, 2007-06-21 at 11:57 +0200, Andre du Plessis wrote:
> Is it possible to do this:
>
>
>
>Open DB1
>
>Attatch DB2
>
>
>
>
>
> In DB1 have a trigger that does
>
> Insert into DB2. ?
>
>
>
>
>
> Theoretically it seems possible but we couldn't get it to work. Before I
That sounds like an awesome trick. I will definitely do as you suggest and
decrease cache_size as even at the moment it does not really seem to help
much.
With regards to the memory being volatile and such. That is not really a big
problem for me as a complete loss of the lookup table is not a
Is it possible to do this:
Open DB1
Attatch DB2
In DB1 have a trigger that does
Insert into DB2. ?
Theoretically it seems possible but we couldn't get it to work. Before I
investigate further just want to know if it is possible
Thanks.
> -Original Message-
> From: Alberto Simões [mailto:[EMAIL PROTECTED]
> Sent: 21 June 2007 09:46
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] SQLite article, Adobe info
>
> Hi, Tim.
>
> Is there any PDF or cleaner HTML we can use for printing?
> Thank you ;)
> Alberto
It is in
Hi, Tim.
Is there any PDF or cleaner HTML we can use for printing?
Thank you ;)
Alberto
On 6/21/07, Tim Anderson <[EMAIL PROTECTED]> wrote:
The article I wrote is here:
http://technology.guardian.co.uk/weekly/story/0,,2107239,00.html
Thanks again to those who gave feedback on SQLite.
The article I wrote is here:
http://technology.guardian.co.uk/weekly/story/0,,2107239,00.html
Thanks again to those who gave feedback on SQLite.
Another post I think is interesting is from Paul Robertson, who works on
SQLite within the Adobe Integrated Runtime (formerly Apollo), responding
to a
14 matches
Mail list logo
