On 8 Jan 2020, at 3:11am, Jens Alfke <j...@mooseyard.com> wrote: > Consider encoding the headers as JSON and storing them in a single column. > SQLite has a JSON extension that makes it easy to access values from JSON > data in a query. You can even index them. > > Simon’s suggestion (a row per header) is correct in theory, but the large > numbers of headers you’ll be storing in an NNTP database will make that > approach pretty expensive, I think.
I believe Jens' point is valid, as long as you don't have to search/scan headers. I'm not used to being able to access JSON inside SQLite yet. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
