[sqlite] sqlite3_prepare performance

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

Re: [sqlite] want to purchase

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 > > > ___ >

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

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

[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

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

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

Re: [sqlite] SQLITE_OMIT_TRIGGER compilation problems

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

Re: [sqlite] sqlite3_prepare performance

"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

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

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

[sqlite] SQLite version 3.5.8

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()

Re: [sqlite] SQLite version 3.5.8

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

Re: [sqlite] SQLite version 3.5.8

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

Re: [sqlite] Available extensions for sqlite

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

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

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:

Re: [sqlite] SQLite version 3.5.8

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

Re: [sqlite] Available extensions for sqlite

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

Re: [sqlite] SQLite version 3.5.8

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

Re: [sqlite] SQLite version 3.5.8

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

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

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

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

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

Re: [sqlite] SQLITE_OMIT_TRIGGER compilation problems

> 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

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

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

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

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

Re: [sqlite] SQLite version 3.5.8

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