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

My friend, you haven’t heard about Oracle.

Microsoft at least gave the world Powershell, to balance out their sins. I can also name other good things they have done. Oracle is pure and deliberate evil.

I believe that the human race will end in one of three ways:

• asteroid strike
• disease
• Oracle

I think you were merely being pedantic, but there are some interesting points in there.

Is it a crime to generate fake “csam”?

Should it be a crime?

How can prosecutors get convictions against a defense of “no, your honour, that video is AI-generated”?

What we have now is still miles off general AI, but it’s going to take years for society to catch up. Interesting times.

Another Kagi fan here. I pay $10 a month.

I’m a reasonably heavy search user, but have never hit the quota.

It’s wonderful to have relevant results again.

The one thing it doesn’t work for is shopping. From time to time I use Google. I should probably switch that to Bing, as the lesser of two evils.

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

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.

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.

state controlled company

Umm. Do you mean Tencent? They have a minority holding. The idea that China actively controls reddit is hard to reconcile with the amount of content that is critical of China. Or let me know what you mean, if not that.

has censorship from a party

What censorship, what party? Do you mean t_d being shut down? Because a better explanation of that would be that the majority of civilised people finally had enough of the nasty chumps in that hole, and good riddance to them. Or let me know what you mean, if not that.

It turns out that setting up an Internet social arena is really hard. They have existed for decades, and the core mechanics and content policy make a big difference in the vibe of the communities that arise on it. What may work initially then becomes toxic. It’s very hard to predict where you’ll end up once the Eternal September kicks in.

It’s not a solved problem at all!

Poof! That’s the sound of 20 million fundamentalists vanishing because you pointed out the existence of Brazzers

Do you think that’s relevant? I don’t see anything about either reddit or lemmy that makes it harder for right-wingers to join. I can tell you that America does not have a monopoly on the alt-right (AfD, Brexit, etc)

I’m keen to learn more if you’ve seen evidence in this topic. I wouldn’t know how to investigate, tbh.