Hacker News Reader

Much of the ORM market and NoSQL were precisely because programmers don't understand SQL.

True 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)

That, 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

SELECT 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

Reply on news.ycombinator.com