Re: [sqlite] Version 3.8.1 beta

On 10/2/2013 03:34, Jan Nijtmans wrote: This patch appears to work Confirmed. Thanks! (but maybe -no-undefined should come in through @LDFLAGS@ No. The flag is for libtool, not for gcc, which is the program libtool calls on to do the linking on Cygwin. It will cause the link step to

[sqlite] Regarding adding a new clause to the SELECT staement

Hello, I am a final year undergraduate student from IIT Kanpur, India. I am doing my B.Tech project under the guidance of Prof. Arnab Bhattacharya in which I have to add Skyline clause to the Select statement. But seeing the large code repository in 'sqlite3.c' I am not sure from where should I

[sqlite] Major performance difference when joining on FTS4 table's docid column versus custom id column

In our application, we have an FTS4 table 'tmexpandedtext' that contains all our text strings. Other tables have columns like fullname_id, path_id and filename_id that point to strings in this table by their docid. The issue we're seeing is that joining on the docid column seems really slow

Re: [sqlite] Regarding adding a new clause to the SELECT staement

On 2 Oct 2013, at 5:54pm, vaibh...@iitk.ac.in wrote: I am a final year undergraduate student from IIT Kanpur, India. I am doing my B.Tech project under the guidance of Prof. Arnab Bhattacharya in which I have to add Skyline clause to the Select statement. But seeing the large code

[sqlite] Revisiting Collation Advice

For those that were interested in the discussion about iOS NOCASE collation http://sqlite.1065341.n5.nabble.com/Collation-advice-td70668.html here are some news. First of all we made the original algorithm more safe. The most important step was to limit the character set where ascii comparison

Re: [sqlite] Major performance difference when joining on FTS4 table's docid column versus custom id column

Per Vognsen wrote: Am I wrong to think that joining on docid should be as fast as joining on indexed integer columns in other tables? Looking up a record by docid is faster than non-FTS lookups on other columns, but the virtual table implementation still has to go through a separate query to

[sqlite] How to run sqlite just in memory - pragma cache_size issue

Hi, I use sqlite (v3.7.9) in a Linuxmint environment to act as gateway for, on one side, a dozen of users give control request via TCPIP, Bluetooth HTTP and Linux Pipe. On the other side, via RS232 and Zigbee to control some 30 devices according to the request. All activities, user requests and

[sqlite] SQLite4 release date and how to compile on windows platform

Does anyone know if any release date has been announced for SQLite4? Secondly where can I find the instructions to compile SQLite4 on windows platform. Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org