The Baked Data architectural pattern
simonwillison.net
simonwillison.net
Paul McLanahan wrote more about this works here: https://mozilla.github.io/meao/2018/03/28/bedrock-the-sqlite...
I've been toying with loading the pages into SQLite to facilitate search for awhile. Thanks for the reminder!