so many animals tracks on the snow outside. i spotted deer and cat tracks and some bird as well

gmgm early morning relax time ​:comfymorning:​

#[0] #[1] #[2] yes ​:hypercat:​

#[0] #[1] yea exactly. i ran it once using select instead of delete with interval of 350 days and it still took 20 days for me ​:suicide:​ i have old pc though, sarvo's took 3 days i think

#[0] #[1] the query is

delete from public.note where reactions='{}'

and "renoteId" is null

and "renoteCount"=0

and "repliesCount"=0

and "replyUserId" is null

and "createdAt" <= (CURRENT_DATE - INTERVAL '90 day')

and id not in (select distinct concat("renoteId", "replyId") from public.note)

and "userHost" is not null;

just change the interval to what you want. it doesn't delete local posts and it doesn't delete anything with favorites, boosts or replies

#[0]

#[0] got 0 lines this week and didn't feel like tryharding with the shuffling

#[0]

i was just thinking about the good old livejournal days and how dreamwidth is still a thing. there are some interesting users on there and i wish it had activitypub integration. i looked it up and apparently it's been discussed - https://github.com/dreamwidth/dreamwidth/issues/2337

the maintainers seem to be for it. so if someone wrote the integration they would probably merge it. i hope it happens someday ​:pblobnwn:​

#[0]

#[0] neko feet ​:kannalook:​

#[0]

#[0]

#[0] #[1] thats beautiful. mine just runs away

#[0]

#[0]

#[0]

sending you my healing energy ​:hypercat:​​:dragonsightline:​​:dragonsightline:​​:dragonsightline:​​:ponypanda:​

#[0]

#[0]

waifu posted ff14 its over