me: 1024 characters will be more than enough to store audio urls from rss feeds

[js@podcastindex.social]

me: 1024 characters will be more than enough to store audio urls from rss feeds

the internet:

https://cdn.masto.host/podcastindexsocial/media_attachments/files/113/454/123/430/296/928/original/c563a350e94cc0ab.png

[dan613@ottawa.place]

@js @DamonHD They crypto sign their URLs?

[js@podcastindex.social]

@dan613 @DamonHD in this case they included an aws "signed url" that expires. it's a way to expose certain files from a bucket without having to make the bucket public.

normally this is done behind the scenes, ie the url in the feed redirects to a temp expiring url at request time

so probably just a mistake

[dan613@ottawa.place]

@js @DamonHD Ah, thanks, an interesting implementation feature.

[dave@podcastindex.social]

@dan613 @js @DamonHD I think the index is even less at 768 because that is the longest an mb4 varchar column index can be.

[js@podcastindex.social]

@dave @dan613 @DamonHD

curious what you do for overflows. truncate? trim query params? skip insertion?