Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
sgarland
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
4 ms
·
31.
▲
by
sgarland
1mo ago
They have what amounts to an unlimited budget for AI spend. If it’s so fantastic, why can’t they let it crawl over every piece of their codebase, every metric, every log, and spot these problems before they occur? “We misconfigured a sideca
32.
▲
by
sgarland
1mo ago
Serious question: do you think your 6 year old is learning coding from prompting an AI? I have had excellent results from using AI, but it’s only because I understand what it is I’m asking it to look at, and know when it’s wrong. This is pr
33.
▲
by
sgarland
1mo ago
I guess I just don’t see the point for most applications. If you’re using a DBaaS, as most are, object storage from the same provider is almost certainly going to be cheaper, and it’s a trivial amount of code to handle the separate push &#x
34.
▲
by
sgarland
1mo ago
> case-insensitive Tbf you can also achieve this in Postgres, it's just not present by default. From the docs [0]: CREATE COLLATION ignore_accent_case (provider = icu, deterministic = false, locale = 'und-u-ks-level1'); 0:
35.
▲
by
sgarland
1mo ago
They're also massive.
36.
▲
by
sgarland
1mo ago
"Work with" != "work well." GIN indices aren't the same as B+tree, and even then, you'll have to decide / know about jsonb_path_ops vs. the default operator class. Or you just accept sub-optimal performanc
37.
▲
by
sgarland
1mo ago
MySQL will generally run fairly well with default tuning, assuming you've sized the buffer pool well relative to the amount of RAM you have (cloud providers do this automatically, but it's also not that hard to calculate). There a
38.
▲
by
sgarland
1mo ago
The primary reason to avoid doing so is avoiding thrashing your buffers, along with increased size of backups, WAL bloat, etc. Can you? Yes. Should you? Not at anything beyond a toy scale, unless you want to pay for more RAM to ensure that
39.
▲
by
sgarland
1mo ago
I’ve not noticed a mushy feeling on my wife’s Mazda CX-9 with CC2s, but tbf it’s an SUV. One of the sportier SUVs around, but still. For reference, I used to daily a Honda S2000 (not with CC2s, obviously).
40.
▲
by
sgarland
1mo ago
I truly wish that Oracle wasn't so aggressively hostile WRT licensing enforcement, because its DB capabilities are insane. I've never operated it, but all the docs I've read are legitimately impressive. I support getting paid
41.
▲
by
sgarland
1mo ago
From TFA: “The nice thing about boringness (so constrained) is that the capabilities of these things are well understood. But more importantly, their failure modes are well understood.” Boring technology is that where you have an extremely
42.
▲
by
sgarland
1mo ago
I think calling anything in the JavaScript ecosystem “mature” is a bit of a stretch. This is the same community that brought us left-pad.
43.
▲
by
sgarland
1mo ago
Unfortunately yes. I would realistically pay about $10K for a MicroOxide rack, because that’s what I can justify spending on what is essentially a hobby. I know that’s never, ever going to happen.
44.
▲
by
sgarland
1mo ago
Really? That’s awesome! I’ve never bothered to use it, because GSuite is right there, but I will definitely keep that in mind.
45.
▲
by
sgarland
1mo ago
Tbf trying to position things in Word is enraging. I get the appeal of having an explicit grid.
46.
▲
by
sgarland
1mo ago
You can do horrifying and amazing things with Excel. Samsung’s Austin fab, at least circa 2020-ish, was generating machine labels with it. These are paper cards, roughly 2” x 4”, which carry the following information: * Machine name /
47.
▲
by
sgarland
1mo ago
Montessori. My kids’ school has kindergarteners solving trinomials [0]. My kids learned multiplication and division by 3rd grade. They’ve also memorized powers of 2 up to 2^20, but that was more me telling them about exponents one day, and
48.
▲
by
sgarland
1mo ago
Because hardware is cool. I’m personally of the opinion that everyone who works in software should have to rack a server and bootstrap it. Physically mount it, cable it, and get the *nix distribution of your choice running on it, serving He
49.
▲
by
sgarland
1mo ago
As someone who works in fintech, I assumed the same; alas, I was wrong.
50.
▲
by
sgarland
1mo ago
Your analogy to baking makes no sense. At best, compiling would be like putting a cake in the oven. Making the cake is coding. > ovens are non-deterministic Uhhh… no? Modulo calibration drift, they will get to and hold a commanded temper
51.
▲
by
sgarland
1mo ago
I, for one, am extremely happy that electricians and plumbers have to be licensed.
52.
▲
by
sgarland
1mo ago
That is the correct mentality, but sometimes, you’re wrong. I found (not entirely true; someone else [0] found it first, but my report from my company got traction [1] on it) a weird bug in ProxySQL several months ago involving mirroring an
53.
▲
by
sgarland
2mo ago
Hiking — in mountains in particular - is magical. I’ve yet to do more than an overnight backpack, but every time I’m out, I’m so at peace. The only explanation I’ve come up with is that mountains are massive, immovable forces of nature that
54.
▲
by
sgarland
2mo ago
The selected topic (chip manufacturing) is being presented at a shallow level at best. Go read Wikipedia’s article [0] and see how deep and broad the topic is. It also skips quite a few steps, and utterly glosses over how insane of an accom
55.
▲
by
sgarland
2mo ago
That's how Postgres' (and perhaps others) MVCC works, yes. MySQL / InnoDB, however, updates tuples in-place [0], and uses the undo log to recreate older versions as needed. 0: https://dev.mysql.com/doc/re
56.
▲
by
sgarland
2mo ago
> Can this really be too much lock contention for a single database row? When you consider how many other (often poorly-crafted) DB queries and service calls are being performed while holding the row locked, yes, it can rapidly add up. I
57.
▲
by
sgarland
2mo ago
> If you mean "deploy the next version gradually, slowing rolling more traffic to it": this puts an upper bound on deployment velocity Yes, that’s the point. I have never, not once, seen a place that emphasized high development
58.
▲
by
sgarland
2mo ago
As an SRE / DBRE, I hate FFs because it means I can be lulled into a false sense of security when something I saw didn’t initially fail, only to start doing so the next week. Just use canaries, I’m begging you.
59.
▲
by
sgarland
2mo ago
No, as others explained, it was “you owe us $X if you quit before $DATE.” IIRC, they had a few models to choose from, with different amounts of time required. The Pentium III was, I think, a 3 year commitment; a Celeron was I think 2 years.
60.
▲
by
sgarland
2mo ago
I had forgotten about their start being in Iowa! I moved to Nebraska (just outside Ponca, actually) in 1996, so I missed that part of their history. Moved away in 2004. Agreed that Ponca State Park is delightful. I spent many a summer day t
More ›