I am trying using Sqlite to news reader and local small NNTP server.
NNTP message has header and body. Some special headers field needed to
XOVER I keep in one table, body I will compress and store as blob, some
other required header fields I will store in own columns, but also exists
not required, user defined header fields.
How store its as pairs key,value? There fields I might not store as pair,
simply as one field - one whole string for header field. But it is variable
number this fields and column are strictly defined. Maybe all in one Sqlite
text field or define for example 10 field which often will empty?
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
