Hacker News new | comments | show | ask | jobs | submit login
Contentless SQLite FTS4 Tables for Large Immutable Documents (cocoamine.net)
24 points by ingve 654 days ago | hide | past | web | 5 comments | favorite



An interesting consequence of contentless tables is that you end up with a database that does not have data. Should we still call it a database? :)


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


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


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.


Exactly




Guidelines | FAQ | Support | API | Security | Lists | Bookmarklet | DMCA | Apply to YC | Contact

Search: