Re: [sqlite] How to enforce a specific order of group_concat?

for group_concat in the sense that it does not mention that the order is (always) arbitrary? Regards, Hardy > Am 2020-03-02 um 04:46 schrieb Keith Medcalf <mailto:kmedc...@dessus.com>>: > > > On Sunday, 1 March, 2020 14:58, mailing lists <mailto:mailingli...@skywind.eu>>

[sqlite] How to enforce a specific order of group_concat?

Assume I create the following table: CREATE TABLE Test (ID INTEGER PRIMARY KEY, Value TEXT); INSERT INTO Test (Value) VALUES('Alpha'); INSERT INTO Test (Value) VALUES('Beta'); INSERT INTO Test (Value) VALUES('Beta'); INSERT INTO Test (Value) VALUES('Alpha'); According to the documentation of

[sqlite] How to prevent sqlite_reset reporting an already known error

I am executing a prepared statement S with a couple of different bindings. The execution sequence is similar to this while (moreBindings) { bind_parameters_to_prepared_statement; sqlite3_step(); if (error) { … } sqlite_reset(); if (error) { } } The issue is that sqlite_reset() reports the

Re: [sqlite] BUG(?) in FTS5

PlayersFTS WHERE (PlayersFTS MATCH 'LastName:B') OR (PlayersFTS MATCH 'FirstNames:2');) > Am 2020-01-23 um 17:51 schrieb Jens Alfke : > > >> On Jan 23, 2020, at 6:47 AM, mailing lists wrote: >> >> The following SELECT statement fails with the error "unable to use fun

[sqlite] BUG(?) in FTS5

Hi, create and fill the tables: CREATE TABLE Games (ID INTEGER PRIMARY KEY, WhiteID INTEGER, BlackID INTEGER); CREATE VIRTUAL TABLE PlayersFTS USING FTS5 (LastName,FirstNames); INSERT INTO Games (WhiteID,BlackID) VALUES(1,2); INSERT INTO PlayersFTS (rowid,LastName,FirstNames) VALUES(1,'A','1');

Re: [sqlite] FTS5: how to find special character sequence containing '.' and '"'

Hi sorry, just forget it. I have overseen a typo. > Am 2019-11-01 um 15:00 schrieb mailing lists : > > Assume the following statements > > CREATE VIRTUAL TABLE NamesFTS USING FTS5 (LastName); > INSERT INTO NamesFTS (LastName) VALUES('L.'); > INSERT INTO NamesFTS

[sqlite] FTS5: how to find special character sequence containing '.' and '"'

Assume the following statements CREATE VIRTUAL TABLE NamesFTS USING FTS5 (LastName); INSERT INTO NamesFTS (LastName) VALUES('L.'); INSERT INTO NamesFTS (LastName) VALUES('"L."'); SELECT rowid FROM NamesFTS; > 1 > 2 SELECT rowid FROM NamesFTS WHERE NamesFTS MATCH '"L."'; > 1 > 2 How do I get

Re: [sqlite] Prepared statements in FTS MATCH queries

'beta'; Regards, Hartwig > Am 2019-11-01 um 07:55 schrieb Dan Kennedy <mailto:danielk1...@gmail.com>>: > > > On 1/11/62 03:03, mailing lists wrote: >> Hi Dan, >> >> I did not know that. What was the reason that it did not work before 3.30? > >

Re: [sqlite] Prepared statements in FTS MATCH queries

Hi Dan, I did not know that. What was the reason that it did not work before 3.30? Regards, Hartwig > Am 2019-10-31 um 19:16 schrieb Dan Kennedy : > > > On 1/11/62 00:32, mailing lists wrote: >> For normal tables I can use something like: >> >> SELECT

[sqlite] Prepared statements in FTS MATCH queries

For normal tables I can use something like: SELECT * FROM Names WHERE FirstNames=? AND or OR LastName=?; For FTS tables I can only use SELECT * FROM FTSNames WHERE FirstNames MATCH ? OR LastName MATCH ?; AND is not supported (still do not know why) Is there any possibility to use prepared

Re: [sqlite] SQLITE_ERROR instead of SQLITE_BUSY or clarification of busy state errors

ednesday, 30 October, 2019 16:33, mailing lists > wrote: > >> I face the following issue: > >> 1) SQLite has been compiled with SQLITE_THREADSAFE=1 and >> SQLITE_DEFAULT_SYNCHRONOUS=3 >> 2) I am opening in a thread a new database (standard journal mode) and &g

[sqlite] SQLITE_ERROR instead of SQLITE_BUSY or clarification of busy state errors

Hi, I face the following issue: 1) SQLite has been compiled with SQLITE_THREADSAFE=1 and SQLITE_DEFAULT_SYNCHRONOUS=3 2) I am opening in a thread a new database (standard journal mode) and creating some tables, indices etc. (explicit transaction) 3) while creating the database a new database

Re: [sqlite] How to increase performance when inserting a lot of small data into table using indices

Hi, > Am 2019-09-12 um 10:55 schrieb Keith Medcalf : > > > On Tuesday, 10 September, 2019 09:26, mailing lists > wrote: > >> I cannot really put all the inserts into one transaction because in case of >> a failure I loose all the already inserted data. >

Re: [sqlite] How to increase performance when inserting a lot of small data into table using indices

are separated, are they? Regards, Hartwig > Am 2019-09-10 um 17:16 schrieb Richard Hipp : > > On 9/10/19, mailing lists wrote: > >> So, the best solution I found so far is to disable indexing while insertion >> and to index the table afterwards > > I think that is the best

[sqlite] How to increase performance when inserting a lot of small data into table using indices

I have the following situation: - in one table relatively small data is inserted (100 bytes per record) - this table contains three indices - about 100 million or more records have to be inserted Insertion really slows down after about 100 000 items have been inserted. I suppose that the slow

[sqlite] Documentation addition request for FTS3 / FTS4 phrase search

Hi, please add to the documentation that column limited phrase search is not supported by FTS3 and FTS4. Example: CREATE VIRTUAL TABLE FTSTable USING FTS3 (content,body); SELECT * FROM FTSTable WHERE FTSTable MATCH 'content:"one two"'; Does not result in an error but also returns no results.

Re: [sqlite] Documentation misunderstanding or bug (FTS3 and "^" character)?

Hi, yes, but unfortunately I have still a project using FTS3 tables to which I have to add new features.. Regards, Hardy > Am 2019-08-30 um 13:00 schrieb Dan Kennedy : > > > On 30/8/62 17:39, mailing lists wrote: >> Hi, >> >> but there is no

Re: [sqlite] Why is a multiple MATCH clause not allowed in an FTS query?

'; SELECT * FROM myData m1, myData m2 WHERE m1.myData MATCH 'one: 42*' OR m2.myData MATCH 'two: alpha'; Strange… Hardy PS: sqlite3 version 3.24.0 > Am 2019-08-30 um 09:43 schrieb mailing lists : > > Because of my (obviously wrong) automatic query generator I came across this > issue:

Re: [sqlite] Documentation misunderstanding or bug (FTS3 and "^" character)?

> as the very first token in any column of the matching row." > > So change "FTS3" to "FTS4" and it will likely work. > > Dan. > > > On 30/8/62 16:31, mailing lists wrote: >> Hi, >> >> I could not find an example showing a result in the d

[sqlite] Documentation misunderstanding or bug (FTS3 and "^" character)?

Hi, I could not find an example showing a result in the documentation, therefore I created one by myself: CREATE VIRTUAL TABLE myData USING FTS3(content); INSERT INTO myData 'alpha beta'; 1) SELECT * FROM myData WHERE myData MATCH 'beta'; Result: content alpha beta This is what I expected.

[sqlite] Why is a multiple MATCH clause not allowed in an FTS query?

Because of my (obviously wrong) automatic query generator I came across this issue: CREATE VIRTUAL TABLE myData USING FTS3 (content, body); SELECT * FROM myData WHERE (content MATCH 'one') AND (body MATCH 'two'); What is the reason that the above query is not allowed and that SELECT * FROM

[sqlite] Performance difference between SELECT ... ORDER BY ... ASC/DESC

Hi, is there in general a performance difference between querying using SELECT … ORDER BY … ASC or DESC? Without an index I believe that the result is the same (sorting has to be done anyway somehow). Using an index it should be also the same but… Are there any examples where DESC is (much)

Re: [sqlite] How to convert SQL file into database when a column value is Inf?

ith : > > On 2018/06/13 6:35 PM, skywind mailing lists wrote: >> Hi Ryan, >> >> my problem is that I use the "most safest" mode that exists for SQLite and >> it still fails… Therefore, I need to know why it fails. > > Alright, but this implies a ver

Re: [sqlite] How to convert SQL file into database when a column value is Inf?

Hi Ryan, my problem is that I use the "most safest" mode that exists for SQLite and it still fails… Therefore, I need to know why it fails. Regards, Hartwig > Am 2018-06-13 um 01:23 schrieb R Smith : > > > On 2018/06/13 12:21 AM, skywind mailing lists wrote: >

Re: [sqlite] How to convert SQL file into database when a column value is Inf?

s [mailto:sqlite-users- >> boun...@mailinglists.sqlite.org] On Behalf Of skywind mailing lists >> Sent: Tuesday, 12 June, 2018 16:06 >> To: SQLite mailing list >> Subject: [sqlite] How to convert SQL file into database when a column >> value is Inf? >> >> Hi, &

Re: [sqlite] How to convert SQL file into database when a column value is Inf?

Hi, the original database is malformed. So, I cannot access it anymore besides doing a dump. Regards, Hartwig > Am 2018-06-13 um 00:17 schrieb Bob Friesenhahn : > > On Wed, 13 Jun 2018, skywind mailing lists wrote: >> >> A workaround is of course to use a text e

[sqlite] Database is malformed but no further information

Hi, when I load my database into sqlite3 and run an integrity check I only get the error message: Error: database disk image is malformed I do not get any further information. What causes this simple error message? I expected to get some more information what is actually the reason why SQLite3

[sqlite] How to convert SQL file into database when a column value is Inf?

Hi, I issued the following commands: echo .dump | sqlite3 Database.sldb > D.sldb sqlite3 -init D.sldb NewDatabase.sldb Unfortunately, reading the SQL file produced the following error: Error: near line 56721: no such column: Inf The corresponding SQL command is: INSERT INTO "Flights"

Re: [sqlite] Usage of temporary files of SQLite3 on Android / SQLite commands fail

Hi, but to which directory should I set it? There is no general tmp directory accessible. Regards, Hartwig > Am 2018-06-10 um 02:30 schrieb Bob Friesenhahn : > > On Sat, 9 Jun 2018, skywind mailing lists wrote: > >> Hi, >> >> currently I am not crea

Re: [sqlite] Usage of temporary files of SQLite3 on Android / SQLite commands fail

edy : > > On 06/10/2018 12:00 AM, skywind mailing lists wrote: >> Hi, >> >> what is your experience with temporary files requested by SQLite3 on >> Android? I am using SQLite3 natively on Android - I compiled SQLite3 by >> myself - and get an error when

[sqlite] Usage of temporary files of SQLite3 on Android / SQLite commands fail

Hi, what is your experience with temporary files requested by SQLite3 on Android? I am using SQLite3 natively on Android - I compiled SQLite3 by myself - and get an error when SQLite3 tries to create temporary files because: - the directories /var/tmp /usr/tmp /tmp

Re: [sqlite] INSERT OR REPLACE statement and triggers

are currently off > by default. > > <https://sqlite.org/lang_conflict.html> > <https://sqlite.org/pragma.html#pragma_recursive_triggers> > > On December 23, 2017 7:05:59 AM EST, R Smith <ryansmit...@gmail.com> wrote: >> >> >> On 2017/12/23

[sqlite] INSERT OR REPLACE statement and triggers

Hello, I have checked the documentation but did not find an explicit answer concerning my case. Of course I can test it but this does not mean that the functionality is guaranteed also for future versions. Assume I have an insertion statement like INSERT OR REPLACE INTO TestTable VALUES(1,2);

Re: [sqlite] Massively multithreaded SQLite queries

Hi, just my few cents: if you are using the RTree module I made very bad experiences running SQLite in parallel, even when running only two or three threads in parallel. In this case I use a single thread-safe queue that is handling all SQLite access. Regards, Hartwig > Am 2017-03-04 um

[sqlite] Bug in mkFullPathname

Assume I have got a zPath like abc.def passed to mkFullPathname. Inside mkFullPathname zPath[0] != '/' will evaluate to true. Assume further that osGetcwd(..) will return '/' (which can actually be the case under Android and theoretically under other systems as well but probably less likely).

Re: [sqlite] Strange SQLite bug(?!)

Thanks! In the meantime I found out that version 3.8.8.3 is still working while 3.9.0.0 fails. Regards, Hartwig > Am 2016-08-02 um 18:47 schrieb Dan Kennedy <danielk1...@gmail.com>: > > On 08/02/2016 01:01 PM, skywind mailing lists wrote: >> HI, >> >> it

[sqlite] Branch Apple-OSX

Hi, I have seen that the branch Apple-OSX is still active. Is there any reason why the contents of this branch are not merged into trunk? Or is the trunk always merged into Apple-OSX? What is the best branch to use for OS X / iOS? Regards, Hartwig

Re: [sqlite] Strange SQLite bug(?!)

atement(databaseHandle,"DELETE FROM A WHERE AnotherID=1;"); ExecuteStatement(databaseHandle,"DELETE FROM B WHERE ID=1;"); ExecuteStatement(databaseHandle,"COMMIT;"); sqlite3_close(databaseHandle); }

Re: [sqlite] Strange SQLite bug(?!)

Hi, I have added a database but it seems to be that the zip file got lost. Regards, Hartwig > Am 2016-08-02 um 01:13 schrieb Richard Hipp <d...@sqlite.org>: > > Do you have a database schema to go with your sample program? > > On 8/1/16, skywind mailing lists <

[sqlite] Strange SQLite bug(?!)

Hi, I have got a database that works using SQLite 3.7.7 but not with version SQLite 3.13.0. I get the assertion Assertion failed: (((Fts3Table *)pVtab)->mxSavepoint < iSavepoint), function fts3SavepointMethod, file /.../sqlite/sqlite3.c, line 144649. I have compiled the SQLite amalgamation

[sqlite] Preprocessing directives for compiling SQLite for Universal Windows

Hi, I checked SQLite’s documentation and a bit the internet but it seems to be that nobody has a definite answer which preprocessor directives have to be used to compile SQLite for Universal Windows. Without any preprocessor directives the compilation badly fails (system calls are the

Re: [sqlite] UPDATE statement without FROM clause

; On Sat, 4 Jun 2016 18:18:36 +0200 > skywind mailing lists <mailingli...@skywind.eu> wrote: > >> At the moment I have to run something like: >> >> UPDATE A SET item1=(SELECT B.item FROM B WHERE B.ID=A.ID),... >> itemN=... WHERE EXISTS (SELECT 1 FROM B WHERE B.I

Re: [sqlite] UPDATE statement without FROM clause

> Am 2016-06-04 um 15:33 schrieb Gerry Snyder <mesmerizer...@gmail.com>: > > If SQLite implemented the FROM it would just be a translation into the > complex and slow statements you want to avoid. > > Gerry Snyder > On Jun 4, 2016 9:19 AM, "skywind mailing lists&qu

[sqlite] UPDATE statement without FROM clause

Hi, I am using quite often SQL statements that update the data of one table with data from another table. This leads to some quite complex (and slow) statements because SQLite3 is not supporting a FROM clause in update statements. I am just wondering why the FROM clause is not supported by

[sqlite] why is searching for a range of rowids in an FTS table a slow operation?

Hi, according to the documentation this is a slow query for FTS tables: SELECT * FROM mail WHERE rowid BETWEEN 15 AND 20; while SELECT * FROM mail WHERE rowid=15; is fast. As far as I know both queries are fast on normal tables. Where is the difference / what is the reason for the

[sqlite] SQLite database becomes corrupt on iOS

vin : > > > On 14 Aug 2015, at 4:10pm, skywind mailing lists > wrote: > >> I do not get any error message from SQLite. And the database only gets >> corrupted when the iDevice has to shut down due to battery issues. I have >> never had a customer complaining ab

[sqlite] SQLite database becomes corrupt on iOS

the same application". > > Just sayin'. > > -- > E > > > On Thu, Aug 13, 2015 at 2:04 PM, Simon Slavin wrote: > >> >> On 13 Aug 2015, at 6:32pm, skywind mailing lists >> wrote: >> >>> Before my app closes I close the database expl

[sqlite] SQLite database becomes corrupt on iOS

mon Slavin : > > > On 13 Aug 2015, at 6:32pm, skywind mailing lists > wrote: > >> Before my app closes I close the database explicitly. Though I do not know >> if this happens always when the iDevice shuts down due to battery issues. > > iDevices shut down quite a

[sqlite] SQLite database becomes corrupt on iOS

Hi, does anybody have any similar experience that an SQLite database becomes corrupt on iOS? It seems to be that when the iDevice is running out of battery it can happen that the SQLite becomes corrupt. I have currently not found a possibility to reproduce it but once a while my customers

Re: [sqlite] Request to change int parameter to size_t parameter / potential bug on iOS (64 bit)

Am 07.09.2014 um 21:52 schrieb Simon Slavin : > > On 7 Sep 2014, at 7:19pm, Richard Hipp wrote: > >> mailingli...@skywind.eu> wrote: >> >>> Is it possible to change the fourth parameter in sqlite3_bind_XXX (and >>> probably other locations) because this

[sqlite] Request to change int parameter to size_t parameter / potential bug on iOS (64 bit)

Hello, I have seen that SQLite uses normally parameters of type "int" to pass the size of a variable (see sqlite3_bind_blob, fourth parameter). When compiling SQLite3 with Clang and some warnings enabled I get warnings when passing sizeof(...) as the fourth parameter. The reason is that

Re: [sqlite] Sqlite RTree nearest neighbour

Hi Clemens, thanks for the link! Regards, Hartwig Am 22.08.2014 um 22:26 schrieb Clemens Ladisch <clem...@ladisch.de>: > skywind mailing lists wrote: >> I hoped that somebody already tried to implement a nearest neighbor >> algorithm. > > Typically, objects are

Re: [sqlite] Sqlite RTree nearest neighbour

Hello, I hoped that somebody already tried to implement a nearest neighbor algorithm. Is the format of the shadow tables somewhere documented or do I have to analyze the source code? Regards, Hartwig Am 22.08.2014 um 02:58 schrieb Richard Hipp : > On Thu, Aug 21, 2014 at

[sqlite] Sqlite RTree nearest neighbour

Hello, does anybody have any experience with implementing a nearest neighbor search using SQLite's RTree functionality? Is a nearest neighbor search possible? Regards, Hartwig ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Unnecessary implicit conversion (may lead to a bug)

In afpUnlock(sqlite3_file *, int) the sharedLockByte is defined as an int (int sharedLockByte = SHARED_FIRST+pInode->sharedByte;) although all other related variables and the following function parameters are defined as unsigned long longs. At least theoretically this can lead to information

Re: [sqlite] [BUG; 3.7.13] ANALYZE leads to a wrong query plan for RTrees

Am 10.12.2013 um 10:59 schrieb Dan Kennedy <danielk1...@gmail.com>: > On 12/10/2013 02:44 PM, skywind mailing lists wrote: >> This is an example that the ANALYZE command leads to a wrong query plan for >> RTrees: >> >> CREATE TABLE A (ID INTEGER PRIMARY K

[sqlite] [BUG; 3.7.13] ANALYZE leads to a wrong query plan for RTrees

This is an example that the ANALYZE command leads to a wrong query plan for RTrees: CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude); CREATE VIRTUAL TABLE B USING RTree (ID, FromLatitude, TillLatitude, FromLongitude,TillLongitude); INSERT INTO A VALUES(1,0,0,0); INSERT

Re: [sqlite] RTrees and query speed

Am 09.12.2013 um 10:06 schrieb Clemens Ladisch <clem...@ladisch.de>: > skywind mailing lists wrote: >> Assume I have the following tables: >> >> CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude); >> CREATE VIRTUAL TABLE B USING RTre

[sqlite] RTrees and query speed

Assume I have the following tables: CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude); CREATE VIRTUAL TABLE B USING RTree (ID, FromLatitude, TillLatitude, FromLongitude,TillLongitude); and there is an index on A for Latitude,Longitude. B is filled using INSERT INTO B

Re: [sqlite] Update statement

my SQLite code > and it seems to be working correctly. > > Peter > > - Original Message >> From: skywind mailing lists <mailingli...@skywind.eu> >> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> >> Sent: Tue, May 7, 2013 10:46:

Re: [sqlite] Update statement

Hi, my question is: is it guaranteed that it works? Regards, Hartwig Am 07.05.2013 um 03:24 schrieb James K. Lowden: > On Mon, 6 May 2013 23:53:40 +0100 > Simon Slavin wrote: > >>> How do I create this kind of update statement? >>> >>> UPDATE T SET a=0.5*(a+b),

[sqlite] Update statement

Hi, How do I create this kind of update statement? UPDATE T SET a=0.5*(a+b), b=0.5*(b-a); The RHS should always be used with the values of a and b before the assignment. I think that the result of this kind of statement is undefined, or? Regards, Hartwig

[sqlite] Ticket 13137dccf36902cdd4e20c11d857c7ad7f5d8777 / FTS3 and last_insert_rowid()

Hi, why is the above mentioned still open? It seems to be that the bug does not exist anymore under 3.7.7. Best regards, Hartwig ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Database becomes corrupted on iPhone

g 2011, at 9:19pm, skywind mailing lists wrote: > >> A few user have reported that when the iPhone/iPad runs out of batteries the >> SQLite3 database may become corrupted. I have received one database back and >> it is indeed defect and unrecoverable. Does anybody have an idea

Re: [sqlite] Database becomes corrupted on iPhone

is running out of batteries (perhaps during a write operation?). BTW: I assume that the rollback journal is in the same folder as the database file, right? Best regards, Hartwig Am 07.08.2011 um 22:25 schrieb Richard Hipp: > On Sun, Aug 7, 2011 at 4:19 PM, skywind mailing lists < >

[sqlite] Database becomes corrupted on iPhone

I am using SQLite 3.6.x and higher for two apps for the iPhone/iPad. I do not use the built-in SQLite library because I need Rtree and FTS support. Therefore, I compile it by myself with the following preprocessor directives: SQLITE_THREADSAFE=1 SQLITE_ENABLE_RTREE=1 SQLITE_ENABLE_FTS3=1

[sqlite] sqlite3 amalgamation and unused variables

There seem to be a couple of variables in the sqlite3 amalgamation that get assigned a value but actually their value is not used. If there is an intention to get rid of these statements I will submit samples like h = pFile->h; (sqlite3.c in line 26039 version 3.7.7) But perhaps these lines

Re: [sqlite] FTS & sqlite3_last_insert_rowid

Hi, FTS and sqlite3_last_insert_rowid do not work together. This is a known shortcoming. Basically this also means that you can't use any triggers involving FTS. Regards, Hartwig Am 13.05.2011 um 17:38 schrieb Steven Parkes: > I gather sqlite3_last_insert_rowid doesn't play well with FTS? I

Re: [sqlite] Out of memory? How could that be on a 32G iPhone?

Hi Rolf, I am using FMDB and SQLite for more than 2 years now and have not experienced any problems so far. Therefore, I expect that the bug is somewhere else but not inside SQLite (3.7.2) nor FMDB (2009-10-18). Greetings, Hartwig Am 04.05.2011 um 23:22 schrieb Rolf Marsh: > > > Prior to

Re: [sqlite] SQLite GUI comparison

on the table In both cases you will get an error message. Hartwig Am 22.02.2011 um 00:16 schrieb BareFeetWare: > On 22/02/2011, at 4:31 AM, skywind mailing lists wrote: > >> "Supports SQLite extension" would be an accurate feature description. And in >> the cell (value) I s

Re: [sqlite] SQLite GUI comparison (was: ANN: Base 2.0, Mac SQLite GUI)

y you may have a row for each type of extension but I find this a bit too much. Hartwig Am 20.02.2011 um 21:48 schrieb BareFeetWare: > On 21/02/2011, at 3:20 AM, skywind mailing lists wrote: > >> in your comparison chart it would also be nice to see which software is able >>

Re: [sqlite] ANN: Base 2.0, Mac SQLite GUI

Hi Tom, in your comparison chart it would also be nice to see which software is able to support SQLite extension. A couple of them do not support the FTS nor RTree capabilities of SQLite. Hartwig Am 20.02.2011 um 07:19 schrieb BareFeetWare: > Hi Ben, > > In reply to your announcement of

[sqlite] Optimizing queries using RTrees

I have created an RTree table with the command CREATE VIRTUAL TABLE AirspaceRTree USING rtree (ID,MinLatitude,MaxLatitude,MinLongitude,MaxLongitude,MinAltitude,MaxAltitude); Furthermore, I have a table Airspace. The contents besides the ID (primary key) are irrelevant for this context. When