For large instances pictures is probably the bigger consumer of space, but for small instances the database size is the bigger issue because of federation. Also, mass storage for media is cheap, fast storage for databases is not. With my host I can get 1TB of object storage for $5 a month. Attached NVMe storage is $1 per month per 10 GB.

For my small instance the database is almost 4x as large as pictrs, and growing fast.

If you have open registration you should reduce the account creation rate.

It runs /e/OS, which is very much a privacy focussed OS.

https://e.foundation/e-os/

I don’t think most people even know honeybees aren’t native to North America. Native bees are the ones at risk, and non-native honeybees aren’t helping.

Don’t delete from the local_user table. You only need to delete from the person table, the rest of the tables will be updated automatically and user count will update automatically.

Edit: The below command will delete all unverified users. NOTE: If you do not have email verification turned on then all users are unverified, therefore all users will be deleted. It also appears with v18 when you enable email verification all existing users remain unverified.

This is a destructive command, use at your own risk and don’t go fucking with the database if you don’t have backups.

DELETE FROM person WHERE local = 'true' AND id IN (SELECT person_id FROM local_user WHERE email_verified = 'false');

In the parenthesis you can add your AND to only select unverified accounts of a certain age.

Looks like my instance got hit with a bot. I had email verification enabled but had missed turning on captcha (captcha enable should be up with enabling email verification settings). The bot used fake emails so none of the accounts are verified, but still goes towards account numbers. Is there really any good way to clean this up? Need a way to purge unverified accounts or something.

It’s a Plex alternative, I don’t know about better. IIRC it’s a fork of Emby. I try both usually a couple times a year, but there’s always something that gives me issue and I just stay with Plex.

Also, seems kind of silly, but the name is just dumb. Neither my wife or I want to audibly say “let’s watch something on Jellyfin”.

Something like Zoho is only $12 a year per hosted email address.

The cheapest CyberPower/APC that is pure sine wave should be just fine.

Sorry guys, it’s because I just bought another domain today. This really sucks, Google Domains was easy to use and cheap.