Re: [sqlite] compiling Sqlite with ICU

Hi, thank you very much, I enjoy so much sqlite with ICU, I even installed the latest version of readline to enjoy characters like öäü and with the ICU collation the sort order is right with those characters. sqlite is really splendid! Thank you so much for having made this software. Best

Re: [sqlite] Using pivot table

Walter wrote: > > I have the following tables > > > > CREATE TABLE data( > > id INTEGER PRIMARY KEY NOT NULL, > > name TEXT DEFAULT '', > > titleTEXT DEFAULT '', > > > > ) > > > > > > CREATE TABLE pivot( > > id INTEGER PRIMARY KEY

Re: [sqlite] .importing file into a BLOB

>Something like (one line, wrapped by email): > >echo "INSERT INTO t1 (id,pic) VALUES (1,X'$(od -A n -t x1 >picture.gif | tr -d '\r\n\t\ ')')" | sqlite3 mydb > >(The od utility may be smarter than that, optimization left >to the OP) Looks good, you know better than I do. Just checked: od and

Re: [sqlite] compiling Sqlite with ICU

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sylvain Pointeau wrote: > just one last thing: > -lpthread -lm -L/usr/local/lib -licui18n -licuuc -licudata -lpthread -lm > > > could it be annoying for sqlite to be linked against pthread? Unless you compiled SQLite with SQLITE_THREADSAFE=0

Re: [sqlite] .importing file into a BLOB

On Thu, 10 Dec 2009 04:57:58 +0100, Jean-Christophe Deschamps wrote: > is to >use a command-line tool or combination thereof that will open your >binary file, read each byte in turn and output its hex value in plain >ASCII characters, until end of file. Something like (one

Re: [sqlite] compiling Sqlite with ICU

super thank you! :-D just one last thing: -lpthread -lm -L/usr/local/lib -licui18n -licuuc -licudata -lpthread -lm could it be annoying for sqlite to be linked against pthread? Many thanks, Sylvain On Thu, Dec 10, 2009 at 7:45 PM, Roger Binns wrote: > -BEGIN

Re: [sqlite] undefined reference to sqlite3_mutex_held

On Thu, Dec 10, 2009 at 10:18 AM, Daniel Mierswa wrote: > My concolusion is that the TB folks shouldn't assume that the system > sqlite library was built with debugging symbols or provide a mechanism > to opt out said function call with an easy switch/compiler flag. > Well,

Re: [sqlite] compiling Sqlite with ICU

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sylvain Pointeau wrote: > seems I found: > > ./configure CFLAGS="-DSQLITE_ENABLE_ICU" LDFLAGS="-L/usr/local/lib" > LIBS="-licudata -licui18n -licuio -licule -liculx -licutu -licuuc" > > is there any way to not list all the icu libs? Use icu-config.

Re: [sqlite] BUG: The FTS3 is broken in reliase 3.6.21

On Dec 10, 2009, at 1:13 PM, Alexey Pechnikov wrote: > Hello! > > In new relise doesn't some queries. The simplest non-working query > is like to: > > sqlite> select 1 from file_text where rowid=1 and file_text match > 'document'; > Error: SQL logic error or missing database > > sqlite>

Re: [sqlite] undefined reference to sqlite3_mutex_held

On 10.12.2009 07:44, Roger Binns wrote: > sqlite3.h is not generated from a .in template. Are you volunteering to do > that and become the maintainer of it? Nah I was merely wondering how/if it could be achieved at all. > Secondly your solution would only work for autotools which not everyone

Re: [sqlite] compiling Sqlite with ICU

seems I found: ./configure CFLAGS="-DSQLITE_ENABLE_ICU" LDFLAGS="-L/usr/local/lib" LIBS="-licudata -licui18n -licuio -licule -liculx -licutu -licuuc" is there any way to not list all the icu libs? Best regards, Sylvain On Thu, Dec 10, 2009 at 4:09 PM, Sylvain Pointeau <

Re: [sqlite] compiling Sqlite with ICU

./configure CFLAGS="-DSQLITE_ENABLE_ICU but after I have a linker problem: /bin/sh ./libtool --tag=CC --mode=link gcc -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_ICU -I/usr/local/include -L/usr/local/lib -o libsqlite3.la-rpath /usr/local/lib -no-undefined -version-info 8:6:8 sqlite3.lo gcc

Re: [sqlite] compiling Sqlite with ICU

... I don't have this line in my Makefile.in ... Are you sure there is not an option to put in the "configure" command? Best regards, Sylvain On Thu, Dec 10, 2009 at 3:44 PM, Alexey Pechnikov wrote: > Hello! > > On Thursday 10 December 2009 17:40:24 Sylvain Pointeau

Re: [sqlite] compiling Sqlite with ICU

Hello! On Thursday 10 December 2009 17:40:24 Sylvain Pointeau wrote: > Thank you very much. > How should I do exactly with configure to enable this define ? You can simple replace the string TCC += -D_HAVE_SQLITE_CONFIG_H to TCC += -D_HAVE_SQLITE_CONFIG_H -DSQLITE_ENABLE_ICU in the Makefine.in

Re: [sqlite] compiling Sqlite with ICU

Hi, Thank you very much. How should I do exactly with configure to enable this define ? Cheers, Sylvain On Thu, Dec 10, 2009 at 11:31 AM, Simon Davies < simon.james.dav...@googlemail.com> wrote: > 2009/12/10 Sylvain Pointeau : > > Hi, > > > > I would like to use ICU

Re: [sqlite] iPhone App close database

Simon, Thanks a lot. This is just what I needed. Greg From: Simon Slavin To: General Discussion of SQLite Database Sent: Wed, December 9, 2009 4:34:09 PM Subject: Re: [sqlite] iPhone App close database On 9 Dec

Re: [sqlite] rowid of the current insert

You should keep your id and the imdbid in separate columns, because you can then insert a title even if IMDB does not have it yet. id INTEGER PRIMARY KEY imdbid integer// you should allow this column to be null title not null, et cetera Regards Tim Romano Yuzem wrote: > CREATE TABLE

Re: [sqlite] rowid of the current insert

2009/12/10 Yuzem : > > CREATE TABLE movies(id integer,title text,unique(id)) > > Generally I have an unique id from imdb but some times the movie isn't > available. > I understand that there is a column called rowid that is the primary key. > I would like to insert the rowid

[sqlite] rowid of the current insert

CREATE TABLE movies(id integer,title text,unique(id)) Generally I have an unique id from imdb but some times the movie isn't available. I understand that there is a column called rowid that is the primary key. I would like to insert the rowid on the id column when I don't have an id for the

Re: [sqlite] Index Problem

Hi, One more information: I am using COLLATE NoCase. On Thu, Dec 10, 2009 at 4:19 PM, Harish Dixit wrote: > Hi Friends, > > I ran into a big problem of creating indexes taking a long time. When i > create index on multiple colomns then its taking a long time on few >

[sqlite] Index Problem

Hi Friends, I ran into a big problem of creating indexes taking a long time. When i create index on multiple colomns then its taking a long time on few machines. Those are windows Vista machines. I am using following command: CREATE INDEX IF NOT EXISTS New_Index (name,title) I tried with empty

Re: [sqlite] compiling Sqlite with ICU

2009/12/10 Sylvain Pointeau : > Hi, > > I would like to use ICU with sqlite, I am on mac os x 10.6.2 > How should I do? I installed ICU but sqlite3 seems to not check ICU when > compiling. > I would like to use ICU via the sqlite shell. > > Please could someone explain

[sqlite] compiling Sqlite with ICU

Hi, I would like to use ICU with sqlite, I am on mac os x 10.6.2 How should I do? I installed ICU but sqlite3 seems to not check ICU when compiling. I would like to use ICU via the sqlite shell. Please could someone explain me how to use ICU with sqlite3 ? Cheers, Sylvain

Re: [sqlite] SQLite bug report - large databases only - 'database or disk is full'

On Mon, Dec 7, 2009 at 10:21 PM, wrote: > > SQLite bug report > > Summary: > -- > > error message: > >       Error: near line 2: database or disk is full > > It happens with plenty of disk space available and with 'unlimited' database > size. > It does not happen on

Re: [sqlite] Implementing Regular Expression Support...?

>-Message d'origine- >De : sqlite-users-boun...@sqlite.org >[mailto:sqlite-users-boun...@sqlite.org] De la part de J. King >Envoyé : mardi, 8. décembre 2009 18:24 >À : General Discussion of SQLite Database >Objet : Re: [sqlite] Implementing Regular Expression Support...? > >On Tue, 08