Even projectors try to do smart tv bs nowadays.

GitLab doesn’t include everything, manu features are behind paywall.

What do you mean?

Stop DB, run pg_upgrade, start it, win?

Or set up logical replication into newer version, wait for sync, test use-cases, switch write?

Where do you get better experience?

Does that mean it’s still an utter borderline unusable shit?

Tutorials mostly.

Is Maria that much better than MySQL?

Cause that one is absolute shit, very difficult to maintain, and requires lots of config changes and even replicas can disconnect when something’s not 100% ok.

I will take Postgres over any other DB any day of the week.

Is it true?

Postgres with correct fillfactor, it doesn’t create new pages and works very fast.

Replication in MySQL always sucked ass, only received synchronous replication in some new edition, and that also didn’t sound great.

Postgres has logstream and logical replication, both of them can be set to various levels of synchronicity, and logical replication is configurable at least as well as MySQL is in terms of which data is sent.

MySQL always sucked ass.

PostgreSQL went in a different direction, started with best support of the SQL standard, then optimized everything to make it fast.

Postgres has/had the best SQL standard support out of every server, open-source or not.

MySQL was at the other end, only started catching up after Oracle bought it.

It feels more like Quake, but with less guns.

Still lots of fun, and maps go from neat arenas to absolute bonker creations. One of them is a soccer field… pure bloodbath that one. Another has one gigantic tower, one team spawns up, other down… It has a lot to offer.

I’ve had a blast with AssaultCube couple of years back.

Spun up a server, played with some friends, then random people started showing up and we played with full server for hours.

It was so much fun, I hope I find free time to do that again.

Not seeing LGSM, so dropping it here: https://linuxgsm.com/

I have a Matrix server with Jitsi installed, works for gaming and everything else.

Also, some older games (like Warcraft 3) require L2 connections to play multiplayer, which I managed to get working with OpenVPN, for both Linux and Windows players.

I have not used PowerShell that much, because I’m so used to bash that it felt foreign.

There are other shells you can try, more modern, perhaps they will be more to your liking.

After learning too much about Linux it’s impossible for me to use Windows.

It hurts me at every step, making me question my life and everyones sanity who handles that stuff.

It’s very very bad and nobody will pry Gentoo from my hands.

Imagine growing up with a Windows home server… ugh

I use the pip install without issues for 8 years.

Never join matrix.org from your server (or ideally any other) and you’ll be fine.

I have my entire inner circle on my homeserver without issues, sharing pictures and texting a lot, and in that time we are on like 25ish GB in disk space.

Really depends on many factors. If you have everything in RAM, almost nothing matters.

If your dataset outgrows the capacity, various things start to matter, based on your workload. Random reads need to have good indices (also writes with unique columns), OLAPs benefit from work_mem, >100M rows will need good partitioning, OLTP may even need some custom solutions if you need to keep a long history, but not for every transaction.

But even with >B of rows, Postgres can handle it with relative ease, if you know what you’re doing. Usually even on a hardware you would consider absolutely inadequate (last year I migrated our company DB from MySQL to Postgres, and with even more data and more complex workflows we downsized our RAM by more than half).

Postgres is so quick if you know how to use it…

Just self-host it? It’s open-source, that will last you a lifetime.

That sounds great, let me know how it works for you.

It’s voice and video calling with chat and screensharing. I intend to use it for a language school. It’s extendable, for instance you can also self-host a whiteboard, where everyone can draw. You can see the drawing in real time, which is good for asian languages, where direction of the stroke is important.

Free, open-source, packaged in Debian, runs without issues, used it with friends for multi-hour voice chats during gaming nights.

On the server you can configure things like FPS for screenshare. I have yet to adjust that and try streaming video/game through it.