Re: [Openpvr-devel] Project update listing?

[Robert K. <rku...@ro...>]

--- "Brian J. Murrell" <5e4...@in...> > 
> Well, it's still being developed.  I am fairly happy with what I have
> going right now, but it's hardly complete.  I have been giving the
> "seen" database some thought.  Right now it's updated manually and
> it's an XML file.
> 
> I don't think an XML file is the right solution however.  A database
> (berkely db perhaps, I dunno yet, opinions welcome) I think is the
> better vehicle.  An XML file would have to be completely read and
> rewritten for every update of the database.

I've been giving the database some thought as well.  I've implemented a perl
program which takes the XMLTV data from tv_grab_na and inserts it into a
MySQL database structure.  I think that this is the easiest way to do the
"heavy lifting" involved with getting a database-driven scheduler
operational, like when users start doing wild-card searches, etc.  

I am currently implementing the "hints" code that will let a scheduler decide
when a particular program has mulitple showings so that in case of scheduling
conflict it's easy to decide which program to defer and when.  This handles
cases where something like "The Daily Show" will have 5 showings of the same
program a day, but the _first_ showing is at 2300EST, M-Th, so a conflict for
the 2300 slot can be filled with a showing that comes after that one.

I'm working with a relational database guru on normalizing the schema.

I'll post code if anyone cares to see it, but it's ugly.  Lots of stuff is
hardcoded to get it working, but it does work at this time.




__________________________________________________
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
http://greetings.yahoo.com/