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.

Way too few mentions of Jitsi.

I use it with friends, it has good server config, and I’m pushing it on businesses.

To attract more people to the follow ups

Pictures prove that protests were big and non-violent

Many things, too many to even remember.

Very bad SQL implementation is a good start, still bad replication support (compared to Postgres), various bugs present for too long…

https://www.sql-workbench.eu/dbms_comparison.html this comparison is a bit out of date, but explains a lot

Postgres is far superior in every way.

We used MySQL (and Percona XtraDB) servers at work, and it is so bad. So I made several presentations showing generic and specific reasons why Postgres is better. I had to cut a lot of content because MySQL is just that bad.

Some things may not seem relevant now, but as you keep the DB around long enough, you will appreciate the whole package of Postgres.

Things that will help a lot, but are extensions:

• pg_partman - for automatic partition management
• patroni - management of replicas, automatic failover - it does everything for you with simple commands

There is a DB comparison matrix, but hasn’t been updated in over a year, which is a shame, but still gives you the idea of how different databases support SQL features: link.

Spoiler: postgres has the most support, with a huge lead

Edit: MySQL is dead last, btw

Unfortunately not

Yeah, no surprise there, I found it only by pure luck, but suckless has been my jam for over a decade.

There already is a browser named Surf, and has been for two decades.

Yes, there is/was a setting for that, should be on by default.

How is the development of LXD?

I am a huge fan of LXC, but I hate random daemons running (so no Docker for me). I have been looking at the Linux Container website, and they mentioned Canonical taking LXD development under its wings, and something about no one else participating apart from Canonical devs.

So I’m kind of scared about the future of LXC and Incus. Do you have any more information about that?

I have VMs on my metal, one specific for containers.

Though I use LXC. Docker started with LXC, then grew bigger, and I don’t like how big it is.

If I can set up one simple NAT and run everything inside a container, I don’t need Docker.

Docker’s main advantage is the hub.

‘Created by LHC’ is the best one here