sgarland

20 ms·

301.
by sgarland 9mo ago
What exactly is the point of a manager if they’re just passively receiving information from their reports? I long for a flat org structure.
302.
by sgarland 9mo ago
This is my every day, and I’m not at a FAANG. It is horrifying and infuriating at how much could be improved, and how much cost could be cut like that if there wasn’t an absurd amount of internal politics, and we had a high-trust environm
303.
by sgarland 9mo ago
The ORM isn’t the performance issue here, it’s the DB. DISTINCT is a form of GROUP BY, and so it brings with it the various limitations imposed by the RDBMS. For example, look at what MySQL requires to use an index to perform a GROUP BY. 0:
304.
TIL about rare, a CLI aggregation visualization tool(github.com)
2 points by sgarland 9mo ago|1 comments
305.
by sgarland 9mo ago
I've needed to make histograms in the terminal occasionally, and I've always reached for Python to do so. This is so much easier - pipe data into it, filter as desired, visualize.
306.
by sgarland 9mo ago
Not discussed in TFA: BRIN indices. For the given date example, they would be perfect - if you can guarantee that whatever you’re indexing is monotonic, they’re a godsend. Tiny and performant.
307.
by sgarland 9mo ago
Last year, I bought a MBP with both screen types (at the recommendation of an Apple employee - they said just return the one I didn’t like) and compared them side by side for a few days. I also spent some time in the Apple Store, looking at
308.
by sgarland 9mo ago
I mostly agree with you, with the exception that VMs are fully isolated from one another (modulo sharing a hypervisor), which is both good and bad. If your K8s cluster (or etcd) shits the bed, everything dies. The equivalent to that for VMs
309.
by sgarland 9mo ago
I’d recommend making a Zapier integration. That alone unlocks a ton of additional automations.
310.
by sgarland 9mo ago
How is a proper PK choice a high level of optimization?
311.
by sgarland 9mo ago
Disagree, though in practice it depends on the query, cardinality of the various columns across table, indices, and RDBMS implementation (so, everything). A simple equijoin with high cardinality and indexed columns will usually be extremely
312.
by sgarland 9mo ago
Also, anything under 16 vCPUs generally has baseline / burst bandwidth, with the burst being best-effort, 5-60 minutes. This has, at multiple companies for me, been the cause of surprise incidents, where people were unaware of this fac
313.
by sgarland 9mo ago
Manufacturers are selling what their market wants. It sucks. Ironically, the Honda Ridgeline - long lambasted as “not a real truck” - can fit a 4x8 sheet of plywood, at least width-wise. You’ll have to either prop it up on the tailgate, o
314.
by sgarland 9mo ago
> Stupid internet circle jerks about stopping distance are not the pain point or performance bottleneck for the average user. Uh, it should be? The ability to confidently stop is far more important than to go. If you can’t get going, you
315.
by sgarland 9mo ago
I remembering driving in a near-blizzard in Connecticut one night (got caught out in it; this wasn’t on purpose), and feeling like this explanation was the only one that made sense. I had a Pontiac G6 at the time, which was a fairly boring
316.
by sgarland 10mo ago
Unfortunately for the application I was looking at using rqlite for, the possibility of data loss - however remote - was not an acceptable trade-off.
317.
by sgarland 10mo ago
To anyone reading this and assuming it applies equally to electrical conduit, it does not, which is why the NEC specs a maximum of four 90 degree bends between pull points. You could probably manage five, as was described, but it is technic
318.
by sgarland 10mo ago
AKA boy butter [0]. 0: http://www.electricalslang.com/Slang/boy%20butter
319.
by sgarland 10mo ago
OK… there are some exceptions where it makes sense. In the web dev world, though, the overwhelming majority of cases I’ve seen it used are along the lines of “we don’t know what we might need later,” AKA “either product didn’t adequately sp
320.
by sgarland 10mo ago
Thanks for the reply. Yeah, that’s the talk I was referring to. I suppose I could try my own benchmark out tbf. I’m curious to see what it can do on today’s hardware. I would think it’s mostly network-bound for Raft consensus, though the 10
321.
by sgarland 10mo ago
Have you done any updated benchmarks on maximum supported writes/sec since the talk you gave comparing single-zone, single-region, etc.? I recently had a potential use case for this, but it required somewhere around 600 writes/sec
322.
by sgarland 10mo ago
I am personally offended by [0]. Maybe you should spend some time doing proper data modeling when you design your app, and maybe adding a new column should be a painful exercise. Haphazard schema is the quickest way to develop terrible pe
323.
by sgarland 10mo ago
Do you know how many CI/CD pipelines run on shell scripts? Another example is small utilities. I wrote one to login to MySQL DBs at work. We have to use Teleport, which I dislike, and it has MFA. So I made a small SQLite DB that has cl
324.
by sgarland 10mo ago
It’s more that tired experience has taught that of the various disciplines, web devs are the most likely to have a shaky-at-best understanding of fundamentals, and thus do silly things like assume network calls will never fail, or store eve
325.
by sgarland 10mo ago
Jail time [0] and billions of dollars in fines is “nothing much?” 0: https://apnews.com/article/volkswagen-germany-diesel-emissio...
326.
by sgarland 10mo ago
The last time I tried to run Tachyon: The Fringe was Windows 10, and it failed. IIRC I could launch it and play, but there was a non-zero chance that a FMV cutscene would cause it to freeze. I see there are guides on Steam forums on how to
327.
by sgarland 10mo ago
Does Word not default to switching all typefaces - header, footer, etc.? If so, IMO that’s a bad design that violates the principle of least surprise.
328.
by sgarland 10mo ago
I remember in the mid ‘00s having a 19” that did 1600x1200 at (I think) 85 Hz. Damn thing was a tank, but I loved it. So crisp.
329.
by sgarland 10mo ago
That, and everyone thinks they have to do things this way, so it’s a terrible cycle. So many problems would be solved if service calls were IPC instead of network calls.
330.
by sgarland 10mo ago
You can hand out chunks of sequential ids from a central coordinator to avoid collision; this is a well-established pattern. Re: natural keys (or something like it), I was using it as an example of how badly PK choice can impact performance

More ›