Changeset 7d932ce in Klonkt for src/config/database.js

Timestamp:

06/24/2026 01:24:23 PM (3 months ago)

Author:

Robin Genis <roboburr@…>

Branches:

main

Children:

a885afc

Parents:

cc24fa1

Message:

feat(activitypub): nested threading + delete your own replies

Inbox now stores replies-to-comments nested (findThreadTarget resolves the post
via the parent comment); getInteractions builds a thread tree shown on the post
(fedi-node partial). deliverReply also cc's the post author's inbox so their
Klonkt threads it. Owners can delete their outbound replies (Delete+Tombstone)
inline + via /fediverse manage list. Schema: ap_interactions.parent_uri.

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

File:

• src/config/database.js (modified) (2 diffs)

src/config/database.js

@@ -328 +328 @@
       content TEXT,                         -- sanitized HTML (reply)
       published TEXT,
+      parent_uri TEXT,                      -- the note this reply replies to (for nesting)
       created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
       UNIQUE(kind, post_id, actor_uri, object_uri)
@@ -345 +346 @@
     CREATE INDEX IF NOT EXISTS idx_ap_outbox_post ON ap_outbox(post_id);
   `);
+  ensureColumn('ap_interactions', 'parent_uri', 'TEXT'); // nesting (existing DBs)
 }