On 16 Jun 2019, at 7:54pm, Jens Alfke <j...@mooseyard.com> wrote: > As far as I know, there is no benefit to storing each element of such a > vector as a separate column in SQLite. Instead, the entire vector should be > stored as a single blob — for example, as a concatenation of 3072 IEEE floats > in some fixed byte-order.
I think that trumps the discussion. If Jens is right, and there's no point in extracting the contents of a single column, just use a single BLOB or TEXT column and store everything in it. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
