Re:Ask HN: What made SQL databases so popular?
by twic on Sunday March 10, 2013 @08:12AM
(#5351575)
I don't believe this is correct. SQL certainly includes some things which don't exist in the pure relational model (LIMIT, stored procedures, array types), but i am not aware of anything in SQL which prevents you using a pure relational model. SQL is not a pure implementation of the relational model, but it's close enough that is's reasonable to talk about SQL being relational.
[ Parent
| on HN ]
Re:Ask HN: What made SQL databases so popular?
by TheZenPsycho on Sunday March 10, 2013 @08:31AM
(#5351619)
1. The existence of a null value (3-value-logic)
2. permitting duplicate rows
3. permitting duplicate columns.
4. "outer" joins.
and.. other things, that you can enforce in your client application, but then that rather defeats the whole point of having a "relational database management system". you might as well just have a dumb key-value store, if you have to enforce so much of what a "relational database" is in your app.
note that not even the SQL standards use the word "relational". anywhere. Years ago I couldn't believe this, but go ahead and look. It's not there.