At least in Cosmos, there’s a good story with the indexing policy that’s very configurable. (Including fully automated if that’s what you need)
Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | About Greg: https://about.me/greg.low From: Greg Keogh via ozdotnet <ozdotnet@ozdotnet.com> Sent: Friday, 2 September 2022 10:52 AM To: ozDotNet <ozdotnet@ozdotnet.com> Cc: Greg Keogh <gfke...@gmail.com> Subject: Re: Indexed JSON documents (file system) I found this: https://github.com/ketanip/dbjson hope it helps. If I had to do it myself I'd probably do something similar, maybe use SQLite to hold an index of the properties of JSON documents. I would have to walk every document's tree (fragile) and the hierarchy of properties would have to be represented as relational tables (hacky, not meant for that). Still thinking -- Greg