Json = sql

1 points by jbensamo 10 years ago | 1 comment

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!

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.