[mythtv] More ideas on PostgreSQL support, comments welcome

[Tako Schotanus]

Isaac Richards wrote:

>On Tuesday 31 August 2004 05:50 am, David Härdeman wrote:
>  
>
>  
>
>>Does this sound like a better solution?
>>    
>>
>
>Much, much better, thanks. =)  This sounds like something I could live with 
>down the road.
>
>  
>
Are you sure? It seems to me that the moment you hit a "bump" (a MySQL 
feature that isn't easily translated to PostgresQL for example) the code 
becomes a lot more complex. Imagine having to write a small parser that 
parses the original MySQL query to make the required changes.

Not saying that this will happen because I don't know enough about 
PostgresQL to say how much it differs from MySQL but from experience in 
writing query builders for MySQL, MS SQL Server and Oracle I can tell 
you the differences can be quite large and sometimes require queries 
that are quite different to get the same result on the different systems.

All in all I think it is a bit too optimistic to think that you can just 
turn any MySQL query into any other PostgresQL query just by replacing 
some words. (why else would there be the need for query builders in 
database-vendor-agnostic products like Hibernate?).

Hopefuly I'm being too pessimistic and somebody can prove me wrong :-)

Cheers,
-Tako

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-dev/attachments/20040901/ef7f07dc/attachment.htm