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
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