[sqlite] Pre-compiling statements

2004-09-28 Thread Arno Engelbrecht
Does anybody know how to pre-compile a statement? Basically I want to do mulitple inserts into the same table and want to cut down on the time to parse each statement.

Re: [sqlite] Is there...?

2004-09-28 Thread Edgardo Rossetto
Oh, thanks. Tito Ciuro wrote: Here are some relevant links: http://www.sqlite.org/cvstrac/wiki?p=SqliteTools -- Tito

Re: [sqlite] Is there...?

2004-09-28 Thread Edgardo Rossetto
Windows or Linux. Tito Ciuro wrote: Which platform are you interested in? -- Tito On Sep 29, 2004, at 00:54, Edgardo Rossetto wrote: Anything like a visual manager for sqlite dbs? or just the command line tool? Regards, Edgardo

Re: [sqlite] OOo/SQLite, searching for a developer

2004-09-28 Thread Eddy Macnaghten
Have you looked at http://www.ch-werner.de/sqliteodbc/dba-sqlite-sdbc.html Eddy On Tue, 2004-09-28 at 22:25, M. Fioretti wrote: > On Fri, Aug 20, 2004 11:40:16 AM +0100, Sophie Gautier > ([EMAIL PROTECTED]) wrote: > > Hi all, > > > > This is my first mail here, so I'll introduce myself short

Re: [sqlite] Is there...?

2004-09-28 Thread Tito Ciuro
Here are some relevant links: http://www.sqlite.org/cvstrac/wiki?p=SqliteTools -- Tito On Sep 28, 2004, at 23:53, Tito Ciuro wrote: Which platform are you interested in? -- Tito On Sep 29, 2004, at 00:54, Edgardo Rossetto wrote: Anything like a visual manager for sqlite dbs? or just the command lin

Re: [sqlite] Is there...?

2004-09-28 Thread Tito Ciuro
Which platform are you interested in? -- Tito On Sep 29, 2004, at 00:54, Edgardo Rossetto wrote: Anything like a visual manager for sqlite dbs? or just the command line tool? Regards, Edgardo

[sqlite] Is there...?

2004-09-28 Thread Edgardo Rossetto
Anything like a visual manager for sqlite dbs? or just the command line tool? Regards, Edgardo

Re: [sqlite] OOo/SQLite, searching for a developer

2004-09-28 Thread M. Fioretti
On Fri, Aug 20, 2004 11:40:16 AM +0100, Sophie Gautier ([EMAIL PROTECTED]) wrote: > Hi all, > > This is my first mail here, so I'll introduce myself shortly : I'm > Sophie Gautier, leader of the french-speaking community in the > OpenOffice.org project. Louis Suarez-Potts, our community manager, >

Re: [sqlite] The small unified database

2004-09-28 Thread M. Fioretti
On Tue, Sep 28, 2004 13:37:01 PM +0200, io ([EMAIL PROTECTED]) wrote: > Greetings, everybody! > > The article on SQLite I mentioned here some months ago > is finally online: > > http://www.linuxjournal.com/article.php?sid=7800&mode=thread&order=0 > There is now a comment to the article from J.

Re: [sqlite] .dump command problem

2004-09-28 Thread Dennis Cote
Paolo Vernazza wrote: > If I try to do all from the command line (sqlite3.exe mydb.db .dump > mytable), it will dump all the tables that are int the DB > > I think I'm doing something wrong. someone can help me? Paolo, Try quoting your command so it gets passed to sqlite3 as a single arg

[sqlite] .dump command problem

2004-09-28 Thread Paolo Vernazza
Hi, Im' trying to dump a table. If I run sqlite3.exe mydb.db and then insert the command sqlite> .dump mytable anything works OK and I receive only the content of "mytable" If I try to do all from the command line (sqlite3.exe mydb.db .dump mytable), it will dump all the tables that are int the DB

Re: [sqlite] calling sqlite3_create_function after sqlite3_prepare?

2004-09-28 Thread Vladimir Vukicevic
On Tue, 28 Sep 2004 12:09:45 +0100 (BST), Christian Smith <[EMAIL PROTECTED]> wrote: > Why? > > Functions are static, you set them up at initialisation time. So why > register functions after preparing a statement for execution. A single database handle is getting shared among multiple components

[sqlite] How to solve "unable to open a temporary database file for storing temporary tables"

2004-09-28 Thread Carfield Yim
I get the following error after install trac: Oops... Trac detected an internal error: malformed database schema - unable to open a temporary database file for storing temporary tables Traceback (most recent call last): File "/home/misc/rpm/tmp/trac-0.7.1-1mdk-buildroot//usr/lib/python2.3/site

Re: [sqlite] Re: FOREIGN:[sqlite] Receiving notification of table updates

2004-09-28 Thread Kazuho Oku
From: "Christian Smith" <[EMAIL PROTECTED]> > On Tue, 28 Sep 2004, Kazuho Oku wrote: > >Unfortunately, my apache module only performs a single SELECT clause of > >which WHERE clause can be indexed. > >What I am wondering is the way to stop calling SQLite each time the module > >processes an HTTP r

[sqlite] The small unified database

2004-09-28 Thread Marco Fioretti
Greetings, everybody! The article on SQLite I mentioned here some months ago is finally online: http://www.linuxjournal.com/article.php?sid=7800&mode=thread&order=0 enjoy, and spread the word! Thanks again to all who provided information. Ciao, Marco Fioretti

Re: [sqlite] calling sqlite3_create_function after sqlite3_prepare?

2004-09-28 Thread Christian Smith
On Fri, 24 Sep 2004, Vladimir Vukicevic wrote: >I'm creating a few prepared statements using sqlite3_prepare; making >that call seems to set db->pVdbe to the newly compiled statement, >which seems reasonable. However, calling sqlite3_create_function >after this results in SQLITE_ERROR, with an er

Re: [sqlite] Re: FOREIGN:[sqlite] Receiving notification of table updates

2004-09-28 Thread Christian Smith
On Tue, 28 Sep 2004, Kazuho Oku wrote: >Thank you for the response. > >Unfortunately, my apache module only performs a single SELECT clause of >which WHERE clause can be indexed. >What I am wondering is the way to stop calling SQLite each time the module >processes an HTTP request (eliminate the F

Re: [sqlite] Re: FOREIGN:[sqlite] Receiving notification of table updates

2004-09-28 Thread Kazuho Oku
From: "D. Richard Hipp" <[EMAIL PROTECTED]> > Kazuho Oku wrote: > I think you are asking for SQLite to preserve its memory cache > and not reload pages from the disk as long as the database is > unchanged. > > SQLite version 2.8 does not support this and probably never will. > > The file format f