News for hackers. Stuff that matters.
Re:JSON Crack – Visualize JSON data into graphs by youngNed on Sunday August 28, 2022 @06:51AM (#32627329)
this might be a good place to ask: is there any tool out there that can help with json to normalised tables?

I know that many databases can store json, but i often have api's that i would like storing in tables, and feel that 'splitting it out' should be fairly trivial.

Each time i think about making a tool, i am put off by the fact that there is a voice saying 'someone will have done this, in a much better way than you!' :-)

EDIT:

Ignore that, i did that think where i didn't look at the link - this pretty much does what i would need

Re:JSON Crack – Visualize JSON data into graphs by simonw on Sunday August 28, 2022 @07:24AM (#32627486)
My sqlite-utils tool can load JSON into a SQLite database table: https://sqlite-utils.datasette.io/en/stable/cli.html#inserti...

It can also be used to run SQL queries against an in-memory database created from one or more JSON or CSV imports: https://simonwillison.net/2021/Jun/19/sqlite-utils-memory/

Re:JSON Crack – Visualize JSON data into graphs by raxxorraxor on Thursday September 01, 2022 @08:03AM (#32675173)
If you have an MS office suite the power query editor can expand JSON to columns. Doesn't result in a table that is normalized per se, but it is quite a powerful tool overall. Not really a Microsoft fan, but what they provide here is not bad at all.
Re:JSON Crack – Visualize JSON data into graphs by awild on Sunday August 28, 2022 @08:12AM (#32627779)
Have you looked at Millercsv or jq?