Dr Brian of London (Dev)🖥 on nostr

Can someone with a working podcast index querying system tell me something?

Roughly how many active podcasts have riverside.com or riverside.fm in their feed URL?

Adam Drago · 6w

Assuming Opus guided me correctly, I’m seeing 9278/422303 in the last 90 days Based off querying https://public.podcastindex.org/podcastindex_feeds.db.tgz and I’m not sure how current that is ``` SELECT COUNT(*) FROM podcasts WHERE (url LIKE '%riverside.com%' OR url LIKE '%riverside.fm%') AND...