On Apr 3, 2019, at 6:30 AM, Lifepillar <lifepil...@icloud.com> wrote: > > does SQLite support indexes on blobs?
It claims to: $ sqlite3 x.db SQLite version 3.26.0 2018-12-01 12:34:55 Enter ".help" for usage hints. sqlite> create table x (a blob); sqlite> create index xi on x(a); sqlite> explain query plan select a from x where a=5; QUERY PLAN `--SEARCH TABLE x USING COVERING INDEX xi (a=?) sqlite> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users