this post was submitted on 19 Oct 2023
1725 points (98.8% liked)
Programmer Humor
32718 readers
278 users here now
Post funny things about programming here! (Or just rant about your favourite programming language.)
Rules:
- Posts must be relevant to programming, programmers, or computer science.
- No NSFW content.
- Jokes must be in good taste. No hate speech, bigotry, etc.
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Writing SQL on Mac sucks so bad. I hate their caps lock time out
macOS has a caps lock timeout? The fuck...
capslock drains the battery too quickly
WHY THOUGH
w h u t
please explain
it uses more pixels per inch
eh? lol
Lmao
Timeout was the wrong word. It has to be held for like a quarter second or something like that. It's annoying as hell.
That's even worse IMO. Lol.
Yeah it's even worse when you remote in to a windows machine from a Mac. It has the caps lock annoyance and then the delay on the remote machine will cause the first keystroke after toggling caps lock to not actually know that it needs to toggle, so your sql looks like this
sELECT * FROM Table_name tn wHERE Tn.thing = tRUEWhat? Mine doesn't do that. I've been using Mac's since 2016 when I learned to code, and I've never seen this behavior.
After the user mentioned it , I looked it up. It's all over Apple's supper threads. Hilariously, there's an old reddit thread about it
https://discussions.apple.com/thread/253838180
https://superuser.com/questions/317900/eliminate-macbook-capslock-delay
https://www.reddit.com/r/macbook/comments/o6q52c/mba_m1_caps_lock_key_delay/
It definitely exists. It's far more noticable if you plug a keyboard into your MacBook. There are threads all over Mac forums and stack exchange asking how to disable it.
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...
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
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.
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.
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.
It depends on the SQL. Anything non-trivial is still much better to write by hand to keep the intent clear.