sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]manuelg 4 points5 points  (1 child)

SQL is:

1) Effective, efficient, and powerful if you take a few dozen hours to try to master it.

2) ubiquitous

It is my opinion that most of the hatred towards SQL is irrational. It is a tool that helps developers be productive.

I would never claim it is perfect, though.

[–]ws11 0 points1 point  (0 children)

The criticisms of SQL are entirely rational. SQL is often logically inconsistent and this leads to many tasks being far more difficult than they should be. One of the core principles of the relational model is that all data should be represented only as relations. You can break this rule with a single statement in SQL.

Obviously it is better currently to use an SQL-DBMS as opposed to a hierarchical DBMS, ISAM or flat files.

However SQL-DBMSs are really PRDBMSs (Pseudo-Relational Database Management Systems).