[mythtv] Database helper functions and pgsql support

[Fernando Vilas]

I was finally able to finish testing, and submitted a patch (ticket 215) to implement database helper functions and add support for PostgreSQL.  I know I said it would be here last weekend, so sorry for the delay. 

The Postgres support is alpha, because there are still a few things to do, and it has not been tested beyond running my mythtv box for the past week.

Still remaining to do:
 - Keywords are not stored in the db, why not?
 - mythfilldatabase is SLOW because of lack of support for "insert ignore" forcing the use of "in" clauses.  There has to be a better way.
 - mythfilldatabase does not update channel information, such as the name and FCC id of the channel, but does store the programs.

I'm sure more issues will be seen, but the above are relatively minor.  If you choose to use Postgres, a simple dump and restore from a MySQL database will not work, so you'll be starting over in Postgres.  Also, remember that Postgres has case-sensitive strings, where MySQL does not, so capitalization of keywords during searches is important.

-- 
Thanks,
Fernando Vilas
fvilas at iname.com