Unpopular opinion?: without wordpress, mysql/mariadb would have died years ago.

I just usually do !map

I am currently in the market for a new mobile phone. The current’s one battery is basically dead and because of security patches now being about 2 years old I have to replace it whole instead of just getting the battery replaced again.

Pixel with GrapheneOS has been my number one choice for some time but…

1. there is no (privacy friendly & legal) replacement for Google Play Protect. My banking app won’t work without it as well as one other app I kind of need too.
2. I am also just too used to having a phone in the 250-300 EUR range in the sense that I don’t have to care about it that much.
   It’s a “consumable” product for me. Loosing/drowning it is not a big deal, where drowning 800 euros is just hard to justify no matter how much money I make.

I will probably just get the OnePlus Nord 4 instead because of their pledge to do 6 years of updates.

https://libraryofbabel.info/

I am guessing the closest opposite argument would be how close it is to outright copying the original work?

https://catvalente.substack.com/p/stop-talking-to-each-other-and-start

Blog post (?) from Catherynne Valente about this exact topic

Stop benefitting from the internet, it’s not for you to enjoy, it’s for us to use to extract money from you. Stop finding beauty and connection in the world, loneliness is more profitable and easier to control.

I’ve always been told to be scared about ifs in nginx configs

If your CPU is crashing/unstable then yes, damage is already done, but for the few of us who bought these later just update your bios to the latest one, set intel defaults, do not overclock (I have even undervolted it a bit, but ymmv) and wait for the microcode update.

Though I do wonder if Intel isn’t just stalling for time, I do hope they are not. Didn’t wanna touch my build for next ~5 years.

On point summary.
And I was just about to write that I have confirmed SQLi is not possible to find out I have missed something that might in-turn make it possible! holy hell back to drawing board

Post edited with link to more information.

Ah, you are using pretty different deployment then, even the used postgres image is different then the usual deployment ( pgautoupgrade/pgautoupgrade:16-alpine instead of postgres:16-alpine) this might or might not cause differences.

I would try increasing POSTGRES_POOL_SIZE to 10-20, but I am guessing here, the idea being that lemmy is hammering postgres through the default 5 conns which increases CPU but that is a bit of stretch

do you also have pict-rs connected to this postgres instance? that is surprisingly low number to me, I would have expected anywhere between 20-50 active connections (I use 50 for lemmy and 20 for pict-rs, configured in their respective conf files)

extension “pg_stats_statements” is not available

According to this https://stackoverflow.com/a/72966651/5881796

The extension is not loaded: CREATE EXTENSION pg_stat_statements;

hmm, how many connections are used SELECT count(*) FROM pg_stat_activity; ?
I am not a master postgres admin but my intuition has been that the amount of connections is a big factor in how pg behaves with cpu and mem.

Do you have any tweaks of pg settings? Eg. shm mem, shared_buffers etc. ?

If not you migh want to: https://pgtune.leopard.in.ua/

Afaik you have to replicate the same wave but in opposite “direction” (up/down sinus) to cancel out incoming sound so any anc earbuds have to have microphones and are dynamically shaping the sound.

Registration hooks could be powerful

There are/were two reasons why I did that:

• board manufacturers like to push the juice into the CPU to make benchmarks look good which is dangerous with these power sucking bricks, afaik this might be already patched in recent bioses but I am not risking it/lazy to tweak back
• depending on the CPU piece you might achieve same performance with less power which is my case, I think I have Core Voltage set to something like Adaptive-0.080 which afaik is still pretty tame and the benchmark scores almost didn’t move

The only workarounds that seem to improve stability involve manually downclocking or undervolting Intel’s processors.

Guess that explains why I haven’t had any unexpected crashes yet with stuff like Palworld or Helldivers 2 (afaik both are made in UE). Have been running my 13900kf slightly undervolted.

nope