3 ms·

SQL can be relational, if you do it right: http://en.m.wikipedia.org/wiki/Relational_model#SQL_and_the_relational_model http://en.m.wikipedia.org/wiki/Relationa

SQL can be relational, if you do it right: http://en.m.wikipedia.org/wiki/Relational_model#SQL_and_the_relational_model http://en.m.wikipedia.org/wiki/Relational_model#SQL_and_the_...

TheZenPsycho 14y ago
True. You can also make good programs in PHP if you "do it right". it's not exactly promoted or encouraged, or even anywhere on the radar though, and doing so involves a fair bit of that relational logic being implemented and enforced in the client. The point is, it's possible to have a "relational database management system" which enforces the relational axioms for you. SQL is fundamentally incompatible with this concept, and forces the programmer to keep the databases relational.
- skore 14y ago
  > True. You can also make good programs in PHP* if you "do it right". it's not exactly promoted or encouraged, or even anywhere on the radar though, and doing so involves a fair bit of that relational logic being implemented and enforced in the client. It seems while you see that you're making a concession, you fail to understand that that actually disproves your own point. I repeat: Your argument is invalid. > The point is, it's possible to have a "relational database management system" which enforces the relational axioms for you. People aren't saying that it's impossible - they're saying it's a question of practicality, with the most true to the abstract concept being the least practical in real world applications. > SQL is fundamentally incompatible with this concept, and forces the programmer to keep the databases relational. What? * By the way: Classic case of "doubting, supported by not looking". Even for PHP, there are plenty of resources like http://www.phptherightway.com/ http://www.phptherightway.com/ and they are widely known and shared amongst people who know their stuff.
  - TheZenPsycho 14y ago
    There is a difference between "SQL is relational" and "SQL can be used to maintain a relational database". the first is false, the second is true. As for whether it's practical to have a relational database system, are you claiming that it isn't ? Re: PHP. I said that PHP can be used to make good programs. Is this a point you disagree with? or, do you see some other point?

SQL can be relational, if you do it right: http://en.m.wikipedia.org/wiki/Relational_model#SQL_and_the_relational_model http://en.m.wikipedia.org/wiki/Relational_model#SQL_and_the_...

TheZenPsycho 14y ago

True. You can also make good programs in PHP if you "do it right". it's not exactly promoted or encouraged, or even anywhere on the radar though, and doing so involves a fair bit of that relational logic being implemented and enforced in the client. The point is, it's possible to have a "relational database management system" which enforces the relational axioms for you. SQL is fundamentally incompatible with this concept, and forces the programmer to keep the databases relational.

skore 14y ago
> True. You can also make good programs in PHP* if you "do it right". it's not exactly promoted or encouraged, or even anywhere on the radar though, and doing so involves a fair bit of that relational logic being implemented and enforced in the client. It seems while you see that you're making a concession, you fail to understand that that actually disproves your own point. I repeat: Your argument is invalid. > The point is, it's possible to have a "relational database management system" which enforces the relational axioms for you. People aren't saying that it's impossible - they're saying it's a question of practicality, with the most true to the abstract concept being the least practical in real world applications. > SQL is fundamentally incompatible with this concept, and forces the programmer to keep the databases relational. What? * By the way: Classic case of "doubting, supported by not looking". Even for PHP, there are plenty of resources like http://www.phptherightway.com/ http://www.phptherightway.com/ and they are widely known and shared amongst people who know their stuff.
- TheZenPsycho 14y ago
  There is a difference between "SQL is relational" and "SQL can be used to maintain a relational database". the first is false, the second is true. As for whether it's practical to have a relational database system, are you claiming that it isn't ? Re: PHP. I said that PHP can be used to make good programs. Is this a point you disagree with? or, do you see some other point?