> On Jan 8, 2020, at 3:13 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > I believe Jens' point is valid, as long as you don't have to search/scan > headers.
You can even do that — to search for a specific header’s value, just create an index on json_extract(headers, ‘$Header-Name’), then in a query use that same expression in an equality or relational comparison. (You’ll need to normalize the case of header names during the JSON conversion while inserting, since JSON keys are case-sensitive but RFC822 header names aren’t.) —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users