Re: [sqlite] Good Graphical Tool for 3.x

. At best the files are on the same machine wherew you are logged in. regards, Detlef > >Hi! >Detlef Groth wrote: > >>Hello, >> >>You can try my program dgSQLite. I recently added sqlite3 support: >> >>http://goblet.molgen.mpg.de/dgSQLite3.kit >

RE: [sqlite] Good Graphical Tool for 3.x

Hello, You can try my program dgSQLite. I recently added sqlite3 support: http://goblet.molgen.mpg.de/dgSQLite3.kit You need a tclkit runtime from: http://www.equi4.com/pub/tk/downloads.html in order to run it. The old version for sqlite2 is at: http://www.microemacs.de/tcltk_dgsqlite.html

[sqlite] sqlite3.1.2: how to build libtclsqlite.so

uild during executing `gmake test' although this seems to be as well a little bit tricky. regards, Detlef -- Dr. Detlef Groth Max-Planck-Institut fuer Molekulare Genetik Ihnestr. 63/73 D-14195 Berlin Tel.: + 49 (0)30 - 8413 1235 Fax: + 49 (0)30 - 8413 1128

Re: [sqlite] Compiling sqlite3.0.3 on dec-osf1 with gcc 3.04 failed

ed tcl-lib? In 2.8.15 `make test' makes the static but not the dynamic library for tcl ? regards, Detlef -- Dr. Detlef Groth Max-Planck-Institut fuer Molekulare Genetik Ihnestr. 63/73 D-14195 Berlin Tel.: + 49 30 - 8413 1235

Re: [sqlite] Compiling sqlite3.0.3 on dec-osf1 with gcc 3.04 failed

parse error before "uptr" ../sqlite/src/sqliteInt.h:129: warning: data definition has no type or storage class gmake: *** [attach.lo] Error 1 >Detlef Groth wrote: >> Hello, >> >> I could recently compile the sqlite2.x code without problems but now I can't

RE: [sqlite] Median as an aggregate function using the tcl interface

Hello, After consulting the php-sources I could hack the tclsqlite.c file myself to add aggregation capabilities to tcl, this should go into the next release: the diff: 2c2 < ** 2001 September 15 --- > ** 2004 June 8 added aggregate function by Dr. Detlef Groth (dgroth at gmx.de) 43

Re: [Fwd: [sqlite] Median as an aggregate function using the tcl interface]

e expecting to be called once for each > row, rather than just once total (or else how will the lappend part work?) > > 2. Won't something like the following do what you want? > > set sortedlist [lsort -integer [sql eval {select Size from tensembl}]] > lindex $sortedlist

[sqlite] Median as an aggregate function using the tcl interface

ever I get it at the very end. And this is slow because it computes foreach row the median, I would like only to compute it ones. For the last element! Becuase it is a aggregate. Any hint ? regards, Detlef -- Dr. Detlef Groth Max-Planck-Institut fuer Molekulare Genetik Ihnestr. 63/73 D-14195 Berlin Tel