Which means that it's deflationary against euro or usd. Also "there’s a limited amount of it, the difficulty to mine it goes up as there’s more of it". So according to your definition gold is a scam. I wonder who is going to pull the rug on it.
So gold is a scam? lol
There are plenty of crypto projects which are not get rich quick scams. For example Monero is a community project which allows fully anonymous transactions. Ethereum is quite corporate but they are really working hard to improve the technology, like introducing staking. And there are many more, but it can be hard to distinguish them from the scams. Anyway it's not as simple as crypto bad.
You will have to wait for 0.19 to disable it. Pictrs 0.5 will also add a way to clear old images. See the issue: https://github.com/LemmyNet/lemmy/issues/4053
The activities table is cleared out automatically every week, items older than 3 months are deleted. During the update only a smaller number of rows was migrated so the db temporarily was slower. You can manually clear older items in sent_activity and received_activity to free more space.
Actually Im wrong about images, turns out that all remote images are mirrored locally in order to generate thumbnails. 0.19 will have an option to disable that. This could use more improvements, the whole image handling is rather confusing now.
Yes there is automatic removal so if you have enough disk space, no need to worry about it.
The pictrs storage only consists of uploads from local users, and thumbnails for both local and remote posts. Thumbnails for remote posts could theoretically be wiped and loaded from the other instance, but they shouldnt take much space anyway.
I've changed the screen of a thinkpad from 720p to 1080p. Was cheaper to buy that way, and it was really easy to do.
There is a postgres command to show the size of each table. Most likely it is from activity tables which can be cleared out to save space.
Votes federate with standard Like and Dislike activities which are part of Activitypub. It's just that some platforms like Mastodon can't handle Dislikes.
An Arabic Lemmy instance sounds like a great idea. There actually used to be one but it seems discontinued. Be aware that Lemmy doesnt currently support RTL text, but people are working on it and 0.19 will at least bring partial support.
Wikipedia completely slanders people it doesnt like. For example Daniele Ganser who helped to reveal Operation Gladio.