helpers mat • Now • 0%

Can I delete unused items from storage?

I'm behind on releases, I'm still on 2022.06. One thing preventing me upgrading is that I need to make a full backup for upgrading, but my database has blown up in size. For me, the new storage table is pretty unfamiliar. But it seems to me that there's a lot of unused data there. Everything in storage must be either a photo or an attachment - right? I have 191433 rows in `storage`. I have 127206 rows in `photo`, and just one in `attach`. And it seems that the remaining rows are using 12GB, about half of the space of the whole DB: ``` MariaDB [friendica]> select count(*), sum(octet_length(storage.data)) from storage left outer join photo on storage.id = photo.`backend-ref` where photo.id is null; +----------+---------------------------------+ | count(*) | sum(octet_length(storage.data)) | +----------+---------------------------------+ | 63459 | 13781405163 | +----------+---------------------------------+ ``` Am I right that I could just delete those rows (except for the single row in `attach`)?

helpers mat • Now • 0%

Bot for Friendica/ActivityPub

For running some tests on my test instances, I'd like to have a bot. I'd like a command line that can run on a cron job and which makes a post with some kind of dynamic text content, with the URL of the post on stdout. Ideally also: * Have the post include an image * Have the post be a reply to another post with a specified URL * Option to wait for a new post from a specified user, with the post being a reply to that post * Authentication via username/password passed on command line * Nicer authentication options available Does anyone have any experience with / recommendations for such a bot?