[sqlite] Can i use the command line tools--"sqlite" creating a database file ?

2004-09-23 Thread duyu
-

Re: [sqlite] ON INSERT trigger

2004-09-23 Thread Alex
> If I have time at the weekend, I might have a bash at producing a patch > that will implement what is required. No promises, mind. > > What would be preferred? Convert the trigger to an update trigger, or fire > a delete trigger followed by an insert trigger? > > I'd prefer the former (update) as

Re: [sqlite] legacy sources

2004-09-23 Thread D. Richard Hipp
Miguel Angel Latorre wrote: The encode and decode sources were removed from the src dir, it would be nice to have them such files and alike (md5, etc) in the csv contrib dir. The complete CVS source tree, including all historical versions of all files, is available on the website. http://www.sql

[sqlite] In-Memory Performance Comparisons

2004-09-23 Thread Drew, Stephen
Hello all,   Can anyone tell me (or point me to any documentation) about the differences in speed between using an on-disk DB and an in-memory one?   Regards, Steve

Re: [sqlite] In-Memory Performance Comparisons

2004-09-23 Thread WeiChin3
In a message dated 9/23/2004 7:55:20 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: Can anyone tell me (or point me to any documentation) about the differences in speed between using an on-disk DB and an in-memory one? The speed difference would depends on how you use the database.

Re: [sqlite] In-Memory Performance Comparisons

2004-09-23 Thread D. Richard Hipp
Drew, Stephen wrote: Can anyone tell me (or point me to any documentation) about the differences in speed between using an on-disk DB and an in-memory one? Try it for yourself. Like this: drh$ rm test.db drh$ time sqlite3 test.db /dev/null real0m2.908s user0m1.683s sys

RE: [sqlite] In-Memory Performance Comparisons

2004-09-23 Thread Drew, Stephen
Many thanks. -Original Message- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 1:46 PM To: [EMAIL PROTECTED] Subject: Re: [sqlite] In-Memory Performance Comparisons Drew, Stephen wrote: > > Can anyone tell me (or point me to any documentation) about

[sqlite] cross-compile sqlite

2004-09-23 Thread Daniel=20W=FCrfel
I want to crosscompile sqlite to an axis devboard82. I use gcc-cris (cris-dist-1.56). Has anybody gained general experience with crosscompiling sqlite? How have I to define options as host, build, etc.? Have I to use the "with package"-options? Any feedback appreciated, thanks in advance, Daniel

Re: [sqlite] cross-compile sqlite

2004-09-23 Thread D. Richard Hipp
Daniel Würfel wrote: I want to crosscompile sqlite to an axis devboard82. I use gcc-cris (cris-dist-1.56). Has anybody gained general experience with crosscompiling sqlite? How have I to define options as host, build, etc.? Have I to use the "with package"-options? Any feedback appreciated, thanks

[sqlite] Performance of using Intersect; sanity check for newbie

2004-09-23 Thread Ken Cooper
I'm implementing a simple full text search in a sqlite database, using an additional table for the indexed words, associated record ids, and word offsets. A typical query will have multiple keywords, plus some additional fields specified. CREATE TABLE words (word TEXT, recordid INTEGER, word_o

[sqlite] Encryption?

2004-09-23 Thread Bryan Ashby
I have searched around and cannot find a definite answer -- We are working on a project that _requires_ a small, embedded and encrypted database. SQLite fits all of our needs except for the encryption part .. which I'm not totally sure about. I notice that in sqlite3.h there is a sqlite3_key() f

Re: [sqlite] Encryption?

2004-09-23 Thread Will Leshner
Bryan Ashby wrote: I have searched around and cannot find a definite answer -- We are working on a project that _requires_ a small, embedded and encrypted database. SQLite fits all of our needs except for the encryption part .. which I'm not totally sure about. I notice that in sqlite3.h there is a

Re: [sqlite] Need Type info with Views

2004-09-23 Thread EzTools Support
I'm just wondering why I have not received any comment regarding this issue...? EzTools Support wrote: Hello DRH. This is further to the previous query regarding no type information being returned with Views. I had previously asked if this could be added, but have not received any comment. I

Re: [sqlite] cross-compile sqlite

2004-09-23 Thread Daniel=20W=FCrfel
Thank you for your reply. But it doesn't help me really. I want to use the configure-script. Can you give me a hint? I tried --prefix=($PREFIX) --host=cris-axis-linux-gnu --target=cris-axis-linux-gnu --build=cris-axis-linux-gnu. This has worked in combination to a target-makefrag in the toplevel

Re: [sqlite] cross-compile sqlite

2004-09-23 Thread Doug Currie
Thursday, September 23, 2004, 6:01:40 PM, Daniel wrote: > [...] I want to use the > configure-script. Can you give me a hint? > I tried --prefix=($PREFIX) --host=cris-axis-linux-gnu > --target=cris-axis-linux-gnu --build=cris-axis-linux-gnu. --host=cris-axis-linux-gnu ??? > [...] > The last l

[sqlite] Lock files....

2004-09-23 Thread Eddy Macnaghten
Hi there I am new to this list, so please excuse me if this has been covered before, or is not the right place for this. I am writing a development language/environment that has a SQL back end. I am (planning to) put in a number of SQL engine connectivities, and SQLite is ideal for the low end t