3 ms·
Much of the ORM market and NoSQL were precisely because programmers don't understand SQL.
by sitkack 12y ago
Much of the ORM market and NoSQL were precisely because programmers don't understand SQL.
- manicdee 12y agoThat, and typing "select x from table A, table B where tableA.foreign_key = tableB.index and tableA.index=5" is a little long-winded and more prone to error, when you can just do x = ModelA.objects.get(pk=5).ModelB
- chris_mahan 12y agoSELECT B.x FROM tableA A JOIN tableB B on A.foreign_key = B.index WHERE A.index = 5 That's very simple, if you know SQL. I think
- chris_mahan 12y agoTrue that. I use SQL extensively, and never run into all these problems other people run into. I also don't use ORM. there's so much you can do well and fast with SQL. (I've also seen dreadful abominations in sql, like stored procedures that dynamically generate code for pivot tables... wait, that was me who did that)