Re: A thought about other open source projects

David Goodenough wrote:
>   I don't support anyone has written a "how to write database agnostic
> code" guide?  That way its not a matter of porting, more a matter of
> starting off right.

There is no real way to write "database[-]agnostic" SQL, although of course 
middleware code can and should be.

SQL dialects cannot even agree on simple things like the syntax for VARCHAR 
(VARCHAR2 in Oracle) or the semantics of TIMESTAMP, or what is legal in a 
SELECT.  As Sim Zacks said, "you lose most of the advantages of the chosen 
database engine" if you write to the lowest common denominator, particularly 
as such an LCD is nonexistent.

-- 
Lew