Hacker News new | ask | show | jobs
by j_s 3944 days ago
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".

1 comments

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