[sqlite] Adding data with periods

2008-12-14 Thread aditya siram
Hi all, I'm having trouble adding data with period characters in it. I tries to escape the period with a `'` but that didn' t seem to work. Here is an example interaction: sqlite> create table test_table ("Contents" varchar); sqlite> insert into test_table "hello . world"; SQL error: near ""hello

Re: [sqlite] Adding data with periods

2008-12-14 Thread aditya siram
mit sensitivity to data content. > > aditya siram wrote: > > Hi all, > > I'm having trouble adding data with period characters in it. I tries to > > escape the period with a `'` but that didn' t seem to work. Here is an > > example interaction: > > > >

[sqlite] Wildcard searches, partial matches

2008-12-15 Thread aditya siram
Hi all, I am trying to implement an autocompleter with a sqlite backend. Is there a way to search the database using wildcards/regexps's without reading the entire search space into memory? For example given the rows: 'hello world' 'goodbye world' a query approximately like "* world" should

Re: [sqlite] Wildcard searches, partial matches

2008-12-15 Thread aditya siram
Cool! -deech On Mon, Dec 15, 2008 at 12:12 PM, P Kishor <punk.k...@gmail.com> wrote: > On 12/15/08, aditya siram <aditya.si...@gmail.com> wrote: > > Hi all, > > I am trying to implement an autocompleter with a sqlite backend. Is > there a > > way to

[sqlite] Inserting an image file?

2009-01-02 Thread aditya siram
Hi all, How do I insert an image file into sqlite table? Can I just use a path-specifier? For instance, create table ("name" varchar, "data" blob); insert into table ("someBlob", "./blob.jpg"); thanks, deech ___ sqlite-users mailing list

Re: [sqlite] Exporting database to CSV file

2009-01-05 Thread aditya siram
Open the sqlite database using: > sqlite3 database.sqlite >> .mode csv >> .output yourfilename >> your-sql -query -deech On Mon, Jan 5, 2009 at 4:21 PM, Jonathon wrote: > Hello all, > > I am interested in exporting a particular table to a CSV file. I've > browsed >

Re: [sqlite] selecting the top 3 in a group

2009-01-07 Thread aditya siram
Hi Robert, SQL has a LIMIT keyword. I have used it to take the top 'x' entries of a large table , so for example: SELECT * from table LIMIT 20 You should be able to use it in your query like so: select div, team, max(wins) from teams group by div limit 5; -deech On Thu, Jan 8, 2009 at 12:06 AM,

[sqlite] Extraction SQL query from a sqlite3_stmt

2009-02-04 Thread aditya siram
Hi all, Once a sqlite3_stmt has been prepared and variables bound, is there some way of extracting the SQL query? I have a query that runs fine on command line and if I prepare and run it without variables. So something in the way I am binding the variables is returns zero rows. I would like to

[sqlite] Accent Insensitive search

2009-03-24 Thread aditya siram
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". Thanks ... -deech ___ sqlite-users mailing list sqlite-users@sqlite.org

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

2009-03-25 Thread aditya siram
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