[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

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 relativ

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

X BY is a verb form. I would think that INDEXED BY (a past participle) would be more accurate syntax since no new indices are being constructed. - I presume that the following is not contemplated (and the documentation should reflect this just to avoid surprises): SELECT * FROM (some sub-query) A

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

[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] Query runs faster when repeating condition

aving no effect on the value of the expression. > It seems that I am not the only 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 scenar

[sqlite] side effect of unary + surprise

on should still 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 -DTEM

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 \ >> CF

[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

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

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

Re: [sqlite] patch to allow integer rtree keys

wrote: >>>> On Fri, Jul 11, 2008 at 9:23 PM, Steve Friedman >>>> 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.

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 ran

[sqlite] incorrect output of .timer during long operation

oid){ if( enableTimer ){ struct rusage sEnd; getrusage(RUSAGE_SELF, ); printf("CPU Time: user %f sys %f\n", - 0.01*timeDiff(_utime, _utime), - 0.01*timeDiff(_stime, _stime)); + timeDiff(_utime, _utime), + timeDiff(_stime,