On Sun, Aug 03, 2003 at 03:19:50PM -0400, Joe Stump wrote: > I think I'm going to build something with a MySQL backend that allows > people to always record a show at a specific time on specific days. My > thinking is that this will require Apache+MySQL along with a scripting > language (I'm proficient in PHP so I may go that route) - this side > project would also require a alternate plugin for scheduling shows that > put data into the MySQL database instead of the current flat file > structure.
MySQL is so mismatched for this purpose, the majority of the features that it has do not lend itself to what we're doing. > Any other ideas? I'm interested in being able to schedule shows that are > on every day (Seinfeld for instance) without having to schedule them each > morning when I wake up, which is how it currently works with Freevo AFAIK. In the short term, you can use tvgrep in helpers/ to do that: tvgrep -schedule Seinfeld >> freevo_record.lst In the long term, Rob has been working on a record daemon, and I'm intending to move more of the TV stuff into sqlite. sqlite doesn't require a daemon, and looks just like a flat file, so setup is trivially easy. On top of that, it's faster for most query operations than MySQL. It also supports more SQL92 than MySQL, like foreign keys and subselects, so it's possible to have a much more efficient and normalized database. Aubin ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 _______________________________________________ Freevo-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/freevo-users
