sgarland

24 ms·

361.
by sgarland 11mo ago
If that fails, I assume the user knows enough about their environment to fix it.
362.
by sgarland 11mo ago
> There is no mustache-twirling villain who has a great idea on how to !@#$ people out of their money. I dunno, Aurora’s pricing structure feels an awful lot like that. “What if we made people pay for storage and I/O? And we made
363.
by sgarland 11mo ago
Yes, but when your starter project takes off and you start to get serious traffic, there’s no good path to migrate off. It’s all very manual, and involves a fair amount of downtime unless you have the requisite knowledge to set up logical r
364.
by sgarland 11mo ago
Your options are severely limited for Lightsail; it maxes out at 8 GB RAM and 240 GB storage for a DB.
365.
by sgarland 11mo ago
Except for the DB. The official way to migrate from a Lightsail DB to RDS is to do a logical dump and restore. For MySQL, or if you have a monotonic column in Postgres, that might be doable if you dumped in parallel, but otherwise it’s an
366.
by sgarland 11mo ago
Dude, take it from someone who is mildly autistic, and spent a very long time being staunchly prescriptivist: you’re being ridiculously pedantic, and no one cares. Have a nice day.
367.
by sgarland 11mo ago
From Merriam-Webster: > suburb (noun): > a: an outlying part of a city or town > b: a smaller community adjacent to or within commuting distance of a city > c: suburbs plural : the residential area on the outskirts of a city or
368.
by sgarland 11mo ago
> Nice history lesson that you've written for absolutely no reason… This you? > …originally referring to the portion of an urban area found outside of the wall. The physical walls aren't often found anymore, but the term sti
369.
by sgarland 11mo ago
I absolutely agree, and if my words didn’t convey that sentiment, I apologize.
370.
by sgarland 11mo ago
I do not care.
371.
by sgarland 11mo ago
As a child, I went from firmly middle-class (dad was a firefighter in San Diego, CA) to pretty damn poor (we moved to the middle of nowhere in Nebraska). I joined the U.S. Navy, and got a B.S. while I was in, then an M.S. in SWE afterwards
372.
by sgarland 11mo ago
I don’t think you understand how little some people have. Especially in rural (or really, anything that isn’t urban) areas, where you have to have a car for transportation, because public transit doesn’t exist. Keeping an old car running
373.
by sgarland 11mo ago
There are Americans who have open sewage in their yards [0], because their counties are predominantly Black or Latino, and their state deprioritizes any infrastructure work. It’s structural racism. Even better, the Trump administration canc
374.
by sgarland 11mo ago
> It's pretty terrible how poorly developers test their database queries. Yes. This becomes especially obvious when you rewrite ORM garbage for something complicated, and are told that they can’t accept it, because they’re not sure
375.
by sgarland 1y ago
> I think we have arrived at abstraction over abstraction over abstraction. > The thing is, kubernetes resources are already an abstraction. Your first comment was more accurate - they’re heavily nested abstractions. A container repre
376.
by sgarland 1y ago
Let the FCC enforce the removal of a license, then. That seems to be the current administration’s approach to everything.
377.
by sgarland 1y ago
I’m speaking from a Python background. I love types and use them religiously, but I had no idea how much better (modulo runtime checks; that one’s obvious) others were at it.
378.
by sgarland 1y ago
TIL (via a rabbit hole after reading this) that a good type system removes an absurd amount of boilerplate validation code.
379.
by sgarland 1y ago
I love how dedicated some people are to hacking random things for fun. What a great read!
380.
by sgarland 1y ago
First of all, if you have a dev DB that’s 12 TB, I can practically guarantee that it is tremendously unoptimized. But also, that’s extremely easily handled with physical servers - there are NVMe drives that are 10x as large.
381.
by sgarland 1y ago
It is forever baffling to me that so many devs don’t seem to appreciate that small performance issues compound, especially when they’re in a hot path, and have dependent calls. Databases in particular, since that’s my job. “This query run
382.
by sgarland 1y ago
Please keep doing what you’re doing; I appreciate the effort and mentality.
383.
by sgarland 1y ago
> sure, but the knob existing doesn't solve the operational challenge of safely allocating GBs of RAM on prod for hours-long index builds. How does it not? You should know the amount of freeable memory your DB has, and a rough idea
384.
by sgarland 1y ago
> That kills the indexing process, you cannot let it run with limited amount of memory. Considering the default value is 64 MB, it’s already throttled quite a bit.
385.
by sgarland 1y ago
> The problem is that index builds are memory-intensive operations, and Postgres doesn’t have a great way to throttle them. maintenance_work_mem begs to differ. > You rebuild the index periodically to fix this, but during the rebuild
386.
by sgarland 1y ago
Dumb question from a primarily Python programmer who mostly writes (sometimes lengthy) scripts: if you have a function doing multiple API calls - say, to different AWS endpoints with boto3 - would you be expected to have a different variabl
387.
by sgarland 1y ago
> Generally it's best practice in this case to never delete messages from a SQL "queue", but toggle them in-place to consumed and periodically archive to a long-term storage table. Ignoring the potential uses for this data
388.
by sgarland 1y ago
Postgres’ need (modulo running it on ZFS) for full-page writes [0], coupled with devs’ apparent need to use UUIDv4 everywhere - along with over-indexing - is a recipe to drag writes down to the floor, yes. 0: https://www.enterpri
389.
by sgarland 1y ago
This is so accurate. I’ve looked in wonder at how someone is maxing out an r6i.32xlarge MySQL DB, when I have ran 4x the workload on an r6i.12xlarge. Schema design and query design will make or break your app’s ability to scale without sk
390.
by sgarland 1y ago
Agreed that homelab load is generally small compared to a company’s (though an initial Plex cataloging run will happily max out as many cores as you give it for days). In the professional environment I mentioned, I think we had somewhere cl

More ›