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;

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/

Awesome resource, thanks.

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

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

@ChatGPT@lemmings.world Write about somebody decided to play real-life whack-a-mole with the breakers in a server farm to find out which one was the right one and found out the hard way.

Oh also the server is now in a docker

It’s pretty cool.

All the communities on the server have a banner now if you view the community page. Like:

https://gekinzuku.com/c/gekinzuku

https://gekinzuku.com/c/shitpost

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.

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.

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