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>
7 lines
418 B
SQL
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;
|