RE: [Podserver-devel] Does anyone have a database with the schema (and or any PHP code to pull the details from it) yet?

[Foster, R. - P. <RF...@qu...>]

Tom,

[Side issue... You might want to change the settings on podserver-devel
so replies go to the list instead of the original poster.]=20

I was thinking that the first script would just generate the RSS feed. I
would not bother importing the binary file into the database at this
time, just have the database table include a reference to the file. This
would allow the script to replace Fr Roderick's existing manual
mechanism without any other modifications to his server.

For that reason, I think the first script should be the one that
generates the RSS feed from the database entries. The second script I
think we should work on would be the one to populate the database when
an episode is uploaded.

Before deciding if the binary data should be in the database or as a
standard URL reference I would like to do a bit more research. I would
anticipate that serving the RSS feed will typically take a lot less in
the way of resources than serving the episode files. When a podcast gets
popular enough it may be desirable to have a single "feed" server and
multiple "file" servers. The reason I think that configuration makes
sense is that a database server cluster (again in my limited experience)
will need more care and maintenance than a web server cluster.
Obviously, if a feed gets *really* popular then a database server
cluster could eventually become necessary too.

Regards,
Richard

-----Original Message-----
From: Tom Kent [mailto:li...@te...]=20
Sent: Friday, January 13, 2006 09:54
To: Foster, Richard - PAL
Subject: RE: [Podserver-devel] Does anyone have a database with the
schema (and or any PHP code to pull the details from it) yet?

I wouldn't say completely (as to me being a "design it completely" kind
of guy). I know that no matter how much stuff we think of, more will
come.
However, if I start writing without a great idea of what I want to do, I
always end up making shortcuts that are a pain to deal with later...and
it frustrates me to no end ;-)

Anyway, I'd like to get more user input before we have a "first
release", but if you want to start working on some demo scripts that'd
be cool.

What scripts will we need first?  My ideas:
- Something to generate rss
So call rss.sqpn.com/feed.php?Feedname.xml

- Something to get files
rss.sqpn.com/file.php?FileName.mp3
or
rss.sqpn.com/file.php?FileIDNumber

- Something to upload show and information
production.sqpn.com/upload.php

What are your feelings towards having binary data in a database vs.
filesystem?  I'd still really like to get it in the DB, but I understand
the problem of file corruption.  I'm thinking we should go the DB route,
and add a MD5SUM to the media table.  Then we could run periodic checks
of file integrity.  Would that be satisfactory?

What do you think?
Tom