Re: [sqlite] Accent Insensitive search

Hello! On Tuesday 24 March 2009 20:19:00 aditya siram wrote: > Hi all, > Is there a way to do an accent/diacritic insensitive search in sqlite? For > example I want to a query to find " `a blanc " with the search term "a > blanc". Yes.

Re: [sqlite] speeding up row by row lookup in a large db

Hello! On Saturday 21 March 2009 17:31:45 P Kishor wrote: > My intent is to simply retrieve a BLOB and > deserialize it... it would possibly be quicker than 33 ms per > retrieval. Well, I haven't yet completed this test because each BLOB > is taking about 430 KB. At 1 million rows, that is going

[sqlite] pragma quick_check, how do I use it in C?

Hi, I can't get the quick_check instruction to work but I'm sure that I must be doing something really stupid. It seems like my callback function isn't invoked. I have this (just for testing) struct which should be initialised properly when the callback is invoked, but the values are

[sqlite] Strict affinity again

Hi everyone, I'm new to sqlite and this mailing list and hope to get some help here. I've used SQLite for some projects now and I must say, that it is the fastes database I ever used. Great work! But there is one thing, that I really dislike, because I get errors sometimes with this and that is

Re: [sqlite] pragma quick_check, how do I use it in C?

On Mar 25, 2009, at 8:44 AM, Jules Colding wrote: > Hi, > > I can't get the quick_check instruction to work... I'm > using SQlite3 3.4.0. quick_check was added in version 3.5.5. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list

Re: [sqlite] Strict affinity again

On Mar 25, 2009, at 9:02 AM, sqlite.20.tomca...@spamgourmet.com wrote: > Hi everyone, > > I'm new to sqlite and this mailing list and hope to get some help > here. I've used SQLite for some projects now and I must say, that it > is the fastes database I ever used. Great work! > > But there is

Re: [sqlite] pragma quick_check, how do I use it in C?

On 25/03/2009, at 14.04, D. Richard Hipp wrote: > > On Mar 25, 2009, at 8:44 AM, Jules Colding wrote: > >> Hi, >> >> I can't get the quick_check instruction to work... I'm >> using SQlite3 3.4.0. > > quick_check was added in version 3.5.5. OK, that was easy :-( Thanks, jules

Re: [sqlite] pragma quick_check, how do I use it in C?

On 25/03/2009, at 14.04, D. Richard Hipp wrote: > > On Mar 25, 2009, at 8:44 AM, Jules Colding wrote: > >> Hi, >> >> I can't get the quick_check instruction to work... I'm >> using SQlite3 3.4.0. > > quick_check was added in version 3.5.5. BTW: when was integrity_check added? Thanks, jules

Re: [sqlite] Strict affinity again

I'd be willing to bet that amongst experienced SQLite users, you're in the minority. More importantly, I don't think Dr. Hipp agrees with you, so the discussion is very likely moot. :) -T On Wed, Mar 25, 2009 at 9:02 AM, wrote: > Hi everyone, > >

Re: [sqlite] pragma quick_check, how do I use it in C?

On Mar 25, 2009, at 9:15 AM, Jules Colding wrote: > > BTW: when was integrity_check added? > Version 2.3.0. The original name was "sanity_check". The name was changed to "integrity_check" for 2.4.0. D. Richard Hipp d...@hwaci.com ___

[sqlite] Insert performance in 3.6.11 vs. 3.5.5

Hi there, I have just upgraded SQLite in our application from 3.5.5 to 3.6.11 (we are using the amalgamation), and I have noticed a sharp drop in insert performance to more than half the speed that we had with 3.5.5. We are using SQLite in an embedded Linux device, and the database files

[sqlite] Compilation error enabling ICU and FTS3, Sqlite 3.6.11, Ubuntu Hardy libicu-dev

Hi all, I am trying to compile Sqlite with full text search and icu support. I installed libicu-dev from the Ubuntu Hardy repos. I downloaded the amalgamation package [1] and added the icu and fts option to the sqlite3.c file [2]. I now get the following compilation error: gcc

Re: [sqlite] Step Query

Hi Dennis, On Tue, 24 Mar 2009 18:23:23 -0600, Dennis Cote wrote: >vinod1 wrote: >> I am new to sqlite and C. >> >> I have not been able to write a code which would read row by row using >> sqlite3_step. >> >> Could anybody guide me please. >> >Hi, > >This code is

Re: [sqlite] Strict affinity again

On Wed, 25 Mar 2009 13:06:24 -0400, "Wilson, Ron P" wrote: >Cool! I didn't think of doing that. >I presume this would incur a performance hit >on insert/update to check the constraint Not much. The column data is _dynamically_ typed, so SQLite will

Re: [sqlite] Insert performance in 3.6.11 vs. 3.5.5

On Wed, 25 Mar 2009 15:24:47 +0100, Günter Obiltschnig wrote: >Hi there, > >I have just upgraded SQLite in our application from 3.5.5 to 3.6.11 >(we are using the amalgamation), and I have noticed a sharp drop in >insert performance to more than half the speed

Re: [sqlite] Replacement for COPY

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of BOB_GOREN Sent: Tuesday, March 24, 2009 10:49 AM To: sqlite-users@sqlite.org Subject: [sqlite] Replacement for COPY Sqlite 2.8.13 supported statements like: COPY

[sqlite] sql select of varchar text with special chars

Hello all,   I've a table in oracle that contains fields of type varchar2. In these fields are TCL scripts that contain backslash chars and brackets.   Now, I've generated an SQL file from the Oracle table data that contains SQL insert statements. I then use sqlite .read to read in the entire

[sqlite] Documentation on SQLite indirectBLOB?

The Open Source project BitPim uses SQLite. I'm trying to examine the database BitPim creates. At http://www.sqlite.org/download.html I found sqlite-3_6_11.zip, which is a pre-compiled Windows command-line SQL interface. I ran: sqlite3 bitpim.db then typed: .dump and saved the

Re: [sqlite] Documentation on SQLite indirectBLOB?

Hi Mark, There's a good reason for your difficulty -- Sqlite uses dynamic typing: http://www.sqlite.org/datatype3.html As far as I know, the term "IndirectBlob" is not defined within sqlite and is likely a term from the BitPim developers. Sqlite allows one to use most anything as a type --

[sqlite] Sqlite3 crashes when using the where command

I am trying to run sqlite3 on Solaris 8. I have managed to compile it- and install it. Basic read and write to a database works fine. However when I use the where command or the delete command it crashes on me and says bus error. It then does a core dump. Here is my configure line:

Re: [sqlite] Sqlite3 crashes when using the where command

On 26/03/2009 9:48 AM, JoeT wrote: > I am trying to run sqlite3 on Solaris 8. I have managed to compile it- and > install it. Basic read and write to a database works fine. However when I > use the where command or the delete command it crashes on me and says bus > error. It then does a core

Re: [sqlite] Documentation on SQLite indirectBLOB?

I just read through http://www.sqlite.org/datatype3.html, and it's now starting to make sense to me. Wow! My mental model of what's going on under the covers just underwent a major readjustment. Thanks for pointing me at that page. Mark Griggs, Donald wrote: > Hi Mark, > > There's a

Re: [sqlite] Sqlite3 crashes when using the where command

On Wed, Mar 25, 2009 at 6:48 PM, John Machin wrote: > On 26/03/2009 9:48 AM, JoeT wrote: >> I am trying to run sqlite3 on Solaris 8.  I have managed to compile it- and >> install it.  Basic read and write to a database works fine.  However when I >> use the where command or

Re: [sqlite] gentle intro to including sqlite in another program

P Kishor wrote: > so, I have read the tutes on the website, but just wanted to confirm... > > I want to take baby steps to including sqlite's capabilities in my > modeling program. Do I just include sqlite3.h and compile my program > and magic will happen, or do I need to do something else? >

Re: [sqlite] gentle intro to including sqlite in another program

On Wed, Mar 25, 2009 at 7:58 PM, Dennis Cote wrote: > P Kishor wrote: >> >> so, I have read the tutes on the website, but just wanted to confirm... >> >> I want to take baby steps to including sqlite's capabilities in my >> modeling program. Do I just include sqlite3.h

Re: [sqlite] Documentation on SQLite indirectBLOB?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 MBR wrote: > The Open Source project BitPim uses SQLite. I wrote that code. The rationale is at http://bitpim.svn.sourceforge.net/viewvc/bitpim/trunk/bitpim/dev-doc/database.html > In the output > I found numerous references to columns of type

Re: [sqlite] gentle intro to including sqlite in another program

P Kishor wrote: > so, I have read the tutes on the website, but just wanted to confirm... > > I want to take baby steps to including sqlite's capabilities in my > modeling program. Do I just include sqlite3.h and compile my program > and magic will happen, or do I need to do something else? > >

Re: [sqlite] Sqlite3 crashes when using the where command

On Mar 26, 2009, at 5:48 AM, JoeT wrote: > > I am trying to run sqlite3 on Solaris 8. I have managed to compile > it- and > install it. Basic read and write to a database works fine. However > when I > use the where command or the delete command it crashes on me and > says bus > error.