[sqlite] importing csv files?

anyway to import csv files in sqlite3? .import does not quite work, leaves the quotes in.

[sqlite] idxchk - a small utility to report index usage on queries.

I've uploaded 'idxchk' to the contrib section of the SQLite website. idxchk is a small utility that prints index usage for a query statement. I have also authored a corresponding Wiki page for idxchk documentation, and an example of using idxchk by adding indexes to improve query performance.

Re: [sqlite] Re: SQlite 3.1.2 autoconf problem

On Wed, 2005-02-16 at 21:31 +0100, Andreas Rottmann wrote: > > > > Does check-in [2346] help? > > http://www.sqlite.org/cvstrac/chngview?cn=2346 > > > >From a quick glance, this should fix it. I'll add this patch to > Debian's 3.1.2 packaging. > Version 3.1.3 is probably not more than a few

[sqlite] Re: SQlite 3.1.2 autoconf problem

"D. Richard Hipp" <[EMAIL PROTECTED]> writes: > On Wed, 2005-02-16 at 17:45 +0100, Andreas Rottmann wrote: >> Hi! >> >> When using the configure script shipped in the tarball, everything >> works fine, but after rebuilding configure (i.e. running autoconf), >> @VERSION_NUMBER@ is apparently no

Re: [sqlite] sth more then step()

ivan wrote: Hi, Is there any way to skip rows in prepared statement and jump to next, sth like moveto (in sqlite3) ?? Use sqlite3_step(). You can call it anytime to skip to the next row of the result set. If you want to skip the first 10 rows simply call it 10 times then start looking at your

Re: [sqlite] SQlite 3.1.2 autoconf problem

On Wed, 2005-02-16 at 17:45 +0100, Andreas Rottmann wrote: > Hi! > > When using the configure script shipped in the tarball, everything > works fine, but after rebuilding configure (i.e. running autoconf), > @VERSION_NUMBER@ is apparently no longer substituted by configure, > which breaks the

[sqlite] SQlite 3.1.2 autoconf problem

Hi! When using the configure script shipped in the tarball, everything works fine, but after rebuilding configure (i.e. running autoconf), @VERSION_NUMBER@ is apparently no longer substituted by configure, which breaks the compile. In fact, I can find no AC_SUBST statement regarding

Re: [sqlite] How can I verify that the index is really used?

Hi, It's great! The slide show from the PHP conference explains that SELSCT .. ORDER BY uses indice (if possible) for sorting, so this is the expected behaviour. I was not expecting it because in ORACLE it is not so: SELSCT .. ORDER BY does't use indexes for sorting in most cases. May be

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

Hello, I am trying to build libtclsqlite.so on DEC-OSF1. I run ../configure gmake gmake test without problems after: [EMAIL PROTECTED]:/project/goblet/src/sqlite-3.1.2/build> make install tclsh ../sqlite/tclinstaller.tcl 3.1 couldn't open