On 8 Jan 2020, at 3:11am, Jens Alfke <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
