Re: database compatibility

2006-03-22 Thread David Griffiths
That's a pretty difficult request: 1) What versions? MySQL 4.0 has no stored procedures, functions, views, subselects. 4.1 added subselects. 5.0 added the rest. Oracle 8i doesn't support ANSI-style outer joins (they use a proprietary format). 2) Different engines; MySQL supports federated,

Re: database compatibility

2006-03-22 Thread Douglas Sims
I think it's better to pick one database and try to design and code to its strengths and weaknesses. I've worked on several projects in which the overall architectural plan involved writing a database abstraction layer to keep options open as to the specific relational db - MySQL,