[mythtv] More ideas on PostgreSQL support, comments welcome

[Hamish Moffatt]

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
-- 
Hamish Moffatt VK3SB <hamish at debian.org> <hamish at cloud.net.au>