sgarland

9 ms·

61.
by sgarland 2mo ago
Ah, right. Good callout!
62.
by sgarland 2mo ago
> And you won’t get to brag that you own a computer from Iowa. South Dakota. Gateway was HQ’d in North Sioux City, SD. There is also a South Sioux City, NE, though to my knowledge no computer manufacturers have had a presence there. My d
63.
by sgarland 2mo ago
> You "fixed" the incident. You have no idea how. If you don’t know how it broke, and you don’t know how you fixed it, what exactly is it you think you understand about your application?
64.
by sgarland 2mo ago
Until someone gets the bright idea that you should be multi-region.
65.
by sgarland 2mo ago
It is not my responsibility to teach critical thinking and a CS degree to Bob, nor is that in my job description. If Bob can successfully convince our boss and finance team that his solution is necessary, then so be it; I will continue bang
66.
by sgarland 2mo ago
> I totally suck at meetings where the goal of the meeting is to make sure that everyone feels like their voice is being heard. Those are the worst. No, I don’t feel like I need to let Bob feel heard. Bob wants to create a nightmarish st
67.
by sgarland 3mo ago
I will forever love reading or watching Casey dunking on people from so far above that they’re unaware of the delta.
68.
by sgarland 3mo ago
Another fun use of colon: :(){ :|:& };:
69.
by sgarland 3mo ago
So if you built something without the use of an LLM, you’re automatically disqualified now? What a world.
70.
by sgarland 3mo ago
> Even with indexes, joins are costly, especially under load at scale with millions of simultaneous users. You can avoid a lot of this by simply having that sub-table information inside a JSON field with the row in question. They’re real
71.
by sgarland 3mo ago
I have no idea why you’ve been downvoted, as you accurately described EAV. I’m a DBRE who cares deeply about schema design, FWIW.
72.
by sgarland 3mo ago
That’s usually because they’ve seen a lot of failure modes over the years, and what seems fine to you can have surprising outcomes later. My personal experience has been the opposite of yours: lots of data inconsistency issues, data loss on
73.
by sgarland 3mo ago
> I’ve found normal forms to sometimes be at odds with query efficiency and ease of use, which is critical when you’re moving fast—sometimes it’s just easier to dump data into a jsonb column. If you’re a startup, the performance cost of
74.
by sgarland 3mo ago
> monetary budget I’ve never attempted to calculate it, but I’ve always felt that the money lost from major incidents must outweigh the additional engineering time spent doing things right. Of course, that assumes that the engineering sk
75.
by sgarland 3mo ago
> AIs today are far more knowledgable and much quicker than humans, but still missing a few bits that keep them from being broadly super human. Generally, yes, but it’s the non-determinism that gets me. Even easy stuff: I’m currently on
76.
by sgarland 3mo ago
My personal belief is that the most effective leaders do in fact deeply understand the technical side of their business, yes. To be fair, I am biased, because I was previously a nuclear reactor operator on a USN fast attack submarine, and t
77.
by sgarland 3mo ago
If my experience with RDBMS generalizes, I predict that this trend will result in companies hiring skilled developers to unfuck their codebases. Furthermore, I predict they will identify massive structural issues, propose huge lifts to redo
78.
by sgarland 3mo ago
As others have pointed out throughout the thread, the reason we defend the skills is that there’s a high likelihood that these tools will always be available on any machine; PowerShell and nushell, not so much.
79.
by sgarland 3mo ago
THANK YOU. I kept nodding along to all of the xargs comments, thinking “sure, but what about the even easier solution?”
80.
by sgarland 3mo ago
This resonates with me. I’ve always found the term annoying, because it felt like it was distilling artistic expression down to its most abstract form: content. If all you’re producing is abstract “content,” why should I participate? What m
81.
by sgarland 3mo ago
10/10, no notes.
82.
by sgarland 3mo ago
> That loss is real and it's worth naming. Annnnnd TFA is written by AI. I want to get off Mr. Bones' Wild Ride.
83.
by sgarland 3mo ago
> Everything you create should be an artistic endeavour aiming for perfection. Amen. If you go to a bakery, you expect them to care. If you hire a photographer, you expect them to care. Software isn’t (usually) a factory line; CRUD may b
84.
by sgarland 3mo ago
Wait until you read about its quirks [0]. My favorite: “NUL characters (ASCII code 0x00 and Unicode \u0000) may appear in the middle of strings in SQLite. This can lead to unexpected behavior.” 0: https://sqlite.org/quirks.h
85.
by sgarland 3mo ago
> The grandparent comment is just racist. I wouldn’t jump to that conclusion. The concept of low and high-trust societies is well-studied [0], though how a given country maps to it may be disputed. 0: https://pmc.ncbi.nlm.nih.
86.
by sgarland 3mo ago
How people are running any RDBMS in prod — but especially Postgres - and not using a connection pooler with the capability to pause incoming connections is beyond me. The entire “how do we drain connections” issue described in TFA becomes t
87.
by sgarland 3mo ago
This is the only statement I disagree with: > PowerShell gets a lot right with structured data. CLI programs should operate on text. If you want to parse and format it, do so, but the default output mode should be plain text, so that I c
88.
by sgarland 3mo ago
Very optimistic of you to assume that someone who doesn’t understand why DB indices in general are important would care enough to read a detailed explanation about them.
89.
by sgarland 3mo ago
Same. Every time I think about this, I come back to the fact that I was excellent at my job before AI, and even enjoyed aspects of it, so I would be fine if tomorrow it all blew up.
90.
by sgarland 3mo ago
If absolutely nothing else, I applaud the author for manually writing their post — though, of course, the irony of someone using AI to write a post about letting AI die would be incredible.

More ›