[mythtv] More ideas on PostgreSQL support, comments welcome
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
Hamish Moffatt VK3SB <hamish at debian.org> <hamish at cloud.net.au>
More information about the mythtv-dev