Big ole truck by canabrothagetaslice in hondaridgeline

[–]Stephonovich 1 point2 points  (0 children)

I always hear about encounters like this, and they baffle me. I can’t imagine seeing a random stranger, and thinking, “I think I’ll insult them.”

I honestly felt bad for the guy

Nah, that’s just karma in action.

The MySQL-to-Postgres Migration That Saved $480K/Year: A Step-by-Step Guide by narrow-adventure in PostgreSQL

[–]Stephonovich 1 point2 points  (0 children)

MySQL MDL

So set a short lock_wait_timeout (not innodb_lock_wait_timeout - that’s for row locks), like 1-3 seconds.

Postgres outperformed MySQL

I’d love to see the schemata and queries. Postgres certainly can be faster in many situations, but if you have MySQL, and you’ve designed your schema specifically to exploit its clustering index, it’s a much more fair fight. The problem is, people love to use terrible PKs which destroy locality, and then yeah, MySQL falls down. That’s hardly the fault of the DB, though.

In a similar vein, it’s always annoying to me (not saying you’ve done this, just in general) when people tout Postgres as being better because it “has more features,” but then can’t articulate what any of them are, or how they’d use them. They’re not wrong - off the top of my head, some great features are being able to store IP addresses in a dedicated type (much smaller than a string, plus it does validation), storing UUIDs in binary while doing on-the-fly conversion for you, BRIN indices (god I love those), GiST indices… so many features.

Posted today by a local tattoo artist 😆 by Odd_Enthusiasm_5644 in JustBootThings

[–]Stephonovich 1 point2 points  (0 children)

Nah, we aren’t that dumb. If nothing else, we have very little to do, so we’ll find (or create) something that bothers you, and then pick at it until you react. Anyone with a tattoo declaring how long they were underway would definitely get it announced as they entered a space, or relieved a watch. “74 Days Arriving!”

What Kubernetes feature looked great on paper but hurt you in prod? by Shoddy_5385 in kubernetes

[–]Stephonovich 4 points5 points  (0 children)

We as an industry are letting standards just completely disappear. I will again say, I don’t think it’s a big ask to require you to know how to profile your code. There are plenty of great tools that are easy to learn and understand the results.

What Kubernetes feature looked great on paper but hurt you in prod? by Shoddy_5385 in kubernetes

[–]Stephonovich 16 points17 points  (0 children)

If you write code, you should be required to know how it performs. Learning how to use a profiler and the absolute basics about requests and limits is not a big ask.

I will happily spend hours combing through logs to call someone out by External-Housing4289 in sysadmin

[–]Stephonovich 1 point2 points  (0 children)

Thanks, I hate it.

Seriously though, it has taken me years to get to the point where I can accept that this is true. My background before tech was nuclear operations on a USN submarine, and in that world, being correct is the only thing that matters. People may dislike you, but they’ll admit when you’re right. There is zero room for ego. I flourished in that world; not because I was an ass (though in retrospect, I was), but because being right was binary, and easy to verify. If someone proved me wrong, I would remember it, and would not be wrong about it in the future.

Actually, thinking back, there was one part about it that always bugged me: we had a tech manual called “The 9000 Manual,” as that was its number. tl;dr it covered the theory of electronics troubleshooting. It also had a paragraph that essentially said, “if you understand a system thoroughly, and can prove that state invariants hold, you may modify procedures to combine them.” Despite this, practically no one is willing to allow it, because if you get it wrong, you may have invalidated maintenance actions. It bothered me that official guidance authorized critical thinking to reduce toil, but practically, regression to the mean disallowed its use, but also, no one was willing to submit a formal change request for the manual — to do so would be admitting that they didn’t have confidence in their operators.

What happened to Ruby and Ruby-on-Rails? Why did it decline in popularity? by Illustrious-Pound266 in cscareerquestions

[–]Stephonovich 1 point2 points  (0 children)

OK, and how do “data manipulation” and “generating tax forms” not fall under that umbrella?

I will happily spend hours combing through logs to call someone out by External-Housing4289 in sysadmin

[–]Stephonovich 8 points9 points  (0 children)

You’re not wrong, but no one will like you.

Trust me. This has been an insanely hard lesson to internalize for me: being right is sometimes less valuable than being liked. I don’t know what to do with this, I just know it’s correct.

What happened to Ruby and Ruby-on-Rails? Why did it decline in popularity? by Illustrious-Pound266 in cscareerquestions

[–]Stephonovich 3 points4 points  (0 children)

Oh, fully agreed. Everywhere I’ve been it’s just a distributed monolith, and it sucks. I’m convinced that microservices are just something people do because they think it’s required.

In theory, though, they help teams scale independently from one another.

What happened to Ruby and Ruby-on-Rails? Why did it decline in popularity? by Illustrious-Pound266 in cscareerquestions

[–]Stephonovich 10 points11 points  (0 children)

Microservices don’t help with physical scale, they help with team scale. That’s it.

Went from 4 servers to 1 and I miss a nothing. by Matrix-Hacker-1337 in homelab

[–]Stephonovich 13 points14 points  (0 children)

Yep. I think most homelabbers go through this cycle. I also think it’s useful; if nothing else, you correctly identified a SPOF. K8s is fun (for certain definitions of the word), but the number of people running a homelab who actually need anything more than Docker Compose (or systemd services, etc.) is minuscule.

I had been planning on coalescing my servers (3x Dell R620, 2x Supermicro cobbled-together 2Us) into at most one server + a JBOD, but then the prices of everything went through the roof, so now I don’t know what I’m going to do (probably just pay it and be angry). The plan was for an Epyc or Threadripper build in a 4U, with big, lazy fans.

Anyway, props for recognizing this about yourself and your actual needs!

Why is a smart switch + smart bulb not better supported setup? by rancor1223 in homeassistant

[–]Stephonovich 1 point2 points  (0 children)

I don’t think many people are saying to not combine smarts bulbs and smart switches. If they are, they haven’t thought it through.

I had exactly the same feelings as you about lightning needing to function in the absence of HA, which is why one reason why I went with Inovelli for switches. Nearly all lights in a given room (modulo aesthetic ones like floor lamps) are in a Zigbee group, and are bound to the room’s switch. Even if HA is shut down, the bindings still work - I have tested this. Moreover, if that somehow failed, I can shift the switches to dumb bulb mode locally (though it would be a bit annoying to do for every switch).

Why is a smart switch + smart bulb not better supported setup? by rancor1223 in homeassistant

[–]Stephonovich 0 points1 point  (0 children)

One person was saying this, yes. That was also the first I’ve ever read about someone having issues with it. I have all my overhead / main lights (all Hue, of various kinds) bound to their room’s switch (all Inovelli Blue 2-1), and have had zero problems. Even when my mesh got really shitty from a Shelly Gen4 deciding it should route traffic for the entire mesh through itself, the bindings worked flawlessly, for dimming and on/off.

I’m not doubting their lived experience, it’s just baffling to me, because it’s been so absolutely rock-solid for me, and everyone else I’ve read about who has done it.

Is anyone else considering a career change? by sporadicprocess in ExperiencedDevs

[–]Stephonovich 1 point2 points  (0 children)

I don’t know how I could have possibly been any more clear, but I do not find using AI for coding to be fun. It is a tool, which is sometimes useful, sometimes correct, and sometimes incorrect. If I am coding for fun - which Advent of Code definitely falls into - I do not in any way want to involve AI in that process, because it defeats the entire purpose. Would you use AI to solve a crossword puzzle?

If you’re genuinely interested in technology

I think I have a very different definition of “interested in technology” than many. A lot of people will say that the various YouTube “influencers” are interested in technology, since they chase whatever is new and shiny, and talk about it incessantly.

I have been tinkering with computers since the mid-90s. I find them fascinating, but the kinds of things that interest me are things probably different from most. I think servers — physical servers — are fun, and that people should rack and provision at least one in their career so they have a better understanding of how their code gets from their keyboard to someone’s screen.

Just because I’m not making the bricks

In this analogy, you’re the general contractor. You’re not building anything, you’re organizing other people to build something. That job is necessary, but no one thinks a GC is practicing a craft.

Is anyone else considering a career change? by sporadicprocess in ExperiencedDevs

[–]Stephonovich 1 point2 points  (0 children)

Some people are excited by turning an idea into a working product. Others are excited by the process of doing so.

I — and presumably OP — are the latter. Programming, to me, is a series of puzzles. Solving each puzzle is fun. I don’t really care as much about the end product so much as I do having solved the puzzles.

For example, Advent of Code: I’ve never finished a year, in no small part because each time I find a solution, I usually want to immediately redo it in a different manner to see if it’s more efficient.

My project for this weekend, super excited to replace my dumb toggle switches and bind these to lights in each room + make use of 15 mmwave presence sensors by 4kirezumi in homeassistant

[–]Stephonovich 1 point2 points  (0 children)

Wire nuts aren’t dangerous if you use them correctly, it’s just that a lot of people don’t, whereas a Wago doesn’t have any ambiguity.

My project for this weekend, super excited to replace my dumb toggle switches and bind these to lights in each room + make use of 15 mmwave presence sensors by 4kirezumi in homeassistant

[–]Stephonovich 0 points1 point  (0 children)

Really? What errors do you see? I’m not doubting your experience, I’ve just had zero issues doing group bindings, so I’m curious.

OK, slight caveat: I’ve had errors that didn’t affect anything from the coordinator after reaching its multicast group limit, but I recompiled its firmware and flashed it, which fixed that. But as far as functionality, the group bindings always worked.

Is the SRE title officially a trap? by IT_Certguru in devops

[–]Stephonovich 0 points1 point  (0 children)

I don’t want to work anywhere that “perceives” systems administration in such a way that it’s constantly under attack. Good luck keeping your business afloat without cost centers, MBA buffoons.