By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,418 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

Multi RDBMS Support

P: n/a
Considering a project which will target DB2 UDB on Linux as the primary / suggested platform, but also support MySQL and/or PostgreSQL as our project is GPL so it would be "slightly" rude then to
require a licensed database to even "kick the tires"... but then DB2 does rock!

Anyway, considering that focus, the database class we develop will handle making the correct connection based on the RDBMS configuration. For DB2 it will connect via CLI (from C++ and PHP) and use
appropriate interfaces to the other RDBMS's we support. This class will need to modify the SQL based on the back end, and that is my specific interest with this post. DB2 could be doing fancy stored
procedures for us, but that means more drastic SQL customizations between RDBMS's. If we try to stick to SQL capabilities which the RDBMS's all support, then of the subtle differences which do exist
is there any suggested tools or documentation to aid in customizing the SQL for each RDBMS... or maybe like a matrix of the SQL language and check boxes for which RDBMS's support each aspect of the
language.

Basically open to suggestions for how others have handled making an application work with multiple RDBMS's and yet take advantage of enhanced features which might even be unique to one RDBMS.

Thanks!

--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

Remove the upper case letters NOSPAM to contact me directly.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Michael Lueck wrote:
Considering a project which will target DB2 UDB on Linux as the primary /
suggested platform, but also support MySQL and/or PostgreSQL as our
project is GPL so it would be "slightly" rude then to require a licensed
database to even "kick the tires"... but then DB2 does rock!


With MySQL, you should definitively pay attention to some things that are
handled in a quite err... strange way:
http://sql-info.de/mysql/gotchas.html

--
Knut Stolze
Information Integration Development
IBM Germany / University of Jena
Nov 12 '05 #2

P: n/a
That looks like a very good list, and covers both MySQL and PostgreSQL a bit, thanks!

--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

Remove the upper case letters NOSPAM to contact me directly.
Nov 12 '05 #3

P: n/a
Knut...

Holy Smokes! Strange is the very word I would use for this list...Oh
my.

Bruce

Knut Stolze wrote:
Michael Lueck wrote:
Considering a project which will target DB2 UDB on Linux as the primary /
suggested platform, but also support MySQL and/or PostgreSQL as our
project is GPL so it would be "slightly" rude then to require a licensed
database to even "kick the tires"... but then DB2 does rock!


With MySQL, you should definitively pay attention to some things that are
handled in a quite err... strange way:
http://sql-info.de/mysql/gotchas.html

--
Knut Stolze
Information Integration Development
IBM Germany / University of Jena


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.