[mythtv-users] Can postgresql be used with mythtv?

[Isaac Richards]

On Sunday 22 August 2004 12:25 am, John Goerzen wrote:
> On Saturday 21 August 2004 8:49 pm, Scot L. Harris wrote:
> > I did some google searches but did not come up with a definitive
> > answer to the question of using postgresql with mythtv.
> >
> > I am currently collecting information on what it takes and how to
> > setup a PVR system.  Trying to decide on the hardware required and
> > figure out what software to use.
> >
> > The mythtv project looks pretty good.  From what I have read it
> > appears that mysql is used.  I would prefer to use postgresql if
> > possible.
>
> I agree, but I believe it is tightly coupled to MySQL.  I've had some
> problems with MySQL having corrupted tables after a hard crash.
> (mysqlcheck has almost always gotten things back to working order, but
> still... PostgreSQL has NEVER done that to me.)

The largest thing that makes myth 'tightly coupled' to mysql is it tells Qt to 
load the mysql driver.  Other than that, I'm not aware of anything that would 
prevent the useage of postgres.  There may be a few queries that need 
modified, but I doubt it would take much effort.

I have no interest in spending my time making myth work with other DB backends 
- apparently no one else who professes an interest in running other DBs cares 
all that much, either.  I've not seen a single person even look into it, 
aside from the occasional question on the lists.

Isaac