the translation step from binary (program) -> text (SQL) -> binary (server)

Your concern about this is misguided. Inter-process communication always has to cross a barrier, by definition.

I take it http also feels wrong to you?

Binary protocols do exist, e.g. gRPC, but they incur costs of their own.

Shame I had to scroll this far to find PRQL

Looks like yellow fingers and grey complexion.

I did not find that at all.

I’m sorry you have that - I didn’t. I was quit with no cravings for five years, what got me back in was spliffs with tobacco. (Now I vape, because I do intend to occasionally smoke weed with tobacco.)

The reason you still have cravings is because you never deprogrammed yourself. You still associate gaspers with relief, relaxation, pleasure.

If you can reframe the sensation of smoking as the tense tickly feeling of “god I could use a fag”, which no-one would claim to enjoy, the rest is plain sailing, and within a few weeks you’ll be past any cravings. The bulk of the cravings are done within a few days.

I don’t mean to suggest that it’s easy to quit - most people fail. But the trick is not too withstand cravings for the rest of your life, it’s too break the paradoxical association of fags with pleasure, which is a one-time thing.

It ain’t no joke?

You want to have a superficial little rant about how much you hate microsoft. It’s uninformed and boring, and you’re not going to learn anything in that mindset.

C# is an excellent language for many circumstances. If you knock off the attitude, I’d be willing to explain to you why it’s so widely used.

No. Wind drag on handles is most certainly not negligible. Even small protrusions on an otherwise smooth surface can have a significant effect. That effect is hard to model - you can’t just eyeball it.

Drag is proportional to windspeed squared.

Aero matters to fucking cyclists. It absolutely 100% matters to motor vehicles, especially in the context of EV range anxiety.

Just don’t fucking dunning-kruger, FFS. Surely you realise that automotive engineers have specific education that you don’t have. I don’t mind you being wrong, it’s the arrogance that pisses me off.

That’s a plausible claim. If you find it hard to believe, maybe you should go back to the wind tunnel.

Hmm. I run mine off a usb3 ssd and it’s faster, but still slow.

It’s OK, but I’d suggest:

Atom > arm64 > arm32

I ran on a Pi 4, but switched to a PC for jellyfin. The pi can’t transcode for shit. It was slow to boot and slow over SSH.

Look for a NUC - they’re designed for desktop use, so they have more poke than a Pi. The N6005 CPU is a good choice, the N5105 is ok. These are x64, so you’ll have the widest range of packages. 4GB will do, if its upgradeable later. NUCs usually take SODIMMs, which you can pick up on ebay for peanuts.

Bear in mind that network chipset will be your bottleneck in some use cases. If it has a “gigabit port” but only a cheap chipset, and you use it as a router, you might max out at ADSL speeds… in that case you’ll wish you’d gone for a box designed for soft routing, which are a fair bit pricier.

Pi is not the only SoC, merely the best-known.

I’d earn anyone thinking of buying a Pi for a home server: ARM is widely supported, but you might regret investing in arm32. Atom is a safer choice.

They don’t supply PoE, mind.

I’m planning an ubiquiti deployment:

• 5-6x AP 6 Pro (haven’t done survey yet)
• 1x TL-SG1016PE PoE switch (yuck, but cheap)
• 1x R86S running opnsense and docker VMs, with unifi controller and pihole in docker

The R86S is the same price as the dream machine, but good luck running pihole on the DM.

I considered Mikrotik, but my mum would have to call me every time there was an issue, and it would only be marginally cheaper. I expect any competent local tech to be able to support unifi and opnsense.

There are many similar. The best is GoWin R86S

…or MIPS…

Big fan of Mikrotik, but it helps to have some experience.

Haven’t tried hex, but RB2011 would be my default recommendation, and I’ve seen RB4009 for ~£120 (bargain of the century!)

Excavator in rack-mount enclosure would be awesome

Do what now? Sorry, I’m a frontend developer, I don’t have much experience with C##

Forsooth, this cipher speaketh not in tongues

Of men and servers of this era born;

Unknown and babbling, let this wretch be shunned

And do his SSL connexion scorn.

Yes… YESSS… he’s going to attach the debugOH FUCK IT he’s just ADDED a fucking PRINT STATEMENT instead.

Why can’t I get this programmer to debug?

Ugh, a Magic String (I call it that whatever the type)

FACILITY_MAX_PRESSURES = {
    "Durham": 1000,
    "Ipswich": 500,
    "Calne": 750,
}

max_pressure = list(sorted(
    FACILITY_MAX_PRESSURES.values()
))[-1]

if water_pressure > max_pressure:
    blah

Obviously it should really pull from facility management, but that’s a bunch of moving parts where a constant is how you’d prefer the code to work

Tbh it starts to look better to just define a constant and comment it.