Folks, back to work.
I'm trying to convince some colleagues that they should persist "reports"
from a product as JSON instead of a fiddly custom text format. Each
"report" looks a lot like a self-contained document to me, with a few
sections containing the parameters, layout and data of the report. I'm
pitching that JSON is standard, readable by everything, change tolerant,
and ... most importantly ... databases like Mongo, Cosmos, Dynamo, etc
easily store and index JSON documents. They could stuff their reports into
a document db and get the indexing, speed and robustness for nothing.
However, some customers will want to store all the JSON reports in the file
system, so I'm wondering if there is some library that indexes and manages
local JSON documents. If I was younger I'd write one myself, but I'll bet
someone's already done something similar. Any ideas anyone? I'm searching.
I think the latest SQL Server versions do this, but it might be a bit of a
heavyweight option.
*Greg*
