• 1 Post
  • 15 Comments
Joined 1 year ago
cake
Cake day: June 30th, 2023

help-circle







  • Actually all the instances were from lemmy.world. lemmy.world just removed some recently for some reason (unknown to me) and I havent removed them from my list yet. I normally just sync the lists every now and again. I dont have any personal views, i just pull the list from lemmy.world and let them decide. If there is a difference it was because eith er my list is slightly out of date by a few days, or the bot script found something ans was run at a different time than they ran it. Essentially I dont host any content so there isnt much to moderate, thus my views are largely irrelevant.




  • You font make any communities and clear the database of cached content thats no longer needed after reasonable amount of time (as its hosted on the other instances the data came from) eg: PGPASSWORD=password psql --dbname=database --username=username --command=“DELETE FROM activity WHERE published < NOW() - INTERVAL ‘7 days’;”

    Does stop top month or top year since you dont have data going that far back. Obviously if you keep it then you need more disk space, memory and so on and so on.