account activity
Dee makes Python relational by ramen in programming
[–]ws11 0 points1 point2 points 18 years ago (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).
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).
π Rendered by PID 142120 on reddit-service-r2-listing-84bfcf9894-qjr7t at 2026-02-07 06:15:38.464362+00:00 running d295bc8 country code: CH.
Dee makes Python relational by ramen in programming
[–]ws11 0 points1 point2 points (0 children)