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 ;-)
Re:Contentless SQLite FTS4 Tables for Large Immutable Documents
by crishoj on Tuesday September 08, 2015 @05:12PM
(#10188230)
For the iOS version of the Thai-English Dictionary from thai-language.com (https://appsto.re/us/QS7jQ.i), I use a content-less FTS4 index and indeed do not store the actual dictionary content in SQLite at all. In this application, I'd be happy to settle with referring to it as merely an index, and not a database.
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".
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 ;-)