News for hackers. Stuff that matters.
Re:Contentless SQLite FTS4 Tables for Large Immutable Documents by j_s on Tuesday September 08, 2015 @01:09PM (#10186895)
An interesting point; however (as I'm sure you're aware) the specific table may be empty, but the database definitely is not.

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".

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 ;-)