this post was submitted on 19 Oct 2023
1714 points (98.8% liked)

Programmer Humor

32557 readers
406 users here now

Post funny things about programming here! (Or just rant about your favourite programming language.)

Rules:

founded 5 years ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 2 points 1 year ago* (last edited 1 year ago) (1 children)

I use an external mechanical keyboard exclusively.

Ok, just went to my work machine and I guess you're right. If you hit the caps lock key quickly it doesn't register. Don't know why I never noticed, I am a software engineer. The ai writes all my SQL now though, so...

[–] [email protected] 2 points 1 year ago* (last edited 1 year ago) (1 children)

Then be happy you naturally hit the caps lock key slowly enough to have never noticed this. When flipping back and forth between caps lock in SQL it drives me up the wall.

https://www.reddit.com/r/macbook/comments/o6q52c/mba_m1_caps_lock_key_delay/

To be clear though, I never noticed either until I started writing SQL regularly. It never causes me problems when writing regular code

[–] [email protected] -3 points 1 year ago (2 children)

Seriously though, why are you writing your own SQL still? It's the language LLMs are the most accurate at translating English into. Like, the most insane inline aggregation, nested transaction nonsense; it just does it for you if you describe what you want and it knows your schema.

[–] [email protected] 5 points 1 year ago (1 children)

It doesn't know the schema nor can it due to the sensitivity of the data I work with. It's also faster to write the SQL than to describe it to the LLM. Once you get used to it, SQL is easier than English.

[–] [email protected] -1 points 1 year ago

You can keep it private. And if you think you're better than it you haven't tried it. You can name the statement, and it will figure out what you want.

[–] xmunk 2 points 1 year ago

It depends on the SQL. Anything non-trivial is still much better to write by hand to keep the intent clear.