Changeset 8878814 in Klonkt for src/config

Timestamp:

07/16/2026 12:20:51 PM (8 weeks ago)

Author:

Robin <roboburr@…>

Branches:

main

Children:

2d6a9c3

Parents:

72f936a

git-author:

Robin <roboburr@…> (07/12/2026 11:43:58 PM)

git-committer:

Robin <roboburr@…> (07/16/2026 12:20:51 PM)

Message:

Feature: followers list with delivery health for cleanup

Adds a /followers page (new Fediverse tab) listing remote accounts that
follow you, each with its last SUCCESSFUL delivery timestamp so dead accounts
surface for manual pruning. New ap_followers columns last_delivery_at /
last_error_at (additive migration) are stamped in deliverWithRetry and the
retry-queue worker on success / final give-up. Never-delivered and failing
accounts sort to the top and are highlighted; a Remove button drops the local
follower row after a manual check. i18n added for NL/EN/DE.

Co-Authored-By: Claude Opus 4.8 <noreply@…>

File:

• src/config/database.js (modified) (1 diff)

src/config/database.js

@@ -383 +383 @@
   ensureColumn('ap_timeline', 'reblog_icon', 'TEXT');        //   the booster's avatar
   ensureColumn('ap_timeline', 'poll_json', 'TEXT');          // a Question (poll): {multiple,options[{name,count}],endTime,closed,voters,voted}
+
+  // Delivery health per follower → surface dead accounts for manual cleanup.
+  ensureColumn('ap_followers', 'last_delivery_at', 'DATETIME'); // last SUCCESSFUL delivery to this follower's inbox
+  ensureColumn('ap_followers', 'last_error_at', 'DATETIME');    // last time a delivery to it gave up (max retries)
 }