That's a fair question, I shouldn't have posted that without context.
I was initially considering storing JSON to speed up the ingestion since the results are in JSON, which is how I found JSONBench.
But, of course, parsing the JSON isn't the bottleneck for me - rate limits and response time is - so I didn't end up going that route.
What I mention first in my message was a much bigger driver - convenience.
If the analytics become much more complex I might revisit DuckDB or another OLAP solution.
What I mention first in my message was a much bigger driver - convenience. If the analytics become much more complex I might revisit DuckDB or another OLAP solution.