[mythtv] More ideas on PostgreSQL support, comments welcome
Jay R. Ashworth
jra at baylink.com
Wed Sep 1 15:12:54 EDT 2004
On Wed, Sep 01, 2004 at 11:55:39AM -0700, Mike Benoit wrote:
> I suppose you could create your own file format that specifies both
> MySQL and PGSQL specific queries in it for each version and have dbcheck
> parse it. Would you prefer something like that, over multiple files?
>
> My only intention in the above proposal was to separate the raw SQL from
> any code, so it can easily be generated with simple scripts.
>
> I suppose you could just build on the current dbcheck with an extra if
> statement inside the already existing if (dbver == X), like:
>
> if (dbtype == "pgsql")
>
> and specify the queries there.
>
> Seems like more work to me, but I'm just trying to figure out what hoops
> (and how many) have to be jumped through for you to accept supporting
> PGSQL.
>From some IRC chat, and forgive me if I'm misrepresenting you, Isaac, I
gather that if we can abstract the DML helper functions in a
reasonable, maintainable way, he doesn't object to putting some effort
in, going forward, to making sure his queries are non-My-specific.
Which sounds perfectly reasonable to me.
Cheers,
-- jra
--
Jay R. Ashworth jra at baylink.com
Designer Baylink RFC 2100
Ashworth & Associates The Things I Think '87 e24
St Petersburg FL USA http://baylink.pitas.com +1 727 647 1274
"You know: I'm a fan of photosynthesis as much as the next guy,
but if God merely wanted us to smell the flowers, he wouldn't
have invented a 3GHz microprocessor and a 3D graphics board."
-- Luke Girardi
More information about the mythtv-dev
mailing list