The Shape of Everything
A website mostly about Mac stuff, written by Gus Mueller
» Acorn
» Retrobatch
» Twitter
» Micro.blog
» Mastodon
» Instagram
» Github
» Maybe Pizza?
» Archives
» Feed
» Micro feed
September 7, 2015

Charles Parnot: Contentless SQLite FTS4 Tables for Large Immutable Documents:

"If you use SQlite FTS4 for indexing large immutable documents, you might want to consider contentless tables. With minor adjustments, the database could be 2 to 3-time smaller."

This is pretty neat and I'll most likely be doing this in a future release of Acorn, thanks to Charles' work here.