Re: [sqlite] Sqlite,'C' & FTS - reg

On 6/25/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: sqlite3_enable_load_extension(db, 1); sqlite3_load_extension(db, "./libfts1.so", 0, 0); thanks, it works fine -- Regards, Zoobave A http://zoobave.blogspot.com/

RE: [sqlite] Trouble compiling with MSVC++ 6.0

> > The problem is actually linked to the optimizations in the release code. > If you compile it without optimizations (for example, in Debug mode), it > compiles successfully. Testing ... Without -O2 it compiles ok, -O1, -O2 fails, -O3 is ok. > I made some tests, and you can compile all the

RE: Re[2]: [sqlite] Trouble compiling with MSVC++ 6.0

I dod not believe that I am using pre-compiled headers at all. The compile command is, nicely broken across lines cl -DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TARNAME=\"sqlite\" \ -DPACKAGE_VERSION=\"3.4.0\" -DPACKAGE_STRING=\"sqlite\ 3.4.0\" \ -DPACKAGE_BUGREPORT=\"\" -DSTDC_HEADERS=1

Re: [sqlite] Trouble compiling with MSVC++ 6.0

Andreas Kupries wrote: Ticket #2457 reports difficulty building SQLite version 3.4.0 using MSVC++ 6.0. This appears to be a bug in MSVC++. See the comments on the ticket for details: http://www.sqlite.org/cvstrac/tktview?tn=2457 I do not own MSVC++ (and have no intention of acquiring a

Re: [sqlite] Full Text Search

On 6/10/07, Mark Gilbert <[EMAIL PROTECTED]> wrote: I have just started learning about Full Text search in SQlite, and I have some questions Sorry for the delayed response, I just noticed this email waiting for an answer, and nobody has ... 1) With the Amalgamated Sqlite, I guess to enable

Re[2]: [sqlite] Trouble compiling with MSVC++ 6.0

Hello Andreas, Try turning off pre-compiled headers for that module. C Monday, June 25, 2007, 6:29:40 PM, you wrote: >> > Ticket #2457 reports difficulty building SQLite version 3.4.0 >> > using MSVC++ 6.0. This appears to be a bug in MSVC++. See the >> > comments on the ticket for details:

RE: [sqlite] Trouble compiling with MSVC++ 6.0

> I know VC++ 8.0 (2005) works like a charm! I do not believe that I will have the option to upgrade. -- Andreas Kupries <[EMAIL PROTECTED]> Developer @ http://www.ActiveState.com Tel: +1 778-786-1122

RE: [sqlite] Trouble compiling with MSVC++ 6.0

> > Ticket #2457 reports difficulty building SQLite version 3.4.0 > > using MSVC++ 6.0. This appears to be a bug in MSVC++. See the > > comments on the ticket for details: > > > >http://www.sqlite.org/cvstrac/tktview?tn=2457 > > > > I do not own MSVC++ (and have no intention of acquiring a

RE: [sqlite] Introducing... ManagedSQLite

Sam: The main advantage of mine is that it is lightweight and easy to use without using ADO.NET. Daniel A. White { Kent State University: Computer Science major } { JMC TechHelp: Taylor Hall, server techie } { E-mail: [EMAIL PROTECTED] } { Colossians 3:17 } -Original Message- From:

RE: [sqlite] Trouble compiling with MSVC++ 6.0

I know VC++ 8.0 (2005) works like a charm! Daniel A. White { Kent State University: Computer Science major } { JMC TechHelp: Taylor Hall, server techie } { E-mail: [EMAIL PROTECTED] } { Colossians 3:17 } -Original Message- From: Robert Simpson [mailto:[EMAIL PROTECTED] Sent: Monday,

[sqlite] pragma page_count

How easy would it be for me to implement a "pragma page_count;" statement which returns the CURRENT page count of the database, and is much more cross-platform than my attempt to just "check the file size". --andy

RE: [sqlite] Trouble compiling with MSVC++ 6.0

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, June 25, 2007 2:39 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] Trouble compiling with MSVC++ 6.0 > > Ticket #2457 reports difficulty building SQLite version 3.4.0 > using MSVC++ 6.0. This

[sqlite] Trouble compiling with MSVC++ 6.0

Ticket #2457 reports difficulty building SQLite version 3.4.0 using MSVC++ 6.0. This appears to be a bug in MSVC++. See the comments on the ticket for details: http://www.sqlite.org/cvstrac/tktview?tn=2457 I do not own MSVC++ (and have no intention of acquiring a copy) so I am unable to

[sqlite] Re: progress handler code changed 3.4.0

On Mon, 25 Jun 2007 18:38:30 +, D. Richard Hipp wrote: >"John Belli" <[EMAIL PROTECTED]> wrote: >> If the progress handler returns non-zero, sqlite_exec is returning >> SQLITE_INTERRUPT instead of SQLITE_ABORT. Was this intentional? The >> comment says SQLITE_ABORT, but the return is being

RE: [sqlite] How to sort not binary?

Since you use C# (mentioned in a different message) you can easily write a custom collation function with SQLite.NET. http://sqlite.phxsoftware.com/ Look in the help for SQLiteFunction and particularly FunctionType.Collation. HTH, Sam --- We're

Re: [sqlite] Loose auto_vacuum.

--- Scott Hess <[EMAIL PROTECTED]> wrote: > Recently, various incremental vacuum features have been added, so you can do: > > -- Turn on incremental vacuum. > PRAGMA auto_vacuum = incremental; > > -- Release 100 pages from the freelist, or all if there are fewer. > PRAGMA

Re: [sqlite] How to sort not binary?

On 25.06.2007 00:57 CE(S)T, [EMAIL PROTECTED] wrote: > Yves Goergen <[EMAIL PROTECTED]> wrote: >> Oh, well, I just realised that this will only sort numbers "naturally" >> at the beginning of strings, but not in the middle or at the end. It >> will be a bit more complex to do that. Maybe I find a

Re: [sqlite] Unicode collation

--- [EMAIL PROTECTED] wrote: > OK. Here is a crazy idea for consideration: > > You know that you can create a custom collating function as a > DLL or shared library and load it at runtime, right? This has > been a capability since version 3.3.7. Suppose we define a > special table in the

[sqlite] SQLite Project. A contribution to manking

I know that this post is not a query about SQLite DB, and I am sorry for that. First to all, congratulation to D. Richard Hipp and this wonderful community. And I know Mr. Hipp that SQLite is open source, public domain, but I think you deserve to make money with that quantity of money. I won't

Re: [sqlite] progress handler code changed 3.4.0

"John Belli" <[EMAIL PROTECTED]> wrote: > If the progress handler returns non-zero, sqlite_exec is returning > SQLITE_INTERRUPT instead of SQLITE_ABORT. Was this intentional? The > comment says SQLITE_ABORT, but the return is being set to > SQLITE_INTERRUPT. > (vdbe.c line 553) > This change is

[sqlite] progress handler code changed 3.4.0

If the progress handler returns non-zero, sqlite_exec is returning SQLITE_INTERRUPT instead of SQLITE_ABORT. Was this intentional? The comment says SQLITE_ABORT, but the return is being set to SQLITE_INTERRUPT. (vdbe.c line 553) JAB

[sqlite] Loose auto_vacuum.

Recently, various incremental vacuum features have been added, so you can do: -- Turn on incremental vacuum. PRAGMA auto_vacuum = incremental; -- Release 100 pages from the freelist, or all if there are fewer. PRAGMA incremental_vacuum(100); -- Return the number of items on the freelist.

RE: [sqlite] Unicode collation

> -Original Message- > From: Jiri Hajek [mailto:[EMAIL PROTECTED] > Sent: Monday, June 25, 2007 8:14 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Unicode collation > > > So the choices seem to be: > > > > (1) Databases that corrupt if you move across platforms. > > (2) A

Re: [sqlite] Data structure for versioned data

Not quite the same issue, but I've set up triggers to generate a journal record whenever a record is added/changed/deleted from a table. This mechanism (triggers) could easily be used to generate a 'version' record. *** Doug F. John Stanton wrote: > We perform some versioning by holding column

Re: [sqlite] FTS2 Module

Andre du Plessis wrote: I saw this post on FTS2, and looked on the site and saw the FTS2 binary, where can I find more information on this The wiki has a lot of info. Check out: http://www.sqlite.org/cvstrac/wiki?p=FtsOne http://www.sqlite.org/cvstrac/wiki?p=FtsTwo

Re: [sqlite] Unicode collation

"Jiri Hajek" <[EMAIL PROTECTED]> wrote: > > So the choices seem to be: > > > > (1) Databases that corrupt if you move across platforms. > > (2) A 10MB database engine > > (3) Leave things as they are > > > > I prefer to go with (3) > > Yes, based on the facts I agree that (3) is the best way

AW: [sqlite] In Mem Query Performance

Don't use sqlite_get_table. Use sqlite3_prepare(_v2), sqlite3_step and sqlite3_finalize/sqlite3_reset. Mike -Ursprüngliche Nachricht- Von: RaghavendraK 70574 [mailto:[EMAIL PROTECTED] Gesendet: Montag, 25. Juni 2007 13:48 An: sqlite-users@sqlite.org Betreff: [sqlite] In Mem Query

Re: [sqlite] Unicode collation

So the choices seem to be: (1) Databases that corrupt if you move across platforms. (2) A 10MB database engine (3) Leave things as they are I prefer to go with (3) Yes, based on the facts I agree that (3) is the best way to go - a developer can decide whether to use Windows methods only,

RE: [sqlite] Introducing... ManagedSQLite

Daniel, We already have an excellent ADO.NET compliant provider for SQLite that Robert mentioned. What advantages does your wrapper provide of the existing one? SQLite.NET already provides full ADO.NET support including custom functions and collation sequences written in any .NET languages and

Re: [sqlite] Sqlite,'C' & FTS - reg

Zoobave <[EMAIL PROTECTED]> wrote: > Hello group, > > In sqlite, how to load fts1 module in 'C'? I couldn't execute the > *"select load_extension('libfts1.so');" * query using "sqlite3_exec" > function. How can i execute the above query to load fts1 module, in order > to use virtual

[sqlite] Sqlite,'C' & FTS - reg

Hello group, In sqlite, how to load fts1 module in 'C'? I couldn't execute the *"select load_extension('libfts1.so');" * query using "sqlite3_exec" function. How can i execute the above query to load fts1 module, in order to use virtual tables? by zoobave http://zoobave.blogspot.com/

[sqlite] In Mem Query Performance

Hi, We are using Sqlite in "in Memory Mode" and we have around 200 tables. Each table has 10 columns of type text. Each table has around 1 records each column has around 128bytes data. Select performance is around 2000records/sec. Pls suggest if there is a way to improve further. Table

[sqlite] Fwd: In Mem Query Performance

Hi, We are using Sqlite in "in Memory Mode" and we have around 200 tables. Each table has 10 columns of type text. Each table has around 1 records each column has around 128bytes data. Select performance is around 2000records/sec. Pls suggest if there is a way to improve further. Table

Re: [sqlite] Unicode collation

"Jiri Hajek" <[EMAIL PROTECTED]> wrote: > Ok, drh, could you share your thoughts about this. Could something > like this, i.e. some kind of recommendation be created, so that all > applications are consistent in Unicode support? > Dan's observation is correct. It seems to me that the collating

Re: [sqlite] Unicode collation

Ok, drh, could you share your thoughts about this. Could something like this, i.e. some kind of recommendation be created, so that all applications are consistent in Unicode support? Thanks, Jiri - To unsubscribe, send

Re: [sqlite] Index size

"Andre du Plessis" <[EMAIL PROTECTED]> wrote: > I have a question on index size, I have a table that by doing some > testing the DB have grown to 250MB, might not seem too large, as the > table have 4million records in it. But for this DB this table would grow > a lot larger than that. So I did

Re: [sqlite] Tomcat crashes with SQLite

"Frederic de la Goublaye" <[EMAIL PROTECTED]> wrote: > My server is under FreeBSD 5.4 > It is ok ? > I am not aware of any problems with FreeBSD 5.4. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email

Re: [sqlite] In Mem Query Performance

RaghavendraK 70574 <[EMAIL PROTECTED]> wrote: > Hi, > > When the DB is opened in "in Memory mode",performance of query does not > improve. For table which has 10 columns of type Text and each column having > 128bytes data and having a total of 1 records. Performance is around 2400 >

[sqlite] Index size

I have a question on index size, I have a table that by doing some testing the DB have grown to 250MB, might not seem too large, as the table have 4million records in it. But for this DB this table would grow a lot larger than that. So I did some tests with a simple table 3 fields FIELD1 is a

[sqlite] FTS2 Module

I saw this post on FTS2, and looked on the site and saw the FTS2 binary, where can I find more information on this I searched the documentation and can't find anything, it would be appreciated if someone can point me to a doc that explains what it is and how to use it. Thank you.

Re: [sqlite] Tomcat crashes with SQLite

My server is under FreeBSD 5.4 It is ok ? Cheers Frederic On 6/25/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Frederic de la Goublaye" <[EMAIL PROTECTED]> wrote: > My server crashed again. > > I recompiled sqlite3-3-5 with this configure option > --enable-threadsafe =yes > > But I read

[sqlite] In Mem Query Performance

Hi, When the DB is opened in "in Memory mode",performance of query does not improve. For table which has 10 columns of type Text and each column having 128bytes data and having a total of 1 records. Performance is around 2400 records/sec. Any ways to improve it. Thanks in advance.