Re: [sqlite] Proper use of sqlite-amalgamation.

On Thu, Apr 3, 2008 at 7:11 PM, Amit <[EMAIL PROTECTED]> wrote: > > Ok that is good to know. I will play around with the source > distribution and try to figure out how to get it to work with python > 2.5. According to the python 2.5 documentation, to build Python with > sqlite3, I need the lib

Re: [sqlite] 3.5.7 & TCL: "undefined symbol: sqlite3StrICmp"

On Thu, Apr 3, 2008 at 10:46 PM, Zbigniew Baniewski <[EMAIL PROTECTED]> wrote: > I'm sorry to confirm the problem described at http://tinyurl.com/29wc8x > > #v+ > $ tclsh8.5 > % package require sqlite3 > couldn't load file "/usr/lib/sqlite3/libtclsqlite3.so.0": > /usr/lib/sqlite3/libtclsql

Re: [sqlite] Proper use of sqlite-amalgamation.

On Fri, 04 Apr 2008 07:42:50 +0200 Dimitri <[EMAIL PROTECTED]> wrote: > Hi, > > > I just had several questions regarding SQLite. While at the download > > page, it states that sqlite-amalgamation is the "preferred" way of > > acquiring SQLite code. So I went ahead and downloaded the latest > > ve

Re: [sqlite] 3.5.7 Compile Fails On sqlite3.c

On Thu, Apr 3, 2008 at 7:05 PM, Robert L Cochran <[EMAIL PROTECTED]> wrote: > Here is what I did: > > tar -xvzf sqlite-3.5.7.tar.gz > cd sqlite-3.5.7 > mkdir bld > cd !$ > ../configure --prefix=/usr/local/sqlite-3.5.7 --disable-tcl > --enable-threadsafe > make > Yeah, this was reported & fi

Re: [sqlite] Proper use of sqlite-amalgamation.

Hi, > I just had several questions regarding SQLite. While at the download > page, it states that sqlite-amalgamation is the "preferred" way of > acquiring SQLite code. So I went ahead and downloaded the latest > version (3.5.7). I get 3 source files and I am stuck. I tried reading > the documenta

Re: [sqlite] 3.5.7 & TCL: "undefined symbol: sqlite3StrICmp"

On Thu, Apr 03, 2008 at 09:54:15PM -0500, John Stanton wrote: > Install TCL Another one? What for? -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list

Re: [sqlite] 3.5.7 & TCL: "undefined symbol: sqlite3StrICmp"

Zbigniew Baniewski wrote: > I'm sorry to confirm the problem described at http://tinyurl.com/29wc8x > > #v+ > $ tclsh8.5 > % package require sqlite3 > couldn't load file "/usr/lib/sqlite3/libtclsqlite3.so.0": > /usr/lib/sqlite3/libtclsqlite3.so.0: undefined symbol: sqlite3StrICmp > #v-

[sqlite] 3.5.7 & TCL: "undefined symbol: sqlite3StrICmp"

I'm sorry to confirm the problem described at http://tinyurl.com/29wc8x #v+ $ tclsh8.5 % package require sqlite3 couldn't load file "/usr/lib/sqlite3/libtclsqlite3.so.0": /usr/lib/sqlite3/libtclsqlite3.so.0: undefined symbol: sqlite3StrICmp #v- Does there exist any cure? --

Re: [sqlite] 3.5.7 Compile Fails On sqlite3.c

Robert L Cochran wrote: > Here is what I did: > > tar -xvzf sqlite-3.5.7.tar.gz > cd sqlite-3.5.7 > mkdir bld > cd !$ > ../configure --prefix=/usr/local/sqlite-3.5.7 --disable-tcl > --enable-threadsafe > make > > --

Re: [sqlite] Proper use of sqlite-amalgamation.

On Thu, Apr 3, 2008 at 3:24 PM, Matthew L. Creech <[EMAIL PROTECTED]> wrote: > On Thu, Apr 3, 2008 at 5:39 PM, Amit <[EMAIL PROTECTED]> wrote: > > > > 1. Is there any documentation that I may have missed that addresses > > the above issue? If not, there probably should be a wiki page > > re

[sqlite] 3.5.7 Compile Fails On sqlite3.c

Here is what I did: tar -xvzf sqlite-3.5.7.tar.gz cd sqlite-3.5.7 mkdir bld cd !$ ../configure --prefix=/usr/local/sqlite-3.5.7 --disable-tcl --enable-threadsafe make -- (output of make is shown be

Re: [sqlite] Virtual table used to query big external database

You can _generally_ work around this kind of problem using sub-selects. So instead of: SELECT x FROM fts_table WHERE fts_table MATCH "y" OR fts_table MATCH "z"; You might write: SELECT x FROM fts_table WHERE rowid IN (SELECT rowid FROM fts_table WHERE fts_table MATCH "y") OR rowid IN (SELECT r

Re: [sqlite] Proper use of sqlite-amalgamation.

On Thu, Apr 3, 2008 at 5:39 PM, Amit <[EMAIL PROTECTED]> wrote: > > 1. Is there any documentation that I may have missed that addresses > the above issue? If not, there probably should be a wiki page > regarding this. I could create a wiki page with my notes regarding > this. > There's: http

Re: [sqlite] Windows XP, where should I place the Sqlite .DLL's for best Sqlite operation, for usage with other COM components?

Pretty much any folder in the PATH will do. You can put it \windows\system32\ but that can be a pain to get to and remember. I usually create one or more folders to hold non-Windows misc binaries, and add those to the system PATH. The most recent is C:\usr\bin\ for executables, and C:\usr\lib

[sqlite] Proper use of sqlite-amalgamation.

Hi everyone, This is my first time diving into SQLite and I am very excited about this. Thanks to all the developers. I just had several questions regarding SQLite. While at the download page, it states that sqlite-amalgamation is the "preferred" way of acquiring SQLite code. So I went ahead and

Re: [sqlite] sqlite3_finalize(pReadStmt); and sqlite3_close(pDB);

On Apr 3, 2008, at 5:09 PM, Joanne Pham wrote: > Hi All, > Should we always call sqlite3_finalize(pReadStmt); and > sqlite3_close(pDB) after we have done with read/write to database. > Or sqlite3_finalize(pReadStmt) is good enough. > Please advice what is the sequence of statement that we shou

Re: [sqlite] sqlite3_aggregate_context with C++ classes

On Apr 3, 2008, at 3:39 PM, Steven Fisher wrote: > Can Final be called without Step first being called? Yes. > > > If Step is called, will Final always be called? Yes D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sql

[sqlite] sqlite3_finalize(pReadStmt); and sqlite3_close(pDB);

Hi All, Should we always call sqlite3_finalize(pReadStmt); and sqlite3_close(pDB) after we have done with read/write to database. Or sqlite3_finalize(pReadStmt) is good enough. Please advice what is the sequence of statement that we should call after we are done with database activities(read/wri

Re: [sqlite] Windows XP, where should I place the Sqlite .DLL's for best Sqlite operation, for usage with other COM components?

On Thu, 3 Apr 2008 16:09:09 -0400, you wrote: > For Windows XP, where should I place the > Sqlite .DLL's for best Sqlite operation, > and for usage with other COM components? There is no easy answer, but enough information to base your decision upon: http://msdn2.microsoft.com/en-us/library/ms6

Re: [sqlite] Count(1)

A little bit more info: SELECT COUNT(*) is implemented as a full table scan, so SQLite is visiting every row in the table, which will get slower and slower as the table gets bigger and the database fragments. This differs from many database engines (which implement an optimization for this) Doin

[sqlite] Windows XP, where should I place the Sqlite .DLL's for best Sqlite operation, for usage with other COM components?

For Windows XP, where should I place the Sqlite .DLL's for best Sqlite operation, and for usage with other COM components? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite3_aggregate_context with C++ classes

Can Final be called without Step first being called? If Step is called, will Final always be called? I know the intention is to call sqlite3_aggregate_context with the size I really need and not allocate anything myself, but I want to store a pointer to a C++ class in the aggregate context. I

Re: [sqlite] Count(1)

You could use a trigger to keep the running total in a seperate table. "Mahalakshmi.m" <[EMAIL PROTECTED]> wrote: Hi, I am having 4 records in my Harddisk. My Processor speed is 400 Mhz. For "SELECT COUNT(1) FROM MUSIC ;" its getting more time to display the count. I have also tried with "S

Re: [sqlite] How to recover from database corruption? (and why does it happen?)

En/na Luca Olivetti ha escrit: > En/na Dennis Cote ha escrit: >> The original corruption may well have been caused by omitting the thread >> safe option on the version of SQLite you were using. > > Pheew, I hope it is really so. A quick follow-up: everything has been working fine for almost one

Re: [sqlite] Count(1)

On 4/3/08, Mahalakshmi.m <[EMAIL PROTECTED]> wrote: > Hi, > > I am having 4 records in my Harddisk. > My Processor speed is 400 Mhz. > > For "SELECT COUNT(1) FROM MUSIC ;" its getting more time to display the > count. > I have also tried with "SELECT COUNT(*) FROM MUSIC ;This also take mor

[sqlite] Count(1)

Hi, I am having 4 records in my Harddisk. My Processor speed is 400 Mhz. For "SELECT COUNT(1) FROM MUSIC ;" its getting more time to display the count. I have also tried with "SELECT COUNT(*) FROM MUSIC ;This also take more time. Is there any other way we can get the Total number of records.

Re: [sqlite] Trigger's actions and callbacks

D. Richard Hipp wrote: > > > SQLite is not reentrant through the update hook. > > > D. Richard Hipp > [EMAIL PROTECTED] > > Thanks a lot. I would consider using user-defined functions as callbacks with updated data in its parameters. -- View this message in context: http://www.nabble.co

Re: [sqlite] Trigger's actions and callbacks

Igor Tandetnik wrote: > > >> >> sqlite3_update_hook(db, Callback, db); >> >> and when trying to access to the db inside callback >> >> sqlite3_prepare((sqlite3*)data_arg_3, [...]) > > Show how Callback is declared. Did you really name its first parameter > dat

[sqlite] Does SQLite require 64-bit integers?

I need to know if SQLite works at all if the platform doesn't have a 64-bit integer type. I see that SQLite has some #ifdefing like #ifdef SQLITE_INT64_TYPE that seems to be for the case when the platform does not have the type natively, but I don't see where this would actually be implemented