SQL差异的原因 [英] Reasons for SQL differences

问题描述

尽管存在SQL的ANSI标准，为什么SQL发行版仍是如此非标准？ SQL数据库的工作方式确实存在许多有意义的差异，还是我一直在使用的两个数据库：MS-SQL和PostgreSQL？为什么会出现这些差异？

Why are SQL distributions so non-standard despite an ANSI standard existing for SQL? Are there really that many meaningful differences in the way SQL databases work or is it just the two databases with which I have been working: MS-SQL and PostgreSQL? Why do these differences arise?

推荐答案

这是隐身锁定的一种形式。乔尔在这里进行了详细介绍：

It's a form of "Stealth lock-in". Joel goes into great detail here:

• http://www.joelonsoftware.com/articles/fog0000000056.html


• http://www.joelonsoftware.com/articles/fog0000000052.html

• http://www.joelonsoftware.com/articles/fog0000000056.html
• http://www.joelonsoftware.com/articles/fog0000000052.html

公司最终将其业务功能与实施中的非标准功能或奇怪的不受支持的功能绑定在一起，这限制了它们从供应商转向竞争对手的能力。

Companies end up tying their business functionality to non-standard or weird unsupported functionality in their implementation, this restricts their ability to move away from their vendor to a competitor.

另一方面，这是很短视的，因为任何半脑子的人都倾向于将专有部分抽象化，或者如果过于严格，则完全避免锁定。

On the other hand, it's pretty short-sighted because anyone with half a brain will tend to abstract away the proprietary pieces, or avoid the lock-in altogether, if it gets too egregious.

这篇关于SQL差异的原因的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！