[mythtv] More ideas on PostgreSQL support, comments welcome

Hamish Moffatt hamish at cloud.net.au
Wed Sep 1 16:44:03 EDT 2004

On Wed, Sep 01, 2004 at 12:27:59AM -0700, Mike Benoit wrote:
> PostgreSQL has many features over and above that of MySQL. Not all would
> be directly useful to MythTV unless MythTV had code to make specific use
> of them. 
> Here are a few off the top of my head:

> - Transactions and sub-transactions (v8.0).

A quick Google shows articles from 2002 describing transactions in
MySQL. I think those would actually be a good idea for making
libmythtv's database schema upgrades more robust. But no need to switch
to PGSQL to get that.

> -* Triggers (for instance, I could write a trigger that moves the .nuv
> file to a NFS/Samba server and replaces it with a symlink once its done
> recording automatically. This would be _very_ nice for myself, then I
> could make use of the 60gb on my second machine)

This doesn't sound like something that needs to be done by the database
engine though.

Hamish Moffatt VK3SB <hamish at debian.org> <hamish at cloud.net.au>

More information about the mythtv-dev mailing list