Re: [sqlite] Proximity ranking with FTS

Yeah I had thought about using the byte distance between words but you get these instances: [Example A] |word1|10charword|word2| [Example B] |word1|3charword|4charword|3charword|word2| By using byte distances, both of these score the same, where Example A should score more highly. But it would

Re: [sqlite] Proximity ranking with FTS

This info is not provided by the API (or I missed it). I required this for a ranking that considers both the distance of N matches to each other, and the offset of those matches to the beginning of a text. I worked around this by giving a boost for the byte distance of the words (taking into accoun

Re: [sqlite] Proximity ranking with FTS

Ok so I have found the following guides: http://www.sqlite.org/privatebranch.html http://www.sqlite.org/src/doc/trunk/README.md So as far as creating a private branch 'the proper way' this should be sufficient but as far as getting the token positions for FTS MATCH results any advice on the top

[sqlite] Proximity ranking with FTS

I know that sqlite FTS provides proximity operators with NEAR and I also know that the querying tokenizer section says you can get a token position (http://www.sqlite.org/fts3.html#section_8_2). Although when using the offsets() function in FTS you get the byte position as opposed to the token pos

Re: [sqlite] SQLite legacy licenses

On Mon, Jun 16, 2014 at 5:44 PM, Richard Hipp wrote: > On Mon, Jun 16, 2014 at 7:01 PM, Scott Robison > wrote: > > > In a discussion with my manager today, he inquired if SQLite has always > > been public domain. I said I thought at least all SQLite 3 releases have > > been, but was not sure abo

Re: [sqlite] Unicode61 Tokenizer

On 16 Jun 2014, at 6:07am, Josh Wilson wrote: > Each major release (and occasionally minor) we review third party libraries > and what improvements have been released since we last looked. Heh. Unicode 7.0 is out today. And you thought you were up to date. Heh.

Re: [sqlite] SQLite legacy licenses

On Mon, Jun 16, 2014 at 7:01 PM, Scott Robison wrote: > In a discussion with my manager today, he inquired if SQLite has always > been public domain. I said I thought at least all SQLite 3 releases have > been, but was not sure about further back. He was also (pleasantly) > surprised to learn abo

[sqlite] SQLite legacy licenses

In a discussion with my manager today, he inquired if SQLite has always been public domain. I said I thought at least all SQLite 3 releases have been, but was not sure about further back. He was also (pleasantly) surprised to learn about the public domain dedication agreement that must be signed be

Re: [sqlite] importing CSV with a random empty line at the end

Thanks for the report. Fixed on trunk, here: https://www.sqlite.org/src/info/fc918f7d33 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Linux sqlite3 executable return value - what does it return?

On 16 Jun 2014, at 9:03pm, c...@isbd.net wrote: > > Remember - I said I'm doing an INSERT, either it will insert the > intended data or there will be an error. But there are two types of error: the INSERT command may turn out to be invalid (accidentally including a quote character or an unexpec

Re: [sqlite] Linux sqlite3 executable return value - what does it return?

On Mon, Jun 16, 2014 at 10:03 PM, wrote: > Remember - I said I'm doing an INSERT, either it will insert the > intended data or there will be an error. > If it fails because of a syntax error then the shell exits with non-0. Presumably (based on a quick scan of the code) it does the same for any

Re: [sqlite] Linux sqlite3 executable return value - what does it return?

Stephan Beal wrote: > On Mon, Jun 16, 2014 at 5:37 PM, wrote: > > > Does the return value contain anything that will tell me if the SQL > > worked or not? > > > > ... > set_table_name(&data, 0); > if( data.db ){ > sqlite3_close(data.db); > } > sqlite3_free(data.zFreeOnClose); > re

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.93.0 have begun...

If you have any issues with the current code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/";) prior to this coming Friday, June 20th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing list

Re: [sqlite] Linux sqlite3 executable return value - what does it return?

On Mon, Jun 16, 2014 at 5:37 PM, wrote: > Does the return value contain anything that will tell me if the SQL > worked or not? > ... set_table_name(&data, 0); if( data.db ){ sqlite3_close(data.db); } sqlite3_free(data.zFreeOnClose); return rc; } it returns the result code of the l

[sqlite] SQLITE_PROTOCOL errors

On 06/06/2014 11:37 AM, Török Edwin wrote: > On 05/27/2014 01:49 PM, Török Edwin wrote: >> On 05/27/2014 01:40 PM, Richard Hipp wrote: >>> If you are getting PROTOCOL errors, then the thing to do is to describe the >>> circumstances under which the errors occur so that we can begin to try to >>> un

Re: [sqlite] Creating a 'SQL text' Backup of a SQlite database with the mere sqlite.dll tool (and a Python 3)

Hi Roger, Why is APSW not findable on the Pypi infrastructure ? It should be the place where a newcomer would look for it. I just published my work as "sqlite_bro" (pip install sqlite_bro), and it doesn't seem to be too complex. (just one full day lost to figure it out, in my case) Regards

[sqlite] Linux sqlite3 executable return value - what does it return?

If I execute some SQL by putting it after 'sqlite3' on the command line as follows:- sqlite3 mydata.db "SELECT * from mytable" Does the return value contain anything that will tell me if the SQL worked or not? If it doesn't then what's the easiest way for a script to tell if some SQL execute

Re: [sqlite] Understanding Sqlite

On Mon, Jun 16, 2014 at 9:57 AM, jose isaias cabrera wrote: > > Designing the DBs and tables would be the essencial part of the whole > project. After that, the rest is easy. > "Representation is the essence of computer programming" (Fred Brooks, _The Mythical Man-Month_, 1972) -- D. Richar

Re: [sqlite] Understanding Sqlite

"dd" wrote... Dear Author/All, There are many things needs to understand from sqlite apart from RDBMS concepts. For example, pragmas, database connection in different scenarios, IPC, virtual tables..etc. Do sqlite team has any plan to start online university for training and issuing

Re: [sqlite] slowish R*Tree performance

Hi, I am just a user of binary Sqlite. So, I do not know how much of custom Sqlite tricks can be made with a copy of sqlite source code. However, and if I understood well the problem is like this: 1 - There a data type named IPV6 Address. 2 - there is a table where this data type must be in. (

Re: [sqlite] Performance regression with multiple lower bound tests

On 16 Jun 2014, at 1:10pm, Richard Hipp wrote: > > That's not quite the same thing. "x BETWEEN ?1 AND ?2" means "x>=?1 AND > x<=?2". > > Now, if x is the INTEGER PRIMARY KEY (and thus is guaranteed to be an > integer) you could say: > >WHERE rowid BETWEEN max(?1,?3+1) AND ?2 I stand corr

Re: [sqlite] System.Data.SQLite.dll failing on WIndows 7

What .NET framework is Appgio Sync built with ? Issue is likely that you have SQLIte built against .NET 4.5 whereas you AppGio Sync is built with .NET 4.0 which cannot load a .NET 4.5 assembly. I suggest you install one of the .NET 4.0 versions of SQLite. - Akintoye From: jwcalv...@rogers.com

Re: [sqlite] Performance regression with multiple lower bound tests

On Mon, Jun 16, 2014 at 7:46 AM, Simon Slavin wrote: > > > On 16 Jun 2014, at 12:36pm, Richard Hipp wrote: > > > > Instead of > > > > ... WHERE x BETWEEN ?1 AND ?2 AND x>?3 > > > > Consider using > > > > ... WHERE x BETWEEN max(?1,?3) AND ?2 AND x>?3 > > I suspect Dr Hipp means > > > ...

Re: [sqlite] Performance regression with multiple lower bound tests

On 16/06/2014, at 11:36 pm, Richard Hipp wrote: > On Mon, Jun 16, 2014 at 5:07 AM, David Empson wrote: > >> It appears SQLite 3.8.1 removed an optimisation where earlier versions of >> the query planner were checking for two or more "lower bound" comparisons >> against the key for an index, an

Re: [sqlite] Performance regression with multiple lower bound tests

> On 16 Jun 2014, at 12:36pm, Richard Hipp wrote: > > Instead of > > ... WHERE x BETWEEN ?1 AND ?2 AND x>?3 > > Consider using > > ... WHERE x BETWEEN max(?1,?3) AND ?2 AND x>?3 I suspect Dr Hipp means > ... WHERE x BETWEEN max(?1,?3) AND ?2 Simon. _

Re: [sqlite] slowish R*Tree performance

On 16 Jun 2014, at 10:47am, Carlos Ferreira wrote: > What is the original problem that is causing slow performance in the SQlite > R-Tree implementation? Read earlier posts to this thread. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Performance regression with multiple lower bound tests

On Mon, Jun 16, 2014 at 5:07 AM, David Empson wrote: > It appears SQLite 3.8.1 removed an optimisation where earlier versions of > the query planner were checking for two or more "lower bound" comparisons > against the key for an index, and combining them so the greater of the two > values was us

Re: [sqlite] slowish R*Tree performance

Regarding the R.Tree performance problem, What is the original problem that is causing slow performance in the SQlite R-Tree implementation? Thanks Carlos -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: d

[sqlite] Performance regression with multiple lower bound tests

I've recently noticed a major drop in performance in one part of our main application at work, and have managed to track it down to a change in recent versions of SQLite. We are storing a log in a simple SQLite table, and have a viewing screen which allows the user to browse through the log. C

Re: [sqlite] [ANNOUNCEMENT] Updated: fossil 20140612172556-1 -- DVCS with built-in wiki, http server and issue tracker

2014-06-13 16:09 GMT+02:00 Jari Aalto: >> CYGWIN INSTALLATION INFORMATION > === > If you have questions or comments, please send them to the Cygwin > mailing list at . I tried the new fossil binary for Cygwin, and got the following: $ fossil sqlite cygwin w

[sqlite] System.Data.SQLite.dll failing on WIndows 7

Everyone, I am trying to solve why a third party app called Appigo Sync is failing on my Windows 7 SP1 64bit. To troubleshoot this, I downloaded the following file: sqlite-netFx451-setup-bundle-x86-2013-1.0.92.0.exe and installed it. When I run text.exe from its bin folder, I get the fo