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

科技回声

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

GitHubTwitter

首页

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

资源链接

HackerNews API原版 HackerNewsNext.js

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

Against SQL (2021)

4 点作者 yladiz19 天前

1 comment

rawgabbit19 天前
Sorry. These criticisms don’t make much sense.<p>The author says SQL is the language for manipulating relational data. And then proceeds to complain SQL sucks at manipulating JSON.<p>Hmm. JSON is not relational. SQL expects data to be in third normal form.<p>If you are primarily working with JSON, please use something else.<p>The other two criticisms about SQL verboseness and reluctance to employ functions and other memory manipulations is the author’s confusion of the intended purpose of SQL. SQL treats data as the first class citizen. Think of data as the noun. SQL DML and SQL functions are modifiers. This is why SQL appears verbose. It is dragging all these data structures around. If you want to reduce SQL’s verbosity then you need to take an axe to the raw tables themselves and make them all cookie cutter. But then you have a completely different problem.