top | item 9729008

Json = sql

1 points| jbensamo | 10 years ago

hi HN coolness - does anyone know of a good lib in ruby/python or other allowing to translate a json blurb into a set of "insert or update..." sql queries. bonus point if it dynamically extends the schema of the db when it finds new json fields.

underlying issue - building a small datawarehouse to consolidate data from prod dbms & mixpanel/other tools. Ideally to put a BI tool like jaspersoft and write sql on top of it.

thanks!

1 comment

vmorgulis|10 years ago

There is Talend (https://www.talend.com/) but it's not a library. It's a more general ETL. It requires a time to be learned.

I have a tool of my own which "flatten" an object to an array of pairs (for example {"a":1,"b":{"c":2}} becomes ["a":1,"b.c":2]).

Something like that may exists in Underscore.js.