Fountain 0.3.0 is now live!
⚡Optional Email Login
⚡Navigation & Design Updates
⚡Faster Podcast Syncing
⚡Audio Download Bug Fix
Nevermind, I *think* this index will do the trick for us, but I'm going to ask a friend who is more of a db expert to review it later today.
Postgres question: if I want to efficiently do a query on a large table like:
... WHERE column1 IS TRUE AND column2 IS TRUE ORDER BY column3;
I apparently need a composite index. I have only used 2 columns in composite indexes before though. In this case, should I make a composite index of all 3 columns?
The new Podverse is BRILLIANT for sharing 3speak clips!!! https://twitter.com/brianoflondon/status/1472245659763884032?s=21 @mitch
Could this be a situation where we need a compound index? We need postgres to quickly find all "hasVideo IS TRUE" podcasts, and also quickly return them sorted by "pageViews DESC"...but I guess there are 2 indexes we would need there, so could a compound index help?
Castopod v1.0.0-alpha.78 is out! 🚀
(Minor bug correction)
Any Postgres experts out there who can see what is wrong with this query that is causing it to hang forever?
I ran an EXPLAIN on it but I don't know what I'm looking at 😬
@Medus reported that ActivityPub comments were not loading for Fun Fact Friday with Leila and David in Podverse.
The AP socialInteract handling i currently based on the data returned by Podcasting 2.0's socialInteract url, but FFF returns a different structure that P2.0.
The P2.0 CollectionPage endpoint returns an array of Note items, but that same array in the FFF CollectionPage endpoint returns an array of URLs that point to Note items.
Anyone have advice on how to handle these differences?
@agates @js in case you're curious here is the ActivityPub proxy endpoint I setup https://github.com/podverse/podverse-api/blob/develop/src/routes/episode.ts#L67
Comments are live on Podverse.fm 🎉
This feature uses the Podcasting 2.0 socialInteraction namespace. If an episode has an official ActivityPub comment thread, then a Comments section will appear underneath that episode.
Sample page: https://podverse.fm/episode/K3Tyh_IxB
Coming soon to the mobile app!
@dave I added a read-only implementation of ActivityPub comments to the Podverse website...but when I deployed to production, the browser fails when requesting the JSON status endpoint with a CORS error :[
I was working around CORS errors during development with a browser extension, but I thought maybe in prod there wouldn't be a CORS issue.
socialInteraction URL: https://podcastindex.social/users/dave/statuses/107384394041738991
Intended for all stake holders of podcasting who are interested in improving the eco system