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,

I agree that there should be no need for a manual FTP operation. It was
certainly never my expectation that there should be. Uploading the file
could (relatively) easily be accomplished from the same web page as the
entry of the feed-related information. The original file name, and the
name used after uploading may not (and probably wouldn't) be the same.

Yes, if the files are available as "plain mp3" files out on a server (or
server cluster), there is no requirement for your second script. (That's
another reason for considering it, since it would mean less "code" to
maintain). It would not break the "central reference" concept since
information about the location of all the files would still need to be
in the database so the RSS feeds could be generated. It does have the
downside that if the files are moved manually (as opposed to through any
script we provide) then the references would end up broken.

Why reinvent the wheel with the "Remote Podserver"? MySQL (at least) can
handle having copies of the database in multiple locations natively
through database replication. (Note: I have not investigated if partial
replication is possible, or if it is only possible to generate a full
replica. I would be surprised if partial replication is not possible).
Similarly there are already well designed and widely available
clustering solutions for web servers. I have not investigated them, but
I believe it should even be possible for listeners to "donate" server
space effectively acting as a full or partial mirror of the primary
site. Fr Roderick's server would effectively act as a manager,
redirecting listeners to the appropriate mirror locations.

Regards,
Richard