Changeset d18c60e in Klonkt for src/config/database.js

Timestamp:

07/01/2026 06:55:46 PM (2 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

0688b5f

Parents:

43273c9

Message:

feat(fediverse): alt text for images (accessibility → AS2 attachment name)

Media federated to the fediverse now carries a description (AS2 name on the
attachment), which Mastodon shows and screen readers read. The cover gets an alt
field in the editor; inline images keep their own <img alt="…">. Also used as the
cover's on-site alt.

• src/config/database.js — posts.cover_alt column.
• src/services/ActivityPubService.js — buildNote carries alt per media URL (cover_alt + inline <img alt>) and emits it as the attachment name (and on the image fallback).
• src/routes/posts.js — capture/store cover_alt on create/save and pass it to the federation hooks.
• src/services/Scheduler.js — carry cover_alt when a scheduled post goes live.
• src/views/pages/post-edit.ejs — "Alt text (description)" field under the cover URL.
• src/views/pages/post.ejs — the on-page cover <img> uses cover_alt.
• src/services/i18n.js — pedit.f_cover_alt + pedit.cover_alt_placeholder (nl/en/de).
• test/media-alt.test.js — cover alt, inline alt, and no-alt = no name.
• CHANGELOG(.nl/.de).md — "Alt text for images" under Unreleased.

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

File:

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

src/config/database.js

@@ -89 +89 @@
   ensureColumn('posts', 'nsfw',     'INTEGER DEFAULT 0');  // sensitive content → blur + click-to-reveal; fediverse sensitive
   ensureColumn('posts', 'cover_video_url', 'TEXT');        // muted loop MP4 for an animated cover (Safari-smooth)
+  ensureColumn('posts', 'cover_alt', 'TEXT');              // alt text / description for the cover (a11y → AS2 attachment `name`)
   ensureColumn('posts', 'content_warning', 'TEXT');        // custom CW label (empty = default "Gevoelige inhoud")
   ensureColumn('posts', 'type',    "TEXT DEFAULT 'post'");  // post | foto | video | audio