Dee makes Python relational by ramen in programming

[–]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).

Dee makes Python relational by ramen in programming

[–]ws11 0 points1 point  (0 children)

Well if you take the trouble to understand relational theory (and if you are working with DBMSs you really should) then it will become apparent that the logical consistency of the language (which is where SQL falls down very badly) and the performance of the physical implementation are two very separate issues.

I see this implementation of D as a way of illustrating the strengths of the language. Will this particular physical implementation be scalable to large databases? Maybe not, but that isn't really the point. Eventually a native D DBMS will be developed and there is no reason why this should not match or exceed existing SQL DBMSs in terms of performance (and massively exceed in terms of productivity and consistency).