> On Aug 22, 2018, at 10:04 AM, Randall Smith <[email protected]> wrote: > > BLOBs are useful for storage of binary info (e.g., a file), but they are not > human readable and require complex conversion when inserting and extracting > info from the DB.
*Shrug* I work with lots of non-human-readable data so I don't see it as a major problem :) And the sqlite blob APIs are pretty simple (just pass a pointer and a size.) > AFAIK you can't search or index on them. Yes you can. Blobs support equality tests. If you need to compare them or create an index, you just define a custom collation function (I've done it; it's pretty easy.) —Jens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
