SQLite Functions for Working with JSON
The cool thing for working with json is to store each json document as is in one column, then make virtual columns that store some specific information you want to query, using some combination of json_extract, then index those columns.This makes for super-fast search, and the best part is you don't have to choose what to index at insert time; you can always make more virtual columns when you need them.(You can still also search non-indexed, raw json, although it may take a long time for large collections).I love SQLite so much.