Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

He said better than SQL.


LINQ is a much nicer SQL IME, at least for CRUD operations — but I generally don’t use the “objects” part of it except for very rudimentary insert/deletes.

However group by specifically seems to be a hack, and it falls on its face in weird ways almost every time I use it. I’m not sure how much I like it’s “AST rewriting” model, but it works great when it works. Just the LET command alone justifies it


To me, ORM code is better than raw SQL.

But, a lot many applications can be developed without really knowing the depths of SQL with help of the ORM itself.


Is it? All that's ever worked for me with ORMs are simple CRUD apps that don't require referential integrity. We currently need to support one built on Django/ORM where this isn't the case and e.g. deleting an object can require deleting thousands of others.... which the ORM helpfully renders into thousands of queries and can take you half an hour. Luckily the creators soon decided to switch off all timeouts....


I have had amazing luck with Prisma.io on the oracle side




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: