[mythtv] More ideas on PostgreSQL support, comments welcome
Isaac Richards
ijr at po.cwru.edu
Tue Aug 31 22:08:12 EDT 2004
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
More information about the mythtv-dev
mailing list