[mythtv] More ideas on PostgreSQL support, comments welcome

[Jay R. Ashworth]

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