[sqlite] Can select * from table where not exists (subquery) be optimized?

Hello, I have a directed acyclic graph defined as follows - sqlite> .sch CREATE TABLE nodes(id integer primary key, description text); CREATE TABLE edges(parent not null references nodes, child not null references nodes, primary key(parent, child)); Now I want to find the "roots" of the graph -

Re: [sqlite] sqlite3AtoF()

Hello, On 2017-12-29 02:25, Richard Hipp wrote: Please test the latest trunk version (or any version after check-in https://www.sqlite.org/src/timeline?c=fd2e0e7a) and confirm that the modifications work for you. It works as expected. Thank you. -- best regards Cezary H. Noweta _

Re: [sqlite] Knowing when not to use a R-Tree index, and clustering tables along spatial indexes

Am Fri, 29 Dec 2017 19:59:12 +0100 schrieb Andrea Aime: > With SQLite R-Tree I'm using either a join with the index virtual table, or > a subquery > retrieving the ids from the rtree. Regardless, the query is basically > ordering SQLite > to use the index. > So I was wondering, is there any opport