Re^2: Considering future support for different databases.

I guess I'd always assumed that a cross-db app would have to be optimized for each system unless the database was extremely simple. Does anyone know of any examples of a project that manages to be compatible with several different databases with no special considerations for any of them?

Comment on Re^2: Considering future support for different databases.

Replies are listed 'Best First'.
Re^3: Considering future support for different databases. by Joost (Canon) on Aug 15, 2008 at 20:59 UTC
I'd guess that most systems that use a full-grown ORM library have all the db-specific code in the underlying (and reusable) ORM layer, and when they do use hand-written DB specific SQL, it's only to optimize a few "interesting" JOINs). Note that most ORM layers do rely on some standardization of the database schema (especially concerning naming of tables and columns, and limiting the available column types), but that doesn't mean the schemas themselves are simple at all. "What should it profit a man, if he should win a flame war, yet lose his cool?"	[reply]

Replies are listed 'Best First'.

Re^3: Considering future support for different databases.
by Joost (Canon) on Aug 15, 2008 at 20:59 UTC

Note that most ORM layers do rely on some standardization of the database schema (especially concerning naming of tables and columns, and limiting the available column types), but that doesn't mean the schemas themselves are simple at all.

"What should it profit a man, if he should win a flame war, yet lose his cool?"

[reply]