[sqlite] UNQL as an extension to sqlite3 and now could use index expressions

2015-09-05 Thread Domingo Alvarez Duarte
Hello ! And here is the database dump for the example: ___ PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE users(id INTEGER PRIMARY KEY, name TEXT, json_misc TEXT); INSERT INTO "users" VALUES(1,'Domingo','{"color":"cyan", "has_eyes": true}'); CREATE TABLE "unql_users"(x);

[sqlite] UNQL as an extension to sqlite3 and now could use index expressions

2015-09-05 Thread Domingo Alvarez Duarte
Hello ! I did for one project a kind of sqlite3 extension using UNQL (http://unql.sqlite.org/index.html/wiki?name=UnQL) it has some flaws (and I did some bug fixes) like only performing linear scan on collections, but now with index expressions support on sqlite3 it could be revived back with in