@straceX

Computer Architecture, Semiconductors, Systems Programming & I care about what the hardware actually does.

Joined June 2024
SQL has taught me that relationships are complicated, commitment is permanent, and you should always have a rollback plan.
5
10
5
78
1,537
Strace retweeted
Linus Torvalds was asked why he named his software "Git" a British insult for an unpleasant person. "I’m an egotistical bastard, so I name all my projects after myself." "First Linux, now git."
24
75
13
2,516
100,110
Strace retweeted
SQL is weird because the language looks almost like English until you try to explain why the query needs three LEFT JOINs and a window function
SQL syntax feels like it was designed by someone standing across the room SELECT THIS FROM THAT WHERE THIS ORDER BY THAT OKAY I HEARD YOU
5
38
2
946
25,169
SQL is weird because the language looks almost like English until you try to explain why the query needs three LEFT JOINs and a window function
SQL syntax feels like it was designed by someone standing across the room SELECT THIS FROM THAT WHERE THIS ORDER BY THAT OKAY I HEARD YOU
5
38
2
946
25,169
Interviewer: Your app announces "First 100 orders are FREE." At midnight, 1 million people hit "Order." How do you choose exactly 100 winners when your servers can’t even agree on what time it is?
32
5
2
151
10,891
In 1991, Linus Torvalds announced he was building a free operating system. "Just a hobby, won’t be big and professional like GNU." It was Linux.
7
5
6
56
60,106
Strace retweeted
An ORM lets you write user.orders without knowing SQL. Knowing SQL becomes important again when you write it inside a loop.
5
3
2
20
835
An ORM lets you write user.orders without knowing SQL. Knowing SQL becomes important again when you write it inside a loop.
5
3
2
20
835
Docker really said "what if works on my machine became the machine"
3
3
3
20
1,232
Strace retweeted
the funniest part is millions of developers now type git 100 times a day without knowing they’re technically insulting someone
Linus Torvalds was asked why he named his software "Git" a British insult for an unpleasant person. "I’m an egotistical bastard, so I name all my projects after myself." "First Linux, now git."
3
4
3
19
2,033
Linus Torvalds was asked why he named his software "Git" a British insult for an unpleasant person. "I’m an egotistical bastard, so I name all my projects after myself." "First Linux, now git."
24
75
13
2,516
100,110
HR: do you have experience with C++? ME: yes i am very familiar with the 'goes to' operator
19
25
11
798
29,593
Him: Types just slow me down. I cast everything to void pointers and let the runtime sort it out. Move fast, break things. long pause... Her: Cool. Him: What do you write? Her: C++ static analyzers.
2
10
2
515
15,303
macOS: what if you paid significantly more to be told you’re using it wrong?
Linux is free if you don’t value your time. Windows is paid and still doesn’t value your time.
4
2
1
17
1,148
spending 3 days configuring a typescript ORM so you don't have to write a 4-line SQL query is peak modern web development
19
23
3
413
11,177
The backend team said "raise a ticket" and the frontend team took it so personally they created an entire ecosystem that both teams now have to maintain.
GraphQL exists because getting the backend team to add three fields to an endpoint was harder than inventing a query language.
5
2
2
30
2,171
GraphQL exists because getting the backend team to add three fields to an endpoint was harder than inventing a query language.
45
160
25
3,589
124,836
SQL Joins explained for normal people: INNER JOIN: Mutual match on Tinder. LEFT JOIN: You liked them, they ignored you. RIGHT JOIN: Psychopath behavior, just use a Left Join. FULL OUTER JOIN: Hoarding everyone just in case. CROSS JOIN: Swiping right on every single person.
6
4
2
27
1,431
SQL is wild: 1. You write declarative English. 2. The optimizer builds an algebraic execution tree. 3. The Volcano engine fires tight C loops pulling records up pointer chains. Every query you execute is just a desperate mathematical attempt to dodge disk page faults and survive L1/L2 cache misses.
19
18
3
662
124,500
SQL is funny because you can spend 40 minutes making a query readable and then the query planner looks at it and does whatever the fuck it wants anyway
6
6
3
56
22,331