News for hackers. Stuff that matters.

A comment on Running 10M PostgreSQL Indexes in Production. Parent comment

Re:Running 10M PostgreSQL Indexes in Production by collyw on Tuesday June 13, 2017 @09:08AM (#14544430)
As someone who uses Django more or less full time, I don't think relying on the ORM without knowing any SQL is especially good advice.

Django's ORM is very easy to use, but it is not especially powerful, and when you want to do advanced queries (multiple join conditions for example) it often isn't possible. When someone asks me for some data from the database, usually its easier for me to go directly to the database than use the Django ORM.

Use the ORM to start with, but its most definitely a good idea to learn proper SQL .

[ Parent | on HN ]
Re:Running 10M PostgreSQL Indexes in Production by pas on Thursday June 15, 2017 @09:57AM (#14560382)
ORM is very much like hypermonadic supertemplate C+++++ type theory, you can only play with it if you know what you're doing, but don't want all that boilerplate (cognitive or in-code unit tests) in your head.

So, I think starting with PHP and raw SQL is a good thing for motivated learners.

And if you need motivation, try building a WordPress site with themes and plugins first. And maybe an Android app. And then something cute like a LED blinker with a raspberry.

[ Parent | on HN ]