top | item 42567365

(no title)

CT4u8798 | 1 year ago

I love SQL. I'm not a full-time developer but always use SQL over other abstractions, which I find extremely confusing and way more complicated that plain SQL.

discuss

order

skeeter2020|1 year ago

I'm now firmly into management but the one skill I use very regularly is SQL. By far the best investment I made in my entire career was a little bit of relational algebra, some casual study of DBMS internals and a lot of hands-on SQL. The quasi-standards have also made it the easiest transfer across specific DBs and their flavours over the years.

PSA: Hi kids, here's a dinosaur with yet more free advice: put the tiniest bit of effort into SQL early on and watch the compound interest add up.

threeseed|1 year ago

That's just because it is what you are comfortable with.

Many developers will jump straight for ORMs when given the chance.

dominicrose|1 year ago

Some ORMs have weird design issues. Eloquent for example allows you to pull relationships lazily on single objects, so if you're in a loop that'll create a lot of queries. So much for laziness! I'm OK with this ability, but the API shouldn't encourage it by making it trivial.

Tostino|1 year ago

Which for certain types of applications ORMs absolutely have their use.