Re:Contentless SQLite FTS4 Tables for Large Immutable Documents
by charles_parnot on Tuesday September 08, 2015 @02:39PM
(#10187456)
Right, it was tongue in cheek. There is of course some data in there :-)
I suppose what I meant is that it is lossy: you cannot get back what you "INSERT". That violates a pretty basic assumption about what a database is supposed to do ;-)
Per the article, it is true that "the ‘content’ part of a contentless table is simply empty", but "Behind the scenes, SQLite creates various data structures for the index".