[sqlite] index for OR clause

Hello, I would like to know if this is possible to use an index in the following case: select * from TEST where (a = '123' or a2='1234') and b = '456' and c='PP'; given the table: create table TEST ( a TEXT NOT NULL, a2 TEXT NOT NULL, b TEXT NOT NULL, c TEXT NOT NULL ); create index

[sqlite] index for OR clause

EST USING INDEX IDX_TEST_3 (a2=? AND b=? AND c=?) thank you again On Mon, Jul 27, 2015 at 8:05 PM, Richard Hipp wrote: > On 7/27/15, Sylvain Pointeau wrote: > > Hello, > > > > I would like to know if this is possible to use an index in the following > > case: &g

[sqlite] index for OR clause

Yes, having: create table TEST ( a TEXT NOT NULL, a2 TEXT NULL, b TEXT NOT NULL, c TEXT NOT NULL ); create index IDX_TEST_1 on TEST(c,b,a,a2); create index IDX_TEST_2 on TEST(c,b,a); create index IDX_TEST_3 on TEST(c,b,a2); sqlite> explain query plan select * from TEST where (a = '123' or

[sqlite] index for OR clause

On Mon, Jul 27, 2015 at 8:27 PM, R.Smith wrote: > > > On 2015-07-27 08:09 PM, Simon Slavin wrote: > >> On 27 Jul 2015, at 6:58pm, Sylvain Pointeau >> wrote: >> >> create table TEST ( >>> a TEXT NOT NULL, >>> a2 TEXT NOT NULL, >>> b

[sqlite] CSV excel import

I understood from the mailing list, that CSV is not a defined format, then let's propose another format, well defined, the Excel one (which is in my experience a format to is good every time I had to exchange CSV files). Then why don't you propose an import of CSV from Excel (or similar)?

[sqlite] CSV excel import

On Thu, Jul 30, 2015 at 8:07 PM, Richard Hipp wrote: > > Then why don't you propose an import of CSV from Excel (or similar)? > > csv(excel) > An Excel-to-SQLite converter utility sounds like it would be a great > open-source project. Why don't you start it up? > -- > D. Richard Hipp > drh

[sqlite] CSV excel import

On Thu, Jul 30, 2015 at 8:17 PM, Luuk wrote: > On 30-7-2015 20:07, Richard Hipp wrote: > >> On 7/30/15, Sylvain Pointeau wrote: >> >>> I understood from the mailing list, that CSV is not a defined format, >>> then >>> let's propose another format

[sqlite] CSV excel import

On Thu, Jul 30, 2015 at 8:32 PM, Bernardo Sulzbach < mafagafogigante at gmail.com> wrote: > > My point is that I have seen so many emails regarding this incorrect csv > import, that it would be so easy for us if it just simply works in the CLI > and delivered in standard in the sqlite3

[sqlite] CSV excel import

On Thu, Jul 30, 2015 at 8:43 PM, Adam Devita wrote: > Instead of trying to conform to MS-Excel's csv format, wouldn't it be > better to write an import from .xls (or .ods if that is an open > standard) directly? > > That way each cell's value can be bound to a position holder in a > query. No

[sqlite] CSV excel import

On Thu, Jul 30, 2015 at 8:44 PM, Peter Aronson wrote: > Actually there exists an open source tool that convert Excel data into > SQLite tables -- the ogr2ogr command line tool of OSGeo's GDAL library ( > http://www.gdal.org/). You do need a version of GDAL built with the > SQLite and XLSX

[sqlite] CSV excel import

Le jeudi 30 juillet 2015, Scott Doctor a ?crit : > > A trick that works great most of the time with ODS is when exporting to > CSV select the option to quote all fields. One problem with CSV is that > many exports quote strings but not numbers. If everything is quoted then it > is much simpler

[sqlite] CSV excel import

Le jeudi 30 juillet 2015, Simon Slavin a ?crit : > > On 30 Jul 2015, at 7:48pm, Sylvain Pointeau <javascript:;>> wrote: > > > really cool, but I would like to have a solution directly in the sqlite3 > > executable > > If you're talking about the SQLite she

[sqlite] CSV excel import

Le jeudi 30 juillet 2015, John McKown a ?crit : > On Thu, Jul 30, 2015 at 1:48 PM, Sylvain Pointeau < > sylvain.pointeau at gmail.com <javascript:;>> wrote: > > > On Thu, Jul 30, 2015 at 8:44 PM, Peter Aronson <javascript:;>> wrote: > > >

[sqlite] CSV excel import

> > > ?I am replying to your original message rather that later ones because I'm > curious about the CSV file which is giving you a problem. Using the sqlite3 > command on Linux Fedora 22 (64 bit), I get the following (transcript): > > $sqlite3 > SQLite version 3.8.10.2 2015-05-20 18:17:19 > Enter

[sqlite] CSV excel import

On Thu, Jul 30, 2015 at 9:00 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 07/30/2015 10:58 AM, Sylvain Pointeau wrote: > > is it possible? in a lot of cases, I cannot use sqlite (executable) > > because of the lack of a good CSV impor

[sqlite] CSV excel import

On Thu, Jul 30, 2015 at 10:52 PM, Simon Slavin wrote: > > On 30 Jul 2015, at 9:50pm, Sylvain Pointeau > wrote: > > > leading > > 0 are removed when opening a csv file by double clicking on it to open it > > in excel. > > This is documented behaviour in

[sqlite] CSV excel import

Le jeudi 30 juillet 2015, Simon Slavin a ?crit : > > On 30 Jul 2015, at 9:57pm, Sylvain Pointeau <javascript:;>> wrote: > > > no it does not work double clicking on the csv to open it in excel, I am > > 100% sure (I just tried again), you have to go through the

Re: [sqlite] Row Level Locking as in InnoDB

Hello, If I would have one wish, it would not be the row level locking but the merge syntax, so usefulf to update, insert or update in 1 command (no insert or replace is not an equivalent), and in general it would be good to implement the sql 2003. Just a wish. Best regards, Sylvain Le lundi

[sqlite] SQL 2003 in sqlite

Hello, The merge statement is really missing in sqlite... Is there any plan to integrate this SQL 2003 syntax in sqlite? Best regards, Sylvain ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQL 2003 in sqlite

Hi, > INSERT (OR REPLACE/IGNORE) INTO table1 SELECT * FROM table2 > Do you have specific requirements for the UPDATE features of MERGE ? the issue with "insert or replace" is that it will match on primary keys, additionally (I am not 100% sure) it deletes first the row to replace it. we cannot

Re: [sqlite] "Common Table Expression"

I agree with David, CTE is just wonderful, a big help to avoid re-typing many times the same sub-query and a performance improvement as well. Yes we can workaround it but it is ugly and leads to un-maintainable code. I am using it every days in my job and I can just tell that it has been proven to

Re: [sqlite] DELETE & INSERT vs. REPLACE

I second "Petite Abeille", the merge into (SQL 2003) would be more than useful. REPLACE should be avoided. On Wed, May 28, 2014 at 5:08 PM, Simon Slavin wrote: > > On 28 May 2014, at 3:55pm, Drago, William @ MWG - NARDAEAST > wrote: > > > Can

[sqlite] lemon - %wildcar

Hello, I would like to know if %wildcard is an undocumented feature on purpose, is this safe to use it? if yes, could it be added in the documentation? ps: I am pretty impressed by lemon, I am really having fun. Best regards, Sylvain ___ sqlite-users

Re: [sqlite] lemon - %wildcar

Hello, Le samedi 26 juillet 2014, Richard Hipp a écrit : > > Historical note: I wrote Lemon back in the 80s (on a Sun3, IIRC) You were a visionary, Lemon is probably the only viable option for a parser generator in C/C++ at this moment. because > the $1,$2,$3 notation of

Re: [sqlite] Variable values in Views

It is called parameterized view in sqlserver. Actually it is extremely useful in order to have a good reusability in the code. I was actually missing it in Oracle, although I found a workaround of using the pipelined functions. Unfortunately, it is missing in sqlite, as well as the merge

Re: [sqlite] completion of sql words

Hello, I just tried APSW on max os x, but how to get the auto-completion to work? it does not work for me... Best regards, Sylvain On Sat, Apr 9, 2011 at 11:50 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 04/09/2011 02:03 PM, Edzard

Re: [sqlite] C++ Sample Code

I wrote one wrapper, that can be compiled, like sqlite3, in your C++ program. It doesn't rely on any third library except sqlite3. The update of sqlite3 is just done by replacing the amalgamation files. https://gitorious.org/sylisa-dblite/sylisa-dblite It uses the syntax borrowed from soci++,

Re: [sqlite] problems on importing quoted csv files

I made one, as a command line tool. the announcement: http://spointeau.blogspot.com/2011/03/sylisa-csv2db-is-born.html the sources: https://gitorious.org/sylisa-csv2db/sylisa-csv2db Another option, you can also use the shell (in python) apsw http://apidoc.apsw.googlecode.com/hg/index.html

Re: [sqlite] SQLite and Java

> my program language is Java. And the www.sqlite.org not supply API for Java. What should I do? I think this one is the best http://code.google.com/p/sqlite-jdbc/ Best regards, Sylvain ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] importing CSV data on command-line?

> > I have got to stop working until 3:00am. Your suggestion points to what I > did not verify. The original CSV is much richer with double quoting some > values. The following shows that setting the separator as I was within the > shell does not do what I was expecting: > > I made one that I

Re: [sqlite] Very slow processing of some SELECT statements

Is it normal that fromuid of the table exits is STRING ? I think it should be TEXT to be surely processed as text and not float ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Very slow processing of some SELECT statements

On Tue, Oct 18, 2011 at 8:30 AM, Nick Gammon <n...@gammon.com.au> wrote: > > On 18/10/2011, at 4:46 PM, Sylvain Pointeau wrote: > > > Is it normal that fromuid of the table exits is STRING ? > > I think it should be TEXT to be surely processed as text and not float >

[sqlite] user defined function returning a result set

Hello, I think I have read on this mailing list that sqlite now has functions able to return rows. (but cannot find it anymore) I am interested about this new functionality. Would it be possible to see a very basic sample of it? Do you think we can implement a kind of CSV reader with this new

[sqlite] user defined function returning a result set

> > To do this, you'd have to create a virtual table that actually gets > instantiated per CSV file: > > CREATE VIRTUAL TABLE temp.file1 USING > csvFileReader('/path/to/my/file.csv'); > SELECT * FROM file1; > DROP TABLE file1; > > In the above, the xCreate method of the virtual

Re: [sqlite] SQLite and Qt

build your qt sqlite as a plugin then recompile this plugin with the version you want. http://doc.trolltech.com/4.6/sql-driver.html#qsqlite-for-sqlite-version-3-and-above best regards, Sylvain On Wed, Jun 9,

Re: [sqlite] SQLite and Qt

the lib, I thought I might ask before running down > that rat whole;) > > Sam > > On Wed, Jun 9, 2010 at 4:20 AM, Sylvain Pointeau > <sylvain.point...@gmail.com> wrote: > > > > build your qt sqlite as a plugin > > then recompile this plugin with the version

Re: [sqlite] Locking issue on NFS filesystem

> int sqlite3_open_v2( > const char *filename, /* Database filename (UTF-8) */ > sqlite3 **ppDb, /* OUT: SQLite db handle */ > int flags, /* Flags */ > const char *zVfs/* Name of VFS module to use */ > ); > > With the last argument "unix-dotfile". > > Does it

Re: [sqlite] SQLite and Qt

On Wed, Jun 16, 2010 at 3:42 PM, Sam Carleton > > The error was between the keyboard and the chair... Once the SQLite > DLL was moved into the Qt bin directory, all worked as expected. > > :-) > Thus the answer to my question would seem to be: Qt will simply use >

Re: [sqlite] Accessing an sqlite db from two different programs

absolutely no problem with sqlite. ensure you are doing smallest update as possible. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Accessing an sqlite db from two different programs

to not block all users with updates. On Tue, Jun 29, 2010 at 6:54 PM, Greg Burd <greg.b...@oracle.com> wrote: > Why "the smallest update possible"? > > -grge > > > -----Original Message- > > From: Sylvain Pointeau [mailto:sylvain.point...@gmail.com]

[sqlite] linux ubuntu 3.7.01 installs sqlite3 3.6.22

Hi, I downloaded, compiled and installed the sqlite3 3.7.01 from the sources (amalgamation). however I have the sqlite3 version 3.6.22 installed in /usr/local/bin when I do "make install" >.libs/sqlite3 --version 3.6.22 however something strange, it creates a sqlite3 on the folder (same level

Re: [sqlite] linux ubuntu 3.7.01 installs sqlite3 3.6.22

I made a small c program for testing the libs... #include #include int main() { printf("version %s\n",sqlite3_libversion()); return 0; } it returns 3.6.22 why do I compile and install a previous version? (is it linked to ubuntu?) best regards, Sylvain >

Re: [sqlite] linux ubuntu 3.7.01 installs sqlite3 3.6.22

I don't know if it is important, but I am running ubuntu 10.04 64 bit ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] linux ubuntu 3.7.01 installs sqlite3 3.6.22

I just installed the sources (not the amalgamation ones) and it works fine. what's wrong with the amalgamation package? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] linux ubuntu 3.7.01 installs sqlite3 3.6.22

... my fault, the programs are taking the lib from /usr/lib before /usr/local/lib it is not doing this way on my macosx, I am searching now how to specify to take first the /usr/local/lib when executing, even for /usr/local/bin/sqlite3 ___ sqlite-users

Re: [sqlite] linux ubuntu 3.7.01 installs sqlite3 3.6.22

I learned something today :-) I added /usr/local/lib to my /etc/ld.so.conf then run "sudo ldconfig" then I could use the latest sqlite3 in my /usr/local/ directory ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Compile SQlite 32 and 64 bits universal with ICU support on MacOSX

Hello, I met today a difficult situation where I wanted to have SQLite 32 and 64 bits with the ICU support, Unfortunately ICU does not support the universal 32 and 64 bits... but using lipo and a bit of manual work, we have it working! I wrote the detailed procedure on my blog

Re: [sqlite] WAL and multiple writers?

Are you sure that you are not keeping a transaction in the message sender? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)

Hi, I am on macosx sqlite 3.7.3 $ /usr/local/bin/sqlite3 test.db3 SQLite version 3.7.3 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .read ./testSchema.sql sqlite> .read ./TestValues.sql sqlite> .read ./TestQuery.sql Otterbourne Golf Course|Jane Doe|Assumed

Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)

I used: CFLAGS='-arch i686 -arch x86_64' LDFLAGS='-arch i686 -arch x86_64' ./configure --disable-dependency-tracking my compiler is: $ gcc --version i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5664) Copyright (C) 2007 Free Software Foundation, Inc.

Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)

stValues.sql sqlite> .read ./TestQuery.sql Assertion failed: (memIsValid([i])), function sqlite3VdbeExec, file sqlite3.c, line 64507. Abort trap On Sat, Dec 4, 2010 at 11:20 AM, Sylvain Pointeau < sylvain.point...@gmail.com> wrote: > I used: > CFLAGS='-arch i686 -arch x86_64' LDFLAG

Re: [sqlite] R: R: R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk

... and if you use the "unix-dotfile" as the VFS name in your open call. Does it work? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] R: R: R: R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk

What does it mean? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite server

and what about using a DCOM like technology to open a distant database? the sqlite API will stay the same but behind the scene, it will access your server using a DCOM like technology? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite server

Why not doing it with DCOM or Corba or what ever even the sockets? but hidden behind the same API of SQLite. The "real" sqlite lib will be on the server. is it called "remote procedure call"? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite server

.@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Sylvain Pointeau > Sent: Wednesday, December 22, 2010 7:51 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] SQLite server > > Why not doing it with DCOM or Corba or what ever even the so

Re: [sqlite] Propose minor incompatible API change

I agree with this change because it doesn't change all well written programs. It just tries to correct all incorrectly written ones, which is a good thing for the end-users. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite version 3.7.5

Any news on System.Data.SQLite.org ? It was a so great news! When are the releases planned? Best regards, Sylvain ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Exporting database to CSV file

The import has the big limitation to not be able to import the file when a field is on multiple lines.I don't know if this is the same for the export... Cheers, Sylvain On Tue, Jan 6, 2009 at 11:08 AM, MikeW wrote: > Jonathon writes: > > > > > Awesome.

[sqlite] having the Top N for each group

Hello all, I am wondering if we have a method faster then the INNER JOIN which can be very slow in case of large number of rows, which is my case. I was thinking of a UDF that increment a number if the concatenation of the key column (or group columns) is the same, means: select col1, col2,

Re: [sqlite] having the Top N for each group

s.product > from period > join sales on sales.rowid in ( >select rowid >from sales >where sales.period = period.period >order by sales.qty desc >limit 3); > > -- Edzard Pasma > > > --- sylvain.point...@gmail.com wrote: > > From: Sylvain Point

Re: [sqlite] having the Top N for each group

f you wish I may look at the 'infinite' > query, just mail it. Otherwise we at least have proved SQLite's incredible > speed in doing UPDATE :) > > Edzard Pasma > > --- sylvain.point...@gmail.com wrote: > > From: Sylvain Pointeau <sylvain.point...@gmail.com> > To: edz...@volc

[sqlite] MacOSX version 3.6.11 vs 3.6.6.2

Hi, Waooo I observed my db running from 11 min to 5 min that's really great, many thanks, Cheers, Sylvain ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] import a CSV-File

from my experience, sed will read line by line, which is not good for the CSV file.(one field can be on multiple lines). why sqlite is not enhanced to handle fully the csv file format? Cheers, Sylvain On Fri, Mar 6, 2009 at 11:33 PM, John Machin wrote: > On 7/03/2009

Re: [sqlite] SELECT queries and NULL value parameters

you can also use ifnull(myvar1,'') = ifnull(myvar2,'') or something in the same way. I used it for avoiding creating 2 queries for each cases. Cheers, Sylvain On Wed, Mar 11, 2009 at 4:14 PM, Jim Wilcoxson wrote: > I used the Solid database for many years, since they came

Re: [sqlite] select with a like containing a line feed

re-hi, but how do we do if we are on unix and there is some CR on those field? I cannot insert CR in my statement (only line feed) do you have any suggestion? Cheers, Sylvain On Fri, Apr 3, 2009 at 2:15 PM, Sylvain Pointeau <sylvain.point...@gmail.com > wrote: > Hi, > thank y

Re: [sqlite] select with a like containing a line feed

it is really perfect,thank you so much On Fri, Apr 3, 2009 at 2:55 PM, Simon Davies < simon.james.dav...@googlemail.com> wrote: > 2009/4/3 Sylvain Pointeau <sylvain.point...@gmail.com>: > > re-hi, > > but how do we do if we are on unix and there is some CR on those fi

Re: [sqlite] Using SQLite3 on On-Time RTOS ...

.. or you can pay for a support ? On Mon, Apr 27, 2009 at 3:31 PM, Virgilio Alexandre Fornazin < virgilioforna...@gmail.com> wrote: > Maybe RTOS kernel does not implement Wide-Char functions... > > Windows VFS must guard them with a SQLITE_WINDOWS_NO_UNICODE > macro or something like that at

Re: [sqlite] SQlite performance on multi process env

the hard disk is shared so it is a critical resource,as well as 100 processes doesn't seem realistic on a single processor, dual core or not. so I can understand your result, I find even them not too bad ... Cheers, Sylvain On Thu, May 28, 2009 at 12:38 AM, zhrahman

[sqlite] sqlite programmed in C++

Hello, I would like to know if someone already though about to introduce C++ in SQLite? I just think about a minimal subset of C++ that will not make any performance penalty (like C with classes) is it a performance issue? is it a deployment/compiler issue? or any issue? Please don't make any

Re: [sqlite] sqlite programmed in C++

son Process Management | 5650 Brittmoore | Houston | TX | 77041 | > USA > T +1 713 839 9656 | F +1 713 827 3807 > > > logan.rat...@emerson.com-original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Sylvain Pointeau

Re: [sqlite] sqlite programmed in C++

? Cheers, Sylvain On Tue, Jun 2, 2009 at 6:16 PM, John Stanton <jo...@viacognis.com> wrote: > Why wuld you want to do such a thing? > > Sylvain Pointeau wrote: > > Hello, > > I would like to know if someone already though about to introduce C++ in > > SQLite?

Re: [sqlite] sqlite programmed in C++

ct and effcient. > Producing Sqlite in well written and documented ANSI C was a very sound > decision. > > If you want to incorporate Sqlite in a C++ environment use C++ wrappers > for the API calls. > > Sylvain Pointeau wrote: > > ... because I experienced C++ to be easier wit

Re: [sqlite] sqlite programmed in C++

yes true, case closed then ! Many thanks for all of your answers. Cheers, Sylvain On Wed, Jun 3, 2009 at 12:17 PM, P Kishor <punk.k...@gmail.com> wrote: > On Wed, Jun 3, 2009 at 5:02 AM, Hamish Allan <ham...@gmail.com> wrote: > > On Wed, Jun 3, 2009 at 8:59

Re: [sqlite] sqlite programmed in C++

if I had to do a library, I would probably choose C++,at least the subset C with classes. I will then export the main function as "C" many libraries are done like that now. for example http://www.ode.org/ is mostly written in C++ but has an interface in C I also use Qt because it has a clean

Re: [sqlite] sqlite programmed in C++ ...

Hi, I also like C very much even if I prefer C++ Please note that I was asking to introduce C++ not to re-write (which would be a total non-sense) I just repeat that I use sqlite every days, and I find it awesome, I love it. C or C++? at the end : who cares? I strongly believe that the persons

Re: [sqlite] Updating a database by email

what about to use a unique identifier for each row?but a unique identifier like UUID in sqlserver or Quuid in Qt? as it is unique over the world it could be enough? at the worst case, prefix an id by the name of your machine if you have only 2 machines. then merge the records together? cheers,

Re: [sqlite] Updating a database by email

... sorry, I forgot to mention to have an updatedBy column also having the computer name as a distinct valuefor knowing who updated the last one (and eventually an updatedTime to know when) Cheers, Sylvain On Sun, Jul 12, 2009 at 5:06 PM, Sylvain Pointeau < sylvain.point...@gmail.com>

[sqlite] index for a group by

hello, I have a table T (a,b,c,d,t) where c is a value a,b,c some dimensions and t the time I need to make a subset with a "group by" like select a,b,c,sum(d) from T where t>x1 and thttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] index for a group by

and cause the query to execute faster (of course if by > > conditions t>x1 and t > table). > > > >> also do you know by chance how to speed up the index creation? > > > > There's no way to do that. SQLite have to scan the whole table, read > >

Re: [sqlite] index for a group by

if your "book" contains all lines (a,b,c,t,d)and you create an index on (a,b,c,t) then your index is as fat as your book, isn't it? cheers, Sylvain On Wed, Oct 21, 2009 at 11:52 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 21 Oct 2009, at 9:19pm, Sylvain Point

Re: [sqlite] How to make LIKE searches case-sensitive

http://www.sqlite.org/pragma.html#pragma_case_sensitive_like On Sat, Oct 31, 2009 at 4:27 PM, P Kishor wrote: > On Sat, Oct 31, 2009 at 10:21 AM, Ted Rolle wrote: > > I'd like to make LIKE '%Blah%/ only find 'Blah', and not 'blah'. > > >

Re: [sqlite] index optimal?

Hi, many thanks for your answer, I just think that it could be useful to know if an index is optimal or not, kind of a tool that could give you the best index for speed up a query. Many thanks, Sylvain On Tue, Nov 3, 2009 at 2:52 PM, Griggs, Donald wrote: > Hi

Re: [sqlite] index optimal?

be happy to have such a tool, but if no one have the need, then I will stay with my brain ... Thank you very much for your help & answer, Best regards, Sylvain On Tue, Nov 3, 2009 at 9:16 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 3 Nov 2009, at 7:33pm, Sylvain Pointeau wro

[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] 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 <sylvain.point...@gmail.com>: > > Hi, > >

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 <pechni...@mobigroup.ru>wrote: > Hello! > > On Thursday 10 December 2009

Re: [sqlite] compiling Sqlite with ICU

te3.o _icuLikeCompare in sqlite3.o _icuLikeCompare in sqlite3.o "_ucol_close_4_2", referenced from: On Thu, Dec 10, 2009 at 3:55 PM, Sylvain Pointeau < sylvain.point...@gmail.com> wrote: > ... I don't have this line in my Makefile.in ... > Are you sure there is

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, Sy

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&

Re: [sqlite] compiling Sqlite with ICU

regards, Sylvain On Thu, Dec 10, 2009 at 9:30 PM, Roger Binns <rog...@rogerbinns.com> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Sylvain Pointeau wrote: > > just one last thing: > > -lpthread -lm -L/usr/local/lib -licui18n -licuuc -licudata -lp

[sqlite] sqlite ICU libs with otool

Hi, I compiled sqlite 3.6.21 (ICU enabled) + icu 4.2.1 I installed both in /usr/local/lib I also compiled the sqlite plugin of Qt linked with libsqlite3 located in /usr/local/lib the problem is when I want a single bundle with no external dependency. when I use macdeployqt, I have the following

Re: [sqlite] sqlite ICU libs with otool

quot;/usr/local/lib/libicuuc.42.dylib" libsqlite3.dylib sudo install_name_tool -change "../lib/libicudata.42.1.dylib" "/usr/local/lib/libicudata.42.1.dylib" libsqlite3.dylib and it works now. I don't know about those lib reference, do you think the problem co

[sqlite] ICU collation

Hi, please could someone help me to understand ICU inside SQLite? I have some text fields for the German language. I load the collation with : SELECT icu_load_collation('de_DE', 'GERMAN'); the sort order is good, means it sorts correctly the ä,ö etc but it doesn't try to select: "ä" if I use

Re: [sqlite] ICU collation

but in german, "*schön*<http://www.dict.cc/deutsch-englisch/sch%C3%B6n.html>" can be written "schoen" right? On Sat, Dec 19, 2009 at 10:16 PM, Igor Tandetnik <itandet...@mvps.org>wrote: > Sylvain Pointeau wrote: > > please could someone help me to und

Re: [sqlite] ICU collation

ning german and my teacher also confirmed that we could use "oe" instead of "ö" even if we don't use it... Are you sure that ICU does not cover those cases? Best regards, Sylvain On Sun, Dec 20, 2009 at 6:46 AM, Simon Slavin <slav...@bigfraud.org> wrote: &

Re: [sqlite] ICU collation

I am pretty sure that ICU should handle those cases. Please note that I tried "=" and "like" for that without any luck. On Sun, Dec 20, 2009 at 7:37 PM, Wolfgang Enzinger wrote: > Am Sun, 20 Dec 2009 19:24:58 +0100 schrieb Wolfgang Enzinger: > > > I'm pretty sure they don't

Re: [sqlite] ICU collation

it is written here http://userguide.icu-project.org/collation <http://userguide.icu-project.org/collation> "A letter can be treated as if it were two letters. For example, in traditional German "ä" is compared as if it were "ae"." On Mon, Dec 21

Re: [sqlite] ICU collation

How does sqlite handle ICU, I don't understand? is it used only for the sort order? Best regards, Sylvain On Mon, Dec 21, 2009 at 12:41 AM, Sylvain Pointeau < sylvain.point...@gmail.com> wrote: > it is written here > http://userguide.icu-project.org/collation > <http://usergui

Re: [sqlite] ICU collation

Hi, thanks for your help, I also found that L1 = Base Letters worked as I expected ... *Collated* 09: fluasse 36 42 54 2c 50 50 34 00 06: flüße 07: flüsse 08: fluesse 36 42 54 34 50 50 34 00 02: Fluße 03: Flusse 04: flusse 05: fluße 36 42 54 50 50 34 00 01: Fuße 36 54 50 50 34 00 How is

  1   2   >