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.
Oh, thanks.
Tito Ciuro wrote:
Here are some relevant links:
http://www.sqlite.org/cvstrac/wiki?p=SqliteTools
-- Tito
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
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
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
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
Anything like a visual manager for sqlite dbs?
or just the command line tool?
Regards,
Edgardo
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,
>
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.
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
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
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
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
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
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
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
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
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
18 matches
Mail list logo