[mythtv] More ideas on PostgreSQL support, comments welcome

[Isaac Richards]

On Tuesday 31 August 2004 09:45 pm, Mike Benoit wrote:
> Disclaimer: I'm not familiar with MythTV code at all, but I have
> experience with projects that are mostly database independent.
>
> Dynamic query re-writing is just a bad idea, it shouldn't be difficult
> to make the SQL queries portable. It may take some work initially if
> MythTV has used a lot of non-standard MySQL'isms, but after that is
> done, writing portable SQL queries isn't hard at all.

Read what he wrote - He wasn't talking about dynamic query rewriting at all.

> The hardest part about supporting multiple databases is almost always
> schema creation/updating. Updating usually being the most difficult. A
> possible solution is to use the XMLSchema (http://adodb-
> xmlschema.sourceforge.net/docs/ ) library that comes with ADODB.

No additional dependencies.

Isaac