Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

JSON Crack – Visualize JSON data into graphs

jsoncrack.com

Post reply on HN
Print view View original

21–30 of 100 posts

Re: JSON Crack – Visualize JSON data into graphs

#21

Post by youngNed »

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

#22

Post by brailsafe »

This looks like it might he useful for migrating pre-typescript code to Typescript. Identifying permutations of otherwise similar objects can be a pain, and sometimes similar APIs will return fields that have the same property name but only contain a small subset of data.

Re: JSON Crack – Visualize JSON data into graphs

#25

Post by simonw »

youngNed wrote: post #21

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…

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

#26

Post by wruza »

yieldcrv wrote: post #9

Note: when browsing on mobile it isn't obvious that there are examples, the tweet from github isnt obvious that it is an example and the interactive graph doesnt look like one because it zooms into blank space although I have a desktop and do development there, my interest in a new tool is frequently is sparked by my casual browsing on mobile, there might be (many) others like me

Yep, my first thought was “but where are examples” and I couldn’t find any.

Re: JSON Crack – Visualize JSON data into graphs

#29

Post by clementmas »

yieldcrv wrote: post #9

Note: when browsing on mobile it isn't obvious that there are examples, the tweet from github isnt obvious that it is an example and the interactive graph doesnt look like one because it zooms into blank space although I have a desktop and do development there, my interest in a new tool is frequently is sparked by my casual browsing on mobile, there might be (many) others like me

I scrolled down on mobile and closed the website because I couldn't see any example
Post reply on HN