[mythtv] DVB support - Status update

[Joel Feenstra]

I don't know what's wrong with doing it the way that codec params does 
it. A loop isn't hard to do, and allows for easier addition of new 
tuning parameters and so forth. But whatever, I don't care too much. 
That's just how I would do it.

Joel Feenstra

Andy Davidoff wrote:
> That example uses an extra copy of the table for each additional
> field you wish to include in the final results.  You'd have to know
> how many attributes existed and their order and craft the query
> appropriately.
> 
> Do you really think this is more elegant than just using a separate
> table that is structured to hold each of the extra variables?  We'd
> get the benefits of fixed-length records, data-types designed for the
> data the column is storing, indices on specific attributes...
> 
> Take a look at the SQL I wrote to improve the queries for programs
> plus recordings in MythWeb/functions.php -- it demonstrates the
> kind of ugliness that can arise from shoehorning one-to-many into
> one-to-one.
> 
> 
> On May 02, at 20:06, Joel Feenstra encoded a 1.2K recording:
> 
>>I think your best bet is looking at the mysql section on join.
>>
>>http://www.mysql.com/doc/en/JOIN.html
>>
>>there's a user comment about student's grades and assignments that
>>might be some help.
> 
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at snowman.net
> http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-dev
> 
>