[sqlite] sqlite3_prepare performance

[Farzana]

Dear All,

We are working in eVC++ environment with SQLite database.
We are using the functions sqlite3_prepare and sqlite3_step to execute the
query. While passing the sqlite3_prepare step its taking some time whereas
after passing this step the other functions are quite fast. We are passing
the parameters to the function as 
sqlite3_prepare(db,query,-1,,NULL);
Are we missing out something so that the execution of this step gets slower
or How can we improve the performance?
Kindly help in this regard.
Thanks in advance.

Regards,
Farzana.

-- 
View this message in context: 
http://www.nabble.com/sqlite3_prepare-performance-tp16717822p16717822.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] want to purchase

[Dr Gerard Hammond]

For a SQLite Server product, try

http://www.realsoftware.com/products/realsql/index.php



On 15/04/2008, at 2:20 AM, Arvind M wrote:

> dear sir
>
> i want to purchase of sqlite server kinly give me guidance
>
> arvind
> systime
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



Cheers.

--

Dr Gerard Hammond
http://www.macsos.com.au

The Macintosh may only have 10% of the market, but it is clearly the  
top 10%.



Cheers.

--

Dr Gerard Hammond
http://www.macsos.com.au

The Macintosh may only have 10% of the market, but it is clearly the  
top 10%.



Cheers.

--

Dr Gerard Hammond
Garvan Institute of Medical Research

...No tequila to be had.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [OT] Program to document database l ayout

[Andrew McDermott]

Rich Shepard <[EMAIL PROTECTED]> writes:

> On Wed, 16 Apr 2008, Hartwig Wiesmann wrote:
>
>> this is a bit off topic: I am looking for a program that is suitable for
>> documenting the structure of a SQLite database. I am looking for a program
>> that can visualize the relations between different tables, their
>> connections and indices. Furthermore, comments should be attached to
>> tables or their fields or references to other tables. It is not necessary
>> to read the structure itself from the database. Do you have any
>> recommendations?
>
> Hartwig,
>
>Ah! You want to create E-R Diagrams for your schema. Allow me to recommend
> PSTricks with the pst-dbicons package. You create a LaTeX file specifying
> the paths, shapes, and text, then compile it. You get total control over
> everything while getting beautifully typeset output.

Interesting.  Is there an example we could look at?

>
> Rich
>
> -- 
> Richard B. Shepard, Ph.D.   |  IntegrityCredibility
> Applied Ecosystem Services, Inc.|Innovation
>  Voice: 503-667-4517  Fax: 503-667-8863
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

-- 
andy
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite in DotNet environment and virtual tables

[Sylko Zschiedrich]

Hi all,

we are using SQLite in a DotNet environment and want to support virtual
tables via sqlite3_load_extension.

Did anybody know a wrapper for SQLite or sample code for implementing
virtual tables in DetNet. (C#)?

I know there are many DotNet wrappers for SQLite but noone supports
virtual tables. :-( 


Thanks
Sylko
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite in DotNet environment and virtual tables

[Michael Ruck]

Hi Sylko,

sqlite3_load_extension is unfortunately not directly usable from .NET. No
.NET language (except MC++) exposes the ability
to export functions from a DLL. In order to use extensions you need to
create at least a small helper DLL, which can then
be used as an adapter or proxy to an extension written in any .NET language.
As this can not be done generically without
a lot of logic it has not been done for any .NET wrapper AFAIK.

Mike

> -Ursprüngliche Nachricht-
> Von: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] Im Auftrag von Sylko 
> Zschiedrich
> Gesendet: Mittwoch, 16. April 2008 10:53
> An: sqlite-users@sqlite.org
> Betreff: [sqlite] SQLite in DotNet environment and virtual tables
> 
> Hi all,
> 
> we are using SQLite in a DotNet environment and want to 
> support virtual tables via sqlite3_load_extension.
> 
> Did anybody know a wrapper for SQLite or sample code for 
> implementing virtual tables in DetNet. (C#)?
> 
> I know there are many DotNet wrappers for SQLite but noone 
> supports virtual tables. :-( 
> 
> 
> Thanks
> Sylko
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE_OMIT_TRIGGER compilation problems

[D. Richard Hipp]

On Apr 15, 2008, at 10:34 PM, Richard Klein wrote:
> I compiled SQLite 3 (version 3.5.7), specifying
> SQLITE_OMIT_TRIGGER to reduce the size of the
> generated code.
>

The OMIT macros are not supported in the preprocessed source
code or in the amalgamation.  To use the OMIT macros you much
compile from canonical sources using a unix-like development
environment.

The reason for this is that SQLite includes several code files that
contain automatically generated code.  And the generated code
depends on which OMIT macros are present.

D. Richard Hipp
[EMAIL PROTECTED]



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_prepare performance

[Igor Tandetnik]

"Farzana" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> We are working in eVC++ environment with SQLite database.
> We are using the functions sqlite3_prepare and sqlite3_step to
> execute the query. While passing the sqlite3_prepare step its taking
> some time whereas after passing this step the other functions are
> quite fast.

Is this the very first SQLite call after sqlite3_open? The first call 
needs to read and cache database schema, and so it takes an atypically 
long time. Warm up the connection first before doing any measurements, 
if you want to measure the steady state and not one time start-up 
effects.

Also, for complex queries it is not unusual that preparing the query 
(parsing, figuring out the execution plan, optimizing) may take longer 
than actually executing it. This is precisely why you are given an 
option to prepare a statement once and then execute it many times.

Finally, see 
http://www.mail-archive.com/sqlite-users@sqlite.org/msg30073.html

Igor Tandetnik 



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite in DotNet environment and virtual tables

[Samuel Neff]

While System.Data.SQLite does not support virtual tables, it does support
custom funcions written in .NET and is open source, so that should get you a
long way towards writing virtual tables in .NET (but still will require some
C interop programming).

http://sqlite.phxsoftware.com/

HTH,

Sam


On Wed, Apr 16, 2008 at 4:53 AM, Sylko Zschiedrich <[EMAIL PROTECTED]>
wrote:

> Hi all,
>
> we are using SQLite in a DotNet environment and want to support virtual
> tables via sqlite3_load_extension.
>
> Did anybody know a wrapper for SQLite or sample code for implementing
> virtual tables in DetNet. (C#)?
>
> I know there are many DotNet wrappers for SQLite but noone supports
> virtual tables. :-(
>
>
> Thanks
> Sylko
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
-
We're Hiring! Seeking passionate Flex, C#, or C++ (RTSP, H264) developer.
Position is in the Washington D.C. metro area. Contact
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite version 3.5.8

[D. Richard Hipp]

SQLite version 3.5.8 is now available on the SQLite website

 http://www.sqlite.org/

The primary focus of this release is performance enhancements.
But there are also some interface changes:

*  The sqlite3_randomness() interface has been added.
*  The sqlite3_context_db_handle() interface has been added.
*  The sqlite3_limit() interface has been added.
*  The VACUUM command can now be used to change the
database page size.

There are also many bug fixes, though none of the bugs fixed
appear to be major.

As always, please report any problem you may encounter.

D. Richard Hipp
[EMAIL PROTECTED]

P.S.:  As I type this, two test failures have emerged in the new
release:  utf16-bind-6.4 and utf16-bind-7.4.  Both failures are
benign.  The fault is actually in the test script, not in SQLite itself.
The test script in these cases assumes a UTF8 database and
hence clearly does not work if the database uses UTF16.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.5.8

[Ken]

The download page does not have the almagamation in the .tar.gz format.
The zip version of the amalgamation does not contain the ./configure or 
autoconf as did version 3.5.7. 

The amalgamation (.zip) did not have the shell.c code.

Was this intended ?

Thanks,
Ken


"D. Richard Hipp" <[EMAIL PROTECTED]> wrote: SQLite version 3.5.8 is now 
available on the SQLite website

 http://www.sqlite.org/

The primary focus of this release is performance enhancements.
But there are also some interface changes:

*  The sqlite3_randomness() interface has been added.
*  The sqlite3_context_db_handle() interface has been added.
*  The sqlite3_limit() interface has been added.
*  The VACUUM command can now be used to change the
database page size.

There are also many bug fixes, though none of the bugs fixed
appear to be major.

As always, please report any problem you may encounter.

D. Richard Hipp
[EMAIL PROTECTED]

P.S.:  As I type this, two test failures have emerged in the new
release:  utf16-bind-6.4 and utf16-bind-7.4.  Both failures are
benign.  The fault is actually in the test script, not in SQLite itself.
The test script in these cases assumes a UTF8 database and
hence clearly does not work if the database uses UTF16.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.5.8

[D. Richard Hipp]

On Apr 16, 2008, at 12:25 PM, Ken wrote:
>
> The download page does not have the almagamation in the .tar.gz  
> format.
> The zip version of the amalgamation does not contain the ./configure  
> or autoconf as did version 3.5.7.
>
> The amalgamation (.zip) did not have the shell.c code.
>
> Was this intended ?
>

There are a dozen different build products in the latest release.
I'm sorry that the one you wanted is not there.  Perhaps we can find
time to add it later.

D. Richard Hipp
[EMAIL PROTECTED]



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Available extensions for sqlite

[P Kishor]

On Wed, Apr 16, 2008 at 10:59 AM, Marco Bambini <[EMAIL PROTECTED]> wrote:
> Is there a repository that collects a list of available extensions for
>  sqlite?
>
>  Until now I found just an extension:
>  http://www.gaia-gis.it/spatialite/
>


Fwiw, some of us mapping enthusiasts from the Open Source GeoSpatial
Foundation and PostGIS groups have started working on using SQLite for
GIS work. I have set up a wiki at sqlitegis.org/wiki and we will add
some code to sqlitegis.org/svn soon.

We are also looking at spatialite as well. It seems like a very
promising start and should form the basis for more work.

-- 
Puneet Kishor http://punkish.eidesis.org/
Ph.D. Program, Nelson Institute, UW-Madison http://www.nelson.wisc.edu/
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org/
---
collaborate, communicate, compete
===
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [OT] Program to document database lay out

[Petite Abeille]

On Apr 16, 2008, at 12:09 AM, Hartwig Wiesmann wrote:

>  I am looking for a program that can visualize the relations between  
> different tables, their connections and indices.

Martin Krzywinski's Schemaball is rather interesting:

http://www.visualcomplexity.com/vc/project_details.cfm?id=42=2=Computer%20Systems

http://mkweb.bcgsc.ca/schemaball/?home

--
PA.
http://alt.textdrive.com/nanoki/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.5.8

[Rich Shepard]

On Wed, 16 Apr 2008, Ken wrote:

> The download page does not have the almagamation in the .tar.gz format.
> The zip version of the amalgamation does not contain the ./configure or
> autoconf as did version 3.5.7.

Ken,

   Why not grab the source tarball and build from that? I just did this and
upgraded my Slackware installations with it. Granted that I have no idea
what an "almagamation" is that differs from the source tarball, but you
can't go wrong with the latter.

Rich

-- 
Richard B. Shepard, Ph.D.   |  IntegrityCredibility
Applied Ecosystem Services, Inc.|Innovation
 Voice: 503-667-4517  Fax: 503-667-8863
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Available extensions for sqlite

[Lauri Ojansivu]

Well, there is new features sitting on cvstrack of Sqlite, from there
I'd like to have first
Ticket 2939: instr, locate, position, charindex etc:
http://www.sqlite.org/cvstrac/tktview?tn=2939,35

There author of the ticket Brodies says:
"If this is accepted then I will write the documentation and test
cases for it too. Just contact me. As few suggestions appear to be
accepted, I won't bother until then."

At freenode #tcl channel I pointed one user that needed instr to
tksqlite that has
instr and other features included. I haven't checked if they are added
with tcl or c.
http://reddog.s35.xrea.com/wiki/TkSQLite.html

So it would be nice if someone collected all nice patches and made binary
feature-added versions available. If there already is such one then please
post the url.

All active sqlite tickets are at:
http://www.sqlite.org/cvstrac/rptview?rn=35

It would be nice too if there was sqlite with tcl bindings (.dll/.so)
compiled for
different architectures (win32/64 linux-x86/64 openbsd solaris etc) so
that it would
be possible to make tcl starkit supporting all those.
Examles of such starkits can be found in sdarchive:
http://tcl.tk/starkits/

- Lauri

2008/4/16, Marco Bambini <[EMAIL PROTECTED]>:
> Is there a repository that collects a list of available extensions for
>  sqlite?
>
>  Until now I found just an extension:
>  http://www.gaia-gis.it/spatialite/
>
>  Thanks.
>  ---
>  Marco Bambini
>  http://www.sqlabs.net
>  http://www.sqlabs.net/blog/
>  http://www.sqlabs.net/realsqlserver/
>
>
>
>  ___
>  sqlite-users mailing list
>  sqlite-users@sqlite.org
>  http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.5.8

[Ken]

Thanks Rich,

I'm pretty familiar with both the amalgamation version and the full source. 

After the amalgamation failed! I built from the full source.

I wasn't so concerned about the .zip .tar.gz thing as I was the content 
difference between the amalgamation for 3.5.7 vs 3.5.8... 

The 3.5.8 amalgamation is missing the capability to build the sqlite3 shell 
command. Whereas 3.5.7 did build the sqlite3 from the amalgamation.

Regards,
Ken


Rich Shepard <[EMAIL PROTECTED]> wrote: On Wed, 16 Apr 2008, Ken wrote:

> The download page does not have the almagamation in the .tar.gz format.
> The zip version of the amalgamation does not contain the ./configure or
> autoconf as did version 3.5.7.

Ken,

   Why not grab the source tarball and build from that? I just did this and
upgraded my Slackware installations with it. Granted that I have no idea
what an "almagamation" is that differs from the source tarball, but you
can't go wrong with the latter.

Rich

-- 
Richard B. Shepard, Ph.D.   |  IntegrityCredibility
Applied Ecosystem Services, Inc.|Innovation
 Voice: 503-667-4517  Fax: 503-667-8863
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.5.8

[Ken]

Sorry I should have been more clear:

The amalgamation for 3.5.8 is missing the ability to build  sqlite3 shell 
command.

The amalgamtion is missing configure/autoconf capability as well. Where 3.5.7 
had all of this.

I was not so much concerned between zip vs .tar.gz format, but the content of 
the amalgamation.

If this is by design, no problem I can build from the full source.

Regards,
Ken


"D. Richard Hipp" <[EMAIL PROTECTED]> wrote: 
On Apr 16, 2008, at 12:25 PM, Ken wrote:
>
> The download page does not have the almagamation in the .tar.gz  
> format.
> The zip version of the amalgamation does not contain the ./configure  
> or autoconf as did version 3.5.7.
>
> The amalgamation (.zip) did not have the shell.c code.
>
> Was this intended ?
>

There are a dozen different build products in the latest release.
I'm sorry that the one you wanted is not there.  Perhaps we can find
time to add it later.

D. Richard Hipp
[EMAIL PROTECTED]




___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite>=3.5.6 does not open database file

[Steve Topov]

Any clues?

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Steve Topov
Sent: Monday, April 14, 2008 5:02 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] SQLite>=3.5.6 does not open database file

I am on Windows XP using sqlite 3.5.6 dll created from the source. I
debugged the code - Sqlite3_open returns OK but any other function after
that returns 1.
For example sqlite3_prepare returns 1 when I do "Select * from
sqlite_master". Same for sqlite3_execute. Tried different SQL statements
- same error.
If I switch to 3.3.5 dll the problem goes away.

Regards.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of D. Richard Hipp
Sent: Monday, April 14, 2008 4:46 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQLite>=3.5.6 does not open database file


On Apr 14, 2008, at 4:30 PM, Steve Topov wrote:
> I already reported this bug but did not receive any responds so I am
> trying one more time.
> The problem:
> SQLite version 3.5.6 and up returns an error when opening some  
> database
> files. The error is “SQL logic error or missing database”.
> Version prior to version 3.5.6 works fine with these database files.
>
> I do not know the version of SQLite the database file in question was
> created with. And I am talking about SQLite 3 database file – not  
> SQLite
> 2, not Microsoft Access,
> not any other file format.
>
> To make story short: SQLite 3.5.6 can not open SQLite 3 database file.
>
>

I'm working with the file named "dpdshop.sl3" that you sent me,
5444608 bytes in size.  MD5 checksum 9fa76c1610a5e7c826d2745191e7a401
I can open and read this file without problems on MacOSX using
SQLite version 3.4.0, 3.5.6, 3.5.7 and the latest in CVS.  I ran

PRAGMA integrity_check

using all four versions of SQLite and all return "ok".


D. Richard Hipp
[EMAIL PROTECTED]



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite>=3.5.6 does not open database file

[D. Richard Hipp]

On Apr 16, 2008, at 4:41 PM, Steve Topov wrote:
> Any clues?
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Steve Topov
> Sent: Monday, April 14, 2008 5:02 PM
> To: 'General Discussion of SQLite Database'
> Subject: Re: [sqlite] SQLite>=3.5.6 does not open database file
>
> I am on Windows XP using sqlite 3.5.6 dll created from the source.

Why don't you try the pre-compiled DLLs off of the website.


D. Richard Hipp
[EMAIL PROTECTED]



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE_OMIT_TRIGGER compilation problems

[Richard Klein]

> On Apr 15, 2008, at 10:34 PM, Richard Klein wrote:
>> I compiled SQLite 3 (version 3.5.7), specifying
>> SQLITE_OMIT_TRIGGER to reduce the size of the
>> generated code.
>>
> 
> The OMIT macros are not supported in the preprocessed source
> code or in the amalgamation.  To use the OMIT macros you much
> compile from canonical sources using a unix-like development
> environment.
> 
> The reason for this is that SQLite includes several code files that
> contain automatically generated code.  And the generated code
> depends on which OMIT macros are present.
> 
> D. Richard Hipp
> [EMAIL PROTECTED]

Unfortunately, our build system doesn't support the notion
of source code that is automatically generated.  However,
it does support the ability to turn "capabilities" on or
off at build time, and to have these capabilities map to
compilation switches.

Thus, for example, the capability "CAP_SQL_TRIGGER = 0"
can map to -DSQLITE_OMIT_TRIGGER at compile time.  I plan
to create capabilities corresponding to most of the SQLITE_
OMIT_xxx options.

I think this will work just fine, even though I am using
the preprocessed source code.  All it means is that the
parser will be bigger than it needs to be.

By the way, I originally tried to use the amalgamation.
While it worked, it was unwieldy, for a number of reasons:

(1) Visual Studio has trouble generating line number info
for source files containing more than 64K lines.

(2) Perforce (the source control system that we use) has
trouble diff'ing two versions of a very large file.

(3) We have to make numerous small mods to SQLite in order
to get it to compile on all our target platforms (set-top
boxes), and it is simply easier to edit several small, pre-
processed source files instead of one huge amalgamation file.

There are several reasons we get many compilation warnings
(and even a few errors) when we compile SQLite:

(1) Each target has its own, often archaic, compiler,
which has probably not been tested by the SQLite develop-
ment team;

(2) We usually compile at a fairly high warning level,
so we get a lot of warnings about implicit type conversions.
Inserting an explicit type cast usually fixes these.

(3) We compile several targets using a C++, not C, compiler.
There are a few places in the SQLite source where this causes
problems.  Most notably, in sqliteInt.h a number of nested
structs are defined; these cause scoping problems in C++.
The workaround is to move the nested struct outside of (and
immediately preceding) the main struct.

- Richard

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Where To Put SQLite3.exe or SQLite3.dll for Windows Version of PHP?

[Robert L Cochran]

Where exactly do I install the sqlite3.exe (or should I use sqlite3.dll)
file for Microsoft Windows such that the Windows version of PHP  5.x
will find it and make use of it? Is it sufficient to create a C:\Program
Files\SQLite3 folder and put the SQLite 3.5.8 module(s) there, then edit
my path variable to point to it?

Thanks

Bob Cochran
Greenbelt, Maryland, USA
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Where To Put SQLite3.exe or SQLite3.dll for Windows Version of PHP?

[Eugene Wee]

Hi,

If you want the command line program for working with SQLite 3
databases, then sqlite3.exe is what you are looking for. Placing it in
the system path will do if you want to use it from everywhere.

Regards,
Eugene Wee

On Wed, 2008-04-16 at 20:06 -0400, Robert L Cochran wrote:
> Where exactly do I install the sqlite3.exe (or should I use sqlite3.dll)
> file for Microsoft Windows such that the Windows version of PHP  5.x
> will find it and make use of it? Is it sufficient to create a C:\Program
> Files\SQLite3 folder and put the SQLite 3.5.8 module(s) there, then edit
> my path variable to point to it?
> 
> Thanks
> 
> Bob Cochran
> Greenbelt, Maryland, USA


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.5.8

[Dan]

On Apr 17, 2008, at 12:23 AM, Ken wrote:

> Sorry I should have been more clear:
>
> The amalgamation for 3.5.8 is missing the ability to build  sqlite3  
> shell command.
>
> The amalgamtion is missing configure/autoconf capability as well.  
> Where 3.5.7 had all of this.
>
> I was not so much concerned between zip vs .tar.gz format, but the  
> content of the amalgamation.

"sqlite-amalgamation-3.5.8.tar.gz" which is the file that allows
you do "./configure && make install" to build from the amalgamation
is up now.

Dan.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users