Files
StarPunk/migrations/025_reply_context_video.sql
PhilandClaude Opus 5.5 952ca300c0 fix: keep GIFs moving in reply contexts (v2.20.1)
Mastodon turns GIFs into silent looping MP4s (gifv); only the first-frame
preview was kept. The MP4 is now saved locally and played muted and
looping with the still as poster. Animated GIFs from other sites are saved
as animated WebP. Migration 025 adds reply_contexts.video and has
fediverse contexts with an image fetched again once.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
2026-11-13 20:28:20 -07:00

7 lines
418 B
SQL

-- Migration 025: Looping videos in reply contexts (v2.20.1)
-- Mastodon turns GIFs into silent looping MP4s ("gifv"); video holds its URL,
-- shown instead of the still preview. Fediverse contexts with an image are
-- fetched again once (no source) so their gifv is picked up.
ALTER TABLE reply_contexts ADD COLUMN video TEXT;
UPDATE reply_contexts SET source = NULL WHERE source = 'fediverse' AND photo IS NOT NULL;