[sqlite] passive DNS monitoring

This article http://isc.sans.org/diary.html?storyid=6271 mentions a presentation on passive DNS monitoring that will be given at http://www.sans.org/sansfire09/night.php in Baltimore. What do you think? Steve ___ sqlite-users mailing list

Re: [sqlite] Columns in where clause and the index.

See (possibly among others) http://www.sqlite.org/cvstrac/tktview?tn=3678 Steve Friedman Joanne Pham wrote: Hi All, I was wondering if we need to have the order of columns in the where clause need to be matched with the order of the indexes. Does the index will be used if the columns

Re: [sqlite] Sqlite replication

on the local machine (or use file system snapshots), does a rollback to end the transaction, and finally rsyncs the copy off to the backup machine. A cron to kick off the backup program once an hour (or whatever) ensures continual backups. Steve Friedman John Stanton wrote: It would be a relatively minor

Re: [sqlite] Specifing which index to use. Was: Performance/bug in multikey 'group by' in 3.6.2

constructed. - I presume that the following is not contemplated (and the documentation should reflect this just to avoid surprises): SELECT * FROM (some sub-query) AS t INDEX BY ... Steve Friedman ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] performance degradation from 3.6.1 to 3.6.2

Attached is an example program that demonstrates a significant performance degradation when migrating from 3.6.1 to 3.6.2. It can be compiled with gcc -Wall -O3 trial.c sqlite3.o -o trial -lpthread Steve Friedman ___ sqlite-users mailing list

Re: [sqlite] performance degradation from 3.6.1 to 3.6.2

Enrique Ramirez wrote: List stripped the attachment. On Mon, Sep 15, 2008 at 12:27 PM, Steve Friedman [EMAIL PROTECTED] wrote: Attached is an example program that demonstrates a significant performance degradation when migrating from 3.6.1 to 3.6.2. It can be compiled with gcc -Wall -O3

Re: [sqlite] Query runs faster when repeating condition

one with misunderstanding that the unary plus operator has no effect on the value of the expression is wrong. See http://www.sqlite.org/cvstrac/tktview?tn=3279 to show one scenario where this operator affects the result set. Steve Friedman ___ sqlite

[sqlite] side effect of unary + surprise

occur with the use of the unary +. Steve Friedman ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] problem building reduced-size sqlite

I rebaselined to the latest CVS as of this morning before rerunning the make command, so the lines have shifted, but the same issues as before. Steve Dennis Cote wrote: Steve Friedman wrote: libtool: compile: gcc -g -O3 -DSQLITE_ENABLE_RTREE=1 -DTEMP_STORE=2 -DSQLITE_DEFAULT_CACHE_SIZE

[sqlite] problem building reduced-size sqlite

When trying to build sqlite (latest cvs update) with the following: ../sqlite-latest/configure --disable-threadsafe --enable-tempstore=always \ --disable-tcl --enable-extensions \ CFLAGS=-g -O3 -DSQLITE_ENABLE_RTREE=1 \ -DTEMP_STORE=2 -DSQLITE_DEFAULT_CACHE_SIZE=100

Re: [sqlite] problem building reduced-size sqlite

Ralf Junker wrote: Steve Friedman wrote: When trying to build sqlite (latest cvs update) with the following: ../sqlite-latest/configure --disable-threadsafe --enable-tempstore=always \ --disable-tcl --enable-extensions \ CFLAGS=-g -O3 -DSQLITE_ENABLE_RTREE=1

Re: [sqlite] patch to allow integer rtree keys

woodbri at swoodbridge.com wrote: On Fri, Jul 11, 2008 at 9:23 PM, Steve Friedman sfriedman at woti.com wrote: I've just started using the rtree extension, and have found that the 32-bit float for the range keys is not appropriate for me. Please find attached a patch for rtree.c

[sqlite] requested patch to rtree.c v1.6

sqlite3.h #endif @@ -66,9 +69,6 @@ #include string.h #include assert.h -typedef sqlite3_int64 i64; -typedef unsigned char u8; -typedef unsigned int u32; typedef struct Rtree Rtree; typedef struct RtreeCursor RtreeCursor; Steve Friedman

[sqlite] incorrect output of .timer during long operation

, sEnd.ru_stime)); } } Steve Friedman ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] patch to allow integer rtree keys

Filip Navara wrote: how about actually attaching the patch? :) - Filip On Fri, Jul 11, 2008 at 9:23 PM, Steve Friedman [EMAIL PROTECTED] wrote: I've just started using the rtree extension, and have found that the 32-bit float for the range keys is not appropriate for me. Please find