upvote

points

by mightyham7 hours ago |
comments
upvoteby onlyrealcuzzo7 hours ago|
next
[-]
> Learning relational modelling is great, but learning SQL itself, unless you actively have to work with it, is a waste of time.

What a wild statement.

SQL is one of the most useful tools ever developed, as evidence that it's BY FAR the most widely used programming language in the world.

The idea that it is an ABSOLUTE LAST RESORT that should never be used unless you ABSOLUTELY HAVE TO is insane...

reply
upvoteby HelloNurse6 hours ago|
parent|
[-]
Even wilder:

> SQL was not designed for application development, and every attempt to integrate it into higher level programs (ORM, fluent query builders, raw strings, macros/preprocessors) comes with unpleasant rough edges.

Forgetting that interactive SQL queries, and to an even greater degree the underlying databases, are applications.

reply
upvoteby onlyrealcuzzo6 hours ago|
parent|
next
[-]
Anyone who hates SQL typically is completely clueless how hard it is to actually do what SQL does correctly and efficiently.

SQL makes doing something that is VERY hard stupidly easy.

reply
upvoteby Pavilion20955 hours ago|
parent|
prev|
[-]
The issue is that most of these tools try to reinvent the wheel. Instead of using sql, you use 'fluent builders' or whatever, and they have their own tricks and cevats.

Sqlc is the best thing I've personally used because it produces models and repositories based on plain sql queries.

reply
upvoteby onlyrealcuzzo5 hours ago|
parent|
[-]
It's much easier to reinvent one of the most used tools in the world as a far worse version than better.

It's almost as if it was easy to reinvent something highly used that someone would've already done it...

reply
upvoteby hilariously6 hours ago|
prev|
[-]
The point is that you will actively have to work with it. If you are designing data intensive applications without sql you are the exception, not the rule.
reply