[sqlite] New wiki page for Performance Tuning

Hi All, I just created a new wiki page off the wiki home called PerformanceTuning. I have started to place clipets from emails in the group which relate to making queries or DB operations run quicker. Please add your bits and pieces http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuning regar

Re: [sqlite] sqlite command-line utility (was: manual? documentat ion?)

> What does the... > "(one varchar(10), two smallint)" > ...in the following example... > "sqlite> create table tbl1(one varchar(10), two smallint);" > ...mean/do? It creates the table 'tbl1' shaped like this. +-+ | one | two | +-+ | | | | | | Don't

[sqlite] Autoincrement not sequential

Hi all, I'm writing a little performance tester app for sqlite (which btw so far produces very impressive results!). I'm filling 100,000 records into a table where the first field is a "integer primary key" so as to let it increment the number on insert automatically. Interestingly, it doesn't pr

Re: [sqlite] Close() and file locks...

> "eno" == eno <[EMAIL PROTECTED]> writes: eno> Marco Bambini wrote: >> After the 2.8.10 release ... "This version fixes a critical locking >> bug in Unix. It turns out that any call to close() clears all locks >> on file that was closed (who knew?) which then left the database >> vulnerabl

[sqlite] vdbe question

hi how can i create vdbe for same special sql query, then check how many row a will get, and for example move to row 100 and fetch 20 rows , its could be just sql cursor but i didn't find it in sqlite .. what can i do about it ? thanks :) --

[sqlite] SQLite HTML Reports

I'm looking for an embeddable template-driven formatter along the lines of php. Something lightweight that will allow me to interweave HTML to build reports from my SQLite tables. Something cross-platform too. Any suggestions of where to start looking? Thank you, Sanford --

[sqlite] Decodes

Hi, Are there any plans to include a DECODE as a standard built-in function in SQLite? I have written one myself very easily, and it seems to be a nice, quick feature to add. Regards, Steve

Re: [sqlite] Cannot drop trigger

Kurt Welgehausen wrote: sqlite> drop trigger xx; SQL error: no such trigger: xx sqlite> select name, length(name) from sqlite_master ...> where type='trigger' and name like '%xx%'; xx|2 sqlite> pragma integrity_check; ok I had to dump the database and recreate it to get rid of the

[sqlite] Cannot drop trigger

sqlite> drop trigger xx; SQL error: no such trigger: xx sqlite> select name, length(name) from sqlite_master ...> where type='trigger' and name like '%xx%'; xx|2 sqlite> pragma integrity_check; ok I had to dump the database and recreate it to get rid of the trigger. I kept a copy

[sqlite] tcl tests on 2.8.11

I've run it on linux and windows and got the same failures. Did anybody run the test suit on the new version ? Thanks Avner The test output: date-8.1... Expected: [{2003-10-26 12:34:00}] Got: [{2004-01-18 15:31:14}] date-8.2... Expected: [{2003-10-27 12:34:00}] Got: [{2004-01-19 15:31:1

Re: [sqlite] Close() and file locks...

Marco Bambini wrote: After the 2.8.10 release ... "This version fixes a critical locking bug in Unix. It turns out that any call to close() clears all locks on file that was closed (who knew?) which then left the database vulnerable to corruption from other processes. That bug has been cleared by