I made some good progress on ActivityPub compliance this week. The main task that’s left to do is correctly discovering URLs for inbox, shared_inbox etc on remote instances, which I will finish next week. Then it might actually be possible to federate with other software.
Besides helping to prepare the
v0.9.0 release, this week was mostly bug fixes.
ListCommunitiesendpoint, in order to filter by
6 months. This is much more useful than the subscriber count for showing how active a community is. These are re-saved every hour.
hot_rankfunction seem to de-grade over time, due to me incorrectly defining it as immutable. Re-indexing periodically fixes the issue. Not having an index here isn’t an option: the indexed query is <
20ms, while the un-indexed is >
2s. I’d def like to hear some ideas on other ways to do this, because it doesn’t seem like postgres can officially handle indexing any time-based function.
activitytable is a copy of all incoming activities, and is the largest table. Added a task to periodically clear out activities older than 6 months.