[sqlite] Can sqlite support

Hi,all NOW I want to use sqlite in an embedded device.In my design ,a web cgi in a single process is used to update configuration,and I expect my main application in another process can be noticed whenever its configuration is changed, how to use sqlite to achieve this goal, can I use trigger

[sqlite] Deleted rows count information

Hi all, Is there any function in SQLite which will give me information about the deleted rows during a Particular delete operation. At least a row count information. Thanks in advance.

[sqlite] REcursive triggers support

Hi all, I want to create recursive trigger in my application does SQLite supports this? Actually I have one table where parent child relationship exists between the columns. So if parent row gets deleted the children should also get deleted. So how could I get this from SQLite. I have

Re: [sqlite] Compatibility between different versions of SQLite

Thomas Levesque wrote: > I'm new to SQLite, and I noticed a problem of compatibility between > different versions of SQLite : it seems that a database created with a > version of SQLite cannot be used with another version. It seems logical that > downward compatibility isn't ensured, but I expected

Re: [sqlite] Compatibility between different versions of SQLite

"Thomas Levesque" <[EMAIL PROTECTED]> wrote: > Hi all, > > > > I'm new to SQLite, and I noticed a problem of compatibility between > different versions of SQLite : it seems that a database created with a > version of SQLite cannot be used with another version. It seems logical that > downward c

[sqlite] Compatibility between different versions of SQLite

Hi all, I'm new to SQLite, and I noticed a problem of compatibility between different versions of SQLite : it seems that a database created with a version of SQLite cannot be used with another version. It seems logical that downward compatibility isn't ensured, but I expected that a database cr

Re: [sqlite] Interpretation of explain plan

Onsdag den 15. februar 2006 18:24 skrev [EMAIL PROTECTED]: > Jon Friis <[EMAIL PROTECTED]> wrote: > > When i execute this on O_YDLRK_CK91_HIST i get the following plan and > > a response time on 0.1 of a sec. > > > > 0|0|TABLE O_YDLRK_CK91_HIST WITH INDEX > > sqlite_autoindex_O_YDLRK_CK91_HIST_1 0|

Re: [sqlite] Interpretation of explain plan

Jon Friis <[EMAIL PROTECTED]> wrote: > > When i execute this on O_YDLRK_CK91_HIST i get the following plan and > a response time on 0.1 of a sec. > > 0|0|TABLE O_YDLRK_CK91_HIST WITH INDEX sqlite_autoindex_O_YDLRK_CK91_HIST_1 > 0|0|TABLE AS b > 1|1|TABLE O_YDLRK_CK91_HIST AS a WITH INDEX > sqli

[sqlite] Interpretation of explain plan

Hi Users I have 2 identical tables O_YDLRK_CK91_HIST and O_YDLRK_CK94_HIST. When i run the _same_ query on both tables i get very different execution times and different execution plans. The query is as follows (the O_YDLRK_CK94_HIST version): Select a.Boers_Dato, a.Isin, a.Term_dato, a.Afdrag

RE: [sqlite] Shared Memory Question

Glenn, I certainly would, but sadly this is for Win32 too. Cheers, Steve -Original Message- From: Glenn McAllister [mailto:[EMAIL PROTECTED] Sent: 15 February 2006 16:45 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Shared Memory Question This is likely a naive response, but on Li

Re: [sqlite] Shared Memory Question

This is likely a naive response, but on Linux have you thought using /dev/shm? It's a tmpfs ramdisk that is needed by POSIX shared memory calls shm_open and shm_unlink in glibc 2.2 and above. It grows and shrinks as required and uses almost no memory if it's never populated with files. As a

Re: [sqlite] Shared Memory Question

Hello, We are currently looking at this very issue ourselves. I just put in an enhancement request... http://www.sqlite.org/cvstrac/tktview?tn=1679 For allowing the runtime replacement of memory functions by using function pointers instead of C mallocs. We could then replace SQLite's allocators

Re: [sqlite] Shared Memory Question

"Drew, Stephen" <[EMAIL PROTECTED]> wrote: > > Presumably, the in-memory database is in contiguous memory Sorry, that is not the case. > as I guess > the format is the same as the disk-based database format. Would it be a > lot of work to be able to construct an in-memory database with a c

RE: [sqlite] Shared Memory Question

Sorry, just noticed this is very similar Mateus' email from earlier, so will wait for any responses to that... -Original Message- From: Drew, Stephen Sent: 15 February 2006 15:33 To: sqlite-users@sqlite.org Subject: [sqlite] Shared Memory Question Hello all, An interesting use of the i

[sqlite] Shared Memory Question

Hello all, An interesting use of the in-memory SQLite database would be to use it in shared memory and have the data shared between applications but stored once. The background to this is I am making local replicated copies of a main database, and as they are transient (they are read-only copi