[MiroDev] Podcasts in Miro Guide
Paul Swartz
pswartz at pculture.org
Fri Aug 22 15:46:34 EDT 2008
On Fri, Aug 22, 2008 at 12:28 PM, Gabriel Burt <gabriel.burt at gmail.com> wrote:
> Hey all,
>
> I think the Miro Guide is wonderful, and the fact it is ran by a
> non-profit with public-service goals is really important. I'd
> mentioned this to Paul and a couple others off-list, but thought I'd
> bring the discussion here. I propose that the Miro Guide expand its
> scope and be a directory for podcasts in addition to video channels.
>
> Paul suggested it could be done as a separate site, but I think it'd
> be great to keep it on the same site and url. To separate the video
> content from the audio-only content somewhat (since some people will
> only want to be looking for one or the other), there could be main
> homepages for each, say http://miroguide.com/video and /audio
I was talking with Dean about this today, and I'm coming around to
supporting audio in the Guide. There's already some support added
because of cobranding partners who wanted podcasts.
(The following will only make sense w/ some knowledge of the Guide
database schema).
----- START DATABASE STUFF -----
Audio feeds are separated from video feeds by having a different
approval state (AUDIO instead of APPROVED). This means they don't
show up in searches or lists of channels except for moderators.
Making them appear in their own list is only a matter of querying the
database for channels with that state. Including them in other views
just means changing queries like "Channel.c.state == Channel.APPROVED"
to queries like "Channel.c.state.in_((Channel.APPROVED,
Channel.AUDIO))"
------ END DATABASE STUFF ------
I'm only really around for another week, but I'll offer as much help as I can.
-p
--
Paul Swartz
Participatory Culture Foundation
pswartz at pculture.org
More information about the Develop
mailing list