TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Json = sql

1 点作者 jbensamo将近 10 年前
hi HN coolness - does anyone know of a good lib in ruby&#x2F;python or other allowing to translate a json blurb into a set of &quot;insert or update...&quot; sql queries. bonus point if it dynamically extends the schema of the db when it finds new json fields.<p>underlying issue - building a small datawarehouse to consolidate data from prod dbms &amp; mixpanel&#x2F;other tools. Ideally to put a BI tool like jaspersoft and write sql on top of it.<p>thanks!

1 comment

vmorgulis将近 10 年前
There is Talend (<a href="https:&#x2F;&#x2F;www.talend.com&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.talend.com&#x2F;</a>) but it&#x27;s not a library. It&#x27;s a more general ETL. It requires a time to be learned.<p>I have a tool of my own which &quot;flatten&quot; an object to an array of pairs (for example {&quot;a&quot;:1,&quot;b&quot;:{&quot;c&quot;:2}} becomes [&quot;a&quot;:1,&quot;b.c&quot;:2]).<p>Something like that may exists in Underscore.js.