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

[Tom K. <li...@te...>]

Here's the reply I didn't send correctly.
-----Original Message-----
From: Tom Kent [mailto:li...@te...]=20
Sent: Friday, January 13, 2006 8:54 AM
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=20
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

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

Hi Tom,

Ah! I take it from that you still subscribe to the "design it completely
first" school of development. I'm more in line with Martin Fowler's
views (see http://martinfowler.com/articles/newMethodology.html for more
details if you're unfamiliar with them).

I think we do have at least the first part of what is needed. A
mechanism to generate the RSS feed, including a behind-the-scenes
database from which the information is pulled. Once we have that, we can
add the second part from your roadmap - the "upload" screens.

In my experience most people find it *extremely* difficult to visualize
what they are agreeing to unless they see a demonstration. I'm thinking
that if we get a proof-of-concept script ready people will find it
easier to see what we've missed!

Regards,
Richard

-----Original Message-----
From: Tom Kent [mailto:li...@te...]=20
Sent: Friday, January 13, 2006 09:20
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?

Nope, I was hoping to get some more consensus before we started.  I'd
really like to flush out all the ideas and make sure the design is up to
snuff before we start writing code.  It only gets harder to go back and
change stuff once you start with code.
Tom


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log =
files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id=16865&op=3Dick
_______________________________________________
Podserver-devel mailing list
Pod...@li...
https://lists.sourceforge.net/lists/listinfo/podserver-devel