On 2 Sep 2019, at 10:59, Dominique Devienne wrote: > On Mon, Sep 2, 2019 at 8:06 AM Robert M. Münch <[email protected]> > wrote: > >> Hi, I think that SQLite use some bitmap indexes > > > Not that I know of, but I don't know the full source code. Maybe FTS[345] > do/es, but SQLite itself only uses BTree-indexes AFAIK.
I think what would be very nice to have in SQLite is a bitmap (not image) datatype where I can store & query single bits and get back a rowid cursor. So, that I can iterate over the hits. That would unify the API and access pattern to be SQLite compliant. No need to fiddle around with other data-structure or concepts. -- Robert M. Münch, CEO Saphirion AG smarter | better | faster http://www.saphirion.com http://www.nlpp.ch Check my calendar at https://doodle.com/saphirion to find a free slot.
signature.asc
Description: OpenPGP digital signature
_______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
