Hacker News new | ask | show | jobs
by tgv 248 days ago
Footnote: as long as it's SQL, you stick to hierarchical relations, have enough memory, and can write difficult queries by hand
1 comments

> and can write difficult queries by hand

So now I have to learn an ORM (with some kind of lifecycles, dirty tracking, eager/lazy loading config, etc.)... aaaaand I have to learn SQL as well, because the ORM's abstraction is leaky.

I see some benefits in ORMs for deleting and updating tables. But the benefits are slim and the cost (learning a library that requires understanding of quite a list of additional concepts) are significant. Considering that on-top-of learning the ORM I also need a proper understanding of SQL (for complex t queries or debugging ORM inefficiencies), I'd say it's not worth it.

For many people, it's a gateway to back-end development. You don't have to learn all those weird, ancient tools, you just write a bit of Python. Look at this simple example! And then they get stuck on it.
Exactly. Then you learn SQL when needing complexer queries or more performance.

The result:

https://www.reddit.com/r/Entrepreneur/s/SMqhSBxje7

No indexing ... I can definitely see how that happens.