[sqlite] pre-compiling prepared statements

[chetana bhargav]

Hi,
   
  Is there any way to pre compile some of the prepared statements during 
compile time. I am having 4 tables of which two tables doesn't create any 
triggers/joins. I am basically trying to speed up the queries on these tables 
(as they are most frequently used). I am looking for ways so that I can keep 
them prepared always, not in memory though as that would be too much.
   
  -Chetan. 


-
Stay in the know. Pulse on the new Yahoo.com.  Check it out. 

Re: [sqlite] SQLite Conference Tutorials

[Dennis Cote]

Sandeep Suresh wrote:

Where is the conference ? Is it open for everyone to register ?



Further information is available here http://www.tcl.tk/community/tcl2006/

HTH
Dennis Cote


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite Conference Tutorials

[drh]

Sandeep Suresh <[EMAIL PROTECTED]> wrote:
> Where is the conference ? Is it open for everyone to register ?
> 

The conference is in the Chicago area, in Naperville.
Full information is available on the web at:

   http://www.tcl.tk/community/tcl2006/

Anybody can register for the conference.  Or you can
just come to one or two of the tutorials and skip the
3-day conference that follows. 

There is more information at the website above.

--
D. Richard Hipp   <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite Conference Tutorials

[Sandeep Suresh]

Where is the conference ? Is it open for everyone to register ?

Thanks,
Sandeep.

Bud Beacham wrote:

Will the handouts, slides, etc. be available to download for those unable to 
attend?
  


[EMAIL PROTECTED] wrote:
  Martin Jenkins wrote:
  

[EMAIL PROTECTED] wrote:

On Tuesday, October 10, there will be a full day of tutorials on 
SQLite covering all the latest features including:
  
Sounds good - will there be a webcast or Google video for those of us 
unable to attend in person?





In past years there has been audio-cast of the main conference, but
not for the tutorials. I do not know what will be set up for this
year. I'll talk to the organizers and let you know.
--
D. Richard Hipp 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



  


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite Conference Tutorials

[Martin Jenkins]

[EMAIL PROTECTED] wrote:
> > In past years there has been audio-cast of the main conference, but
> > not for the tutorials.  I do not know what will be set up for this
> > year.  I'll talk to the organizers and let you know.

Thanks. I enjoyed the Google talk, so I'm looking forward to hearing 
this one.


Martin




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite Conference Tutorials

[drh]

Bud Beacham <[EMAIL PROTECTED]> wrote:
> Will the handouts, slides, etc. be available to download for those unable to 
> attend?
>   

Possibly.  That is unclear at the moment.  But be warned, that
my handout/slide style is evolving and my more recent slides are
pretty useless without the accompanying audio.  And, likewise,
the audio will be nearly useless without the slides.  You
really need both in order to understand the content, I think.

> 
> [EMAIL PROTECTED] wrote:
>   Martin Jenkins wrote:
> > [EMAIL PROTECTED] wrote:
> > > On Tuesday, October 10, there will be a full day of tutorials on 
> > > SQLite covering all the latest features including:
> > 
> > Sounds good - will there be a webcast or Google video for those of us 
> > unable to attend in person?
> > 
> 
> In past years there has been audio-cast of the main conference, but
> not for the tutorials. I do not know what will be set up for this
> year. I'll talk to the organizers and let you know.

The people running the conference tell me that audio will be
available for the main conference (including the keynote about
SQLite - though again you'll really want the slides for the full
effect) but tutorials will not be broadcast.

--
D. Richard Hipp   <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite Conference Tutorials

[Bud Beacham]

Will the handouts, slides, etc. be available to download for those unable to 
attend?
  

[EMAIL PROTECTED] wrote:
  Martin Jenkins wrote:
> [EMAIL PROTECTED] wrote:
> > On Tuesday, October 10, there will be a full day of tutorials on 
> > SQLite covering all the latest features including:
> 
> Sounds good - will there be a webcast or Google video for those of us 
> unable to attend in person?
> 

In past years there has been audio-cast of the main conference, but
not for the tutorials. I do not know what will be set up for this
year. I'll talk to the organizers and let you know.
--
D. Richard Hipp 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite Conference Tutorials

[drh]

Martin Jenkins <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
> > On Tuesday, October 10, there will be a full day of tutorials on 
> > SQLite covering all the latest features including:
> 
> Sounds good - will there be a webcast or Google video for those of us 
> unable to attend in person?
> 

In past years there has been audio-cast of the main conference, but
not for the tutorials.  I do not know what will be set up for this
year.  I'll talk to the organizers and let you know.
--
D. Richard Hipp   <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite Conference Tutorials

[Martin Jenkins]

[EMAIL PROTECTED] wrote:
On Tuesday, October 10, there will be a full day of tutorials on 
SQLite covering all the latest features including:


Sounds good - will there be a webcast or Google video for those of us 
unable to attend in person?


Martin

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] SQLite Conference Tutorials

[drh]

On Tuesday, October 10, there will be a full day of tutorials on 
SQLite covering all the latest features including:

   *  The shared cache enhancements
   *  Memory management enhancements for embedded devices
   *  Loadable extensions
   *  Virtual tables
   *  Full text search

The venue is the 13th Annual Tcl/Tk Conference in Naperville IL 
(a suburb of Chicago).  The morning will be a detailed introduction
to SQLite and the SQL language it supports with particular 
emphasis on the TCL interface.  The afternoon session will delve 
into the internal C-language implementation of SQLite and will 
cover advanced topics such as:

   *  Query optimization strategies
   *  The internal operation of SQLite
   *  Techniques for minimizing memory consumption
   *  Writing run-time loadable extensions for SQLite
   *  Customizing the code for specialized applications

Anyone is welcomed at either or both sessions.  It is not necessary
to attend the first tutorial in order to come to the second.  It
is not necessary to know TCL in order to attend either session,
though some prior exposure to TCL would, of course, be helpful.
Note that the TCL bindings for SQLite incorporate several innovative
ideas that make it an especially appealing programming interface 
and so you may want to attend the morning session to learn more 
about the TCL bindings even if you have no current plans for using 
that language.

For additional information and on-line registration visit

  http://www.tcl.tk/community/tcl2006/

Both of the principal programmers for SQLite, Richard Hipp
(yours truly) and Dan Kennedy, will be at this conference.
We would be happy for you to join us.

--
D. Richard Hipp   <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] How to edit Makefile.linux-gcc to define those SQLITE_OMIT_*?

[Martin Jenkins]

Sarah wrote:
> And during make, I noticed that these new-added -DSQLITE_OMIT_XX did
> not appeared in the command lines.

Are you running the right makefile?

By default makes runs "Makefile" or "makefile", so unless one of those
two files includes your modified makefile or is linked to your modified
makefile, your modified file won't be run. I think the configure steps
you performed build a file called Makefile so that is probably what make
is using.

Try "make -f Makefile.linux-gcc"

Martin

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Sqlite 3.3.7 intel compiler warnings

[Christian Smith]

Jay Sprenkle uttered:


hidden variables might very well not be a problem, if it was done that
way on purpose.



It should never be done on purpose. It is obfuscation pure and simple. 
There is never a good reason to do this, other than perhaps hiding a 
global variable (and even that is not a good idea.)


Just use a different variable name if it has a different use.

MHO.




On 8/30/06, Miguel Angel Latorre Díaz <[EMAIL PROTECTED]> wrote:

I already filtered out all the "common" warnings but these:

build.c(1969): remark #1599: declaration hides variable "v" (declared at
line 1883)
Vdbe *v = sqlite3GetVdbe(pParse);
  ^



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



--
/"\
\ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
 X   - AGAINST MS ATTACHMENTS
/ \
-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] How to edit Makefile.linux-gcc to define those SQLITE_OMIT_*?

[Sarah]

Hi,

I've added the following lines in the Makefile.linux-gcc file:

OPTS += -DSQLITE_OMIT_ALTERTABLE

OPTS += -DSQLITE_OMIT_AUTHORIZATION 

OPTS += -DSQLITE_OMIT_AUTOVACUUM

OPTS += -DSQLITE_OMIT_AUTOINCREMENT 

OPTS += -DSQLITE_OMIT_BLOB_LITERAL

OPTS += -DSQLITE_OMIT_COMPLETE 

OPTS += -DSQLITE_OMIT_COMPOUND_SELECT

OPTS += -DSQLITE_OMIT_CONFLICT_CLAUSE 

OPTS += -DSQLITE_OMIT_EXPLAIN

OPTS += -DSQLITE_OMIT_FLOATING_POINT 

OPTS += -DSQLITE_OMIT_FOREIGN_KEY

OPTS += -DSQLITE_OMIT_INTEGRITY_CHECK 

OPTS += -DSQLITE_OMIT_PAGER_PRAGMAS

OPTS += -DSQLITE_OMIT_PRAGMA

OPTS += -DSQLITE_OMIT_REINDEX 

OPTS += -DSQLITE_OMIT_SCHEMA_PRAGMAS

OPTS += -DSQLITE_OMIT_SCHEMA_VERSION_PRAGMAS 

OPTS += -DSQLITE_OMIT_SUBQUERY

OPTS += -DSQLITE_OMIT_TCL_VARIABLE

OPTS += -DSQLITE_OMIT_TRIGGER

OPTS += -DSQLITE_OMIT_DATETIME_FUNCS



but the result is still the same. The footprint has not been changed.



And during make, I noticed that these new-added -DSQLITE_OMIT_XX did not 
appeared in the command lines.



Why? Is there any other file I need to update?



Thanks in advance.


- Original Message - 
From: <[EMAIL PROTECTED]>
To: 
Sent: Friday, August 25, 2006 6:35 PM
Subject: Re: [sqlite] How to edit Makefile.linux-gcc to define those 
SQLITE_OMIT_*?


"Sarah" <[EMAIL PROTECTED]> wrote:
> Hi,all
> 
> In order to define those SQLITE_OMIT_TRIGGER,SQLITE_OMIT_ALTERTABLE..., I 
> have to rebuild parse.c 
> from parse.y. So I took the following steps to do it under linux(Fedora 2). 
> 
> But by comparing the generated static library, I find that no difference has 
> been made 
> and the footprint is still the same. 
> 
> I'm not familiar with linux. So I guess the way I edit Makefile.linux-gcc is 
> wrong. 
> My steps are as follows:
> 1.Edit Makefile.linux-gcc,add the following sentences directly into it:
>   -DSQLITE_OMIT_TRIGGER
>   -DSQLITE_OMIT_ALTERTABLE
>   -DSQLITE_OMIT_VIEW
>   -DSQLITE_OMIT_AUTHORIZATION

Should be:

  OPTS += -DSQLITE_OMIT_TRIGGER

and so forth.

>   ...
> 2.run ..>../configure
> 3.run ..>make
> 4.generate lib, run ..>ar cr libsqlite.a *.o
> 5.compare the footprint of generated sqlite.a with the one without defining 
> -DSQLITE_OMIT_* in Makefile.linux-gcc.
>   totally the same.
> 
> Any help will be appreciated..
> 
> Sarah



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] New conflict clause: update

[Ramon Ribó]

  Hello,

  I was thinking on a new option that could be useful for sqlite.
A new conflict clause called "update"

  so that the following SQL command:

  insert or update into table1 (a,b) values (1,2)

  was equivalent to

  update table1 set a=1,b=2 where ?unique-key-constraint?

  when a unique key contraint is hit.

  I think that it could have advantages over the "replace" conflict
clause for the very usual case that a new record must be
updated or inserted if it does not exist.

  What is your opinion on this?
--
Compass Ing. y Sistemas Dr. Ramon Ribo
http://www.compassis.com[EMAIL PROTECTED]
c/ Tuset, 8 7-2 tel. +34 93 218 19 89
08006 Barcelona, Spain  fax. +34 93 396 97 46

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] need to form an frame work for database independent API

[Markus Hoenicka]

Vivien Malerba <[EMAIL PROTECTED]> was heard to say:

> I'm working on libgda and libgnomedb which are abstraction libraries
> for SQlite, postgreSQL, MySQL, Oracle, ... There is a BDB adaptator
> but it needs some work.
> Please wisit http://www.gnome-db.org (the website is very outdated but
> development is still going on), or download the latest versions from
> CVS.
>

FWIW there is also libdbi (http://libdbi.sourceforge.net), a database
abstraction layer written in C. There are several database drivers available
(see http://libdbi-drivers.sourceforge.net), including SQLite, SQLite3, MySQL,
PostgreSQL, Firebird, Ingres, Sybase, MS SQL, mSQL, as well as work in progress
for Ingres and Oracle.

I strongly support Vivien's suggestion to extend existing abstraction layers
instead of developing yet another one.

regards,
Markus

-- 
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] need to form an frame work for database independent API

[Vivien Malerba]

On 8/18/06, Narendran <[EMAIL PROTECTED]> wrote:


I wish to form an database independant API for sqlite and BerkeleyDB . I need
to now wht factors  should consider .

i am new to both . I have problems in running an simple program in sqlite .
its say can't find the sqlite3_open(  . If i paste the source code for that
funstion ,it say that some other is so there . please help to resolve this
problem . I am really struck

thanks in advance .

B. Narendran(  Indian)


I'm working on libgda and libgnomedb which are abstraction libraries
for SQlite, postgreSQL, MySQL, Oracle, ... There is a BDB adaptator
but it needs some work.
Please wisit http://www.gnome-db.org (the website is very outdated but
development is still going on), or download the latest versions from
CVS.

Regards,

Vivien

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] need to form an frame work for database independent API

[Narendran]

check the library file location and when compiling give the path name as 

gcc -I/usr/local/include   and -L/usr/local/lib

just like the above find the location of the include and library file

make sure u installed properly .

Thanking you
B.Narendran


-- 
View this message in context: 
http://www.nabble.com/need-to-form-an-frame-work-for-database-independent-API-tf2126447.html#a6074818
Sent from the SQLite forum at Nabble.com.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] converting a sqlite table to dbf

[Eric Bohlman]

P Kishor wrote:

Thanks, so the answer is there is no straight-forward way of doing
this. I will export to CSV, and then rebuild a dbf using Perl.


Since you've got Perl, you can skip the CSV step; just make sure you 
have DBI and DBD::SQLite and DBD::XBase installed and create connections 
to both databases.  Then it's a simple matter of doing SELECTs on the 
SQLite connection and INSERTs on the XBase connection.



-
To unsubscribe, send email to [EMAIL PROTECTED]
-