One liner to get into postgres:

docker exec -it lemmyca_postgres_1 psql -U lemmy

Show only the instances not updated in past 3 days:

 select * from instance where updated > current_date-3;

Fix those old rows:

update instance set updated = current_date where updated > current_date - 3;

I like it, it's more simple than what I've been using:

curl --silent https://geolocation-db.com/json/ | jq .IPv4 -r

Training data:

OpenWebText2 is an enhanced version of the original OpenWebTextCorpus covering all Reddit submissions from 2005 up until April 2020, with further months becoming available after the corresponding PushShift dump files are released.

https://openwebtext2.readthedocs.io/en/latest/

Thanks for this advice, been adding some communities from there and it's definitely improved things significantly.

Awesome resource, thanks.

Thanks for the description, seems a little counterintuitive to me, but I think I get it now. I removed the allow list and after some time it cleared up quite a bit, also rebooted it and then the "hot" page looked a lot better. I think another issue is that my instance has a pitiful amount of resources and is very slow so it also just takes a long time to get synced up with new communities but it's definitely better now after some days.

This looks pretty cool, I might have to check it out later, thanks. I was a little disappointed that you need to add all the other communities manually to get them on "all". I'm a little worried I need to upgrade my tiny instance before I try automatically adding everything though.