*grunts* I should not have read SA so fast (according to the receipt, it’s exactly month and two days).

Thank you both @SkybreakerEngineer@lemmy.world and @Nighed@sffa.community for the explanations.
I feel like one of the ten fools!

I will have to read it all again. Seems I’ve missed some key details in both MB and SA as I have hard times connecting some of the stuff you have mentioned to what I am pretty sure I should already know.
Also should have read SA in my native language.
And and should have read Mistborn: Secret History …

On the bright side, now I don’t have to worry what to read (the whole) next year, will probably wait for WaT to release in December and start with everything again. Thanks again though!

I’ve been using FX File Browser for the occasional need to share stuff localy - it opens a local web server where you can browse files on the phone.
Though it’s not foss and I am afraid that functionality is behind the plus version.

Great wizard of the bitrates, grant me your wisdom…

I can’t wrap my head around bitrate - if I have a full hd monitor and the media is in full hd then how is it that the rate of bits can make so much difference?
If each frame in the media contains the exact 1920 × 1080 pixels beamed into their respective positions in the display then how can there be a difference, does it have to do something with compression?

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/

Thanks!

Thank you for asking! Yeah, I am reading Stormlight Archive by B. Sanderson and their communities seemed to contain most memes specific to the lore haha

also RawTherapee

MAS is open-source meaning anyone with the skill can verify what the powershell code does. This does not mean it’s absolutely safe and trustworthy but does give it a big plus.

(the way I understand it is that) It also uses a loophole in the free upgrades from older win versions to 10/11 to get you a valid license from Windoze servers directly - it is not a keygen or cracker.

So, I will vouch for MASgrave but care has to be taken to download it from the official site/repository.

In what part exactly?
The example is not perfect I can see that myself. If I read into it too much there could be an overlap with concurrency, e.g. the (IO) tasks awaited & delegated to the OS could be considered a form of concurrency but other then that I do think it’s close to describing how async usually works.

Steam is close but actually not electron, they use CEF - Chromium Embedded Framework which is something Electron uses too under the hood (afair)

Matter of time, good while it lasted

Happy cake day !

Oh interesting I will have to look how tessaract does it

What a dumb way to do image proxying.

This is about proxying external images, URL rewrite won’t work unless the image is also downloaded and hosted by the instance (which seems even worse for many reasons).
Or am I missing something here?

https://i.imgur.com/dAB5Dii.jpeg