sgarland

25 ms·

511.
by sgarland 1y ago
You forgot to split out collections.namedtuple and typing.NamedTuple. I love Python to death, but will readily admit that in no way is there “one obvious way” to do things.
512.
by sgarland 1y ago
Markup languages should support TUI / plain terminal, because many people still use that as their IDE. If I can’t pipe a file around to standard *nix tooling, it’s not a good format.
513.
by sgarland 1y ago
Tangential from a discussion in TFA about GraphQL: > One benefit of GraphQL was to solve the “waterfall” problem of traditional REST APIs by allowing clients to ask for multiple pieces of data in one query. For example, instead of making
514.
by sgarland 1y ago
> cannot express a whole application Not with that attitude: https://docs.postgrest.org/en/v13/index.html Orphaned rows can very much matter for data privacy concerns, which is also where I most frequently see
515.
by sgarland 1y ago
> (VAR)BINARY Close [0]: (VAR)CHAR BINARY, which is its own type, uses the `_bin` collation for the column or table character set. (VAR)BINARY stores binary strings, and uses the `binary` character set and collation. In fairness, the amo
516.
by sgarland 1y ago
So perfect for most web dev companies, then. “We handle FKs in the app for flexibility.” “And how many orphaned rows do you have?” “…”
517.
by sgarland 1y ago
> Are they implying these other companies lacked knowledge and expertise to put their databases on machines with NVMe storage? Have you worked at any web dev companies? Of the ones I’ve been at, precisely one had any desire to run their
518.
by sgarland 1y ago
This is cool, but the entire “OMG you can’t leak timestamps” has always reeked of security theater to me, as has the argument that if you expose sequential IDs, you’re opening vectors of attack, exposing business information, etc. Add some
519.
by sgarland 1y ago
This is very cool. I love the idea of querying the state, and it opens up a ton of very easy reporting options.
520.
by sgarland 1y ago
Man, I’m flying into SFO next week. Wish this was already available; I’d take it in a heartbeat.
521.
by sgarland 1y ago
This is the difference, and why we can never understand each other. I couldn’t care less how much customers like something; what matters to me is if it’s technically perfect. This is also why I will never be happy at any job, because it tur
522.
by sgarland 1y ago
The same is true everywhere in tech, I swear. "What if we abstracted away X?" My dude, you're already operating on like five levels of abstractions, and you haven't the slightest clue how any of them work. The answer isn
523.
by sgarland 1y ago
I made the mistake of updating my phone, and immediately regretted it. We tried Liquid Glass already, it was called mid-aughts Windows. It sucked then, and it sucks now.
524.
by sgarland 1y ago
Granted, I wasn’t into Arch at the time, but in the mid-aughts, Gentoo’s forums were a massively useful resource for Linux knowledge in general. That’s why I used it, anyway. The joy of getting an obscure sound card (Chaintech AV-710) to wo
525.
by sgarland 1y ago
But definitions can and are proven false. I hate it, mind you, but I can’t ignore it. For example, the usage of “literally” as an intensifier, e.g. “I literally died of laughter.”
526.
by sgarland 1y ago
SQL has CASE statements, if you’d really like to have all branching logic in pure SQL.
527.
by sgarland 1y ago
Welp, that’s it. That was the last thing MySQL had that Postgres didn’t (modulo clustering index, which OrioleDB does, soooo…). Can’t wait!
528.
by sgarland 1y ago
I am thrilled that anyone in the web dev community is giving a shit about performance, and clearly knows something about how a computer actually works. I am so, so tired of the “who cares if this library eats 100 MiB of RAM; it’s easier” at
529.
by sgarland 1y ago
People always say stuff like this, and I just don’t buy it. It’s not that hard to analyze network traffic to see what does and doesn’t have active connections. When you’re relatively certain, shut it off for a week. If no one screams, delet
530.
by sgarland 1y ago
With that model, your cost doesn't change, though. When/if you find you need more resources, you can (if you haven't been doing so) audit existing applications to clear out cruft before you purchase more hardware.
531.
by sgarland 1y ago
It’s a lot easier if they tell you what they need when you’re designing the schemata. Unfortunately, IME this isn’t done, and so you wind up with tons of bolted-on attributes later, throwing any hope of normalization out the window.
532.
by sgarland 1y ago
Precisely my thought. I love argparse, but you can really back yourself into a corner if you aren’t careful.
533.
by sgarland 1y ago
There are multiple ways to do just about anything, in any programming language.
534.
by sgarland 1y ago
The only reason this post has any truth is that the IMDB dataset is horrendously unnormalized. It also points out at the end that you can in fact use a combination of aggregations to return the desired JSON object. Even then, if you really
535.
by sgarland 1y ago
TIL that a. This system existed b. The author’s need for emulation is what drove ld-decode to support extraction of VBI from Laserdiscs. I and the handful of other weirdos capturing Laserdiscs thank you!
536.
by sgarland 1y ago
Oof, sorry.
537.
by sgarland 1y ago
For sure, things can and will go wrong. For critical services, I’d want to split them up into separate racks for precisely that reason. Re: power strips, thanks for the reminder. I’m usually diligent about that, but forgot about one my wife
538.
by sgarland 1y ago
That’s why they have self-tests. Learned that one the hard way myself.
539.
by sgarland 1y ago
Yep. I know people will say, “it’s just a homelab,” but hear me out: I’ve ran positively ancient Dell R620s in a Proxmox cluster for years. At least five. Other than moving them from TX to NC, the cluster has had 100% uptime. When I’ve need
540.
by sgarland 1y ago
That’s because 75% (citation: wild-ass estimate) of tech workers are incapable of critical thinking, and blindly parrot whatever they’ve heard / read. The number of times I’ve seen something on HN, thought “that doesn’t sound right,” a

More ›