Multi RDBMS Support - DB2 Database

Michael Lueck

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

Subscribe Reply

1633

Knut Stolze

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

Michael Lueck

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

bwmiller16

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

Similar topics

2107

Database-backed website w/o server RDBMS

by: Matt O'Toole | last post by:

I'm looking for a website backend. I can use PHP and other scripting languages, but I don't have access to an RDBMS. So I'm looking for an RDBMS substitute -- maybe something that reads/writes plain text or XML files sitting on the web server. Any ideas? Matt O.

PHP

1816

Terminology: RDBMS and database server

by: Marek Kotowski | last post by:

I'm preparing short dictionary and this is the question: are 'RDBMS' and 'database server' synonyms? If not, what are the differences? Thanx in advance. Regards Marek Kotowski Warsaw

MySQL Database

125

14711

What so special about PostgreSQL and other RDBMS?

by: Sarah Tanembaum | last post by:

Beside its an opensource and supported by community, what's the fundamental differences between PostgreSQL and those high-price commercial database (and some are bloated such as Oracle) from software giant such as Microsoft SQL Server, Oracle, and Sybase? Is PostgreSQL reliable enough to be used for high-end commercial application? Thanks

Microsoft SQL Server

2523

OODB vs RDBMS

by: Thomas Guettler | last post by:

Hi, most of the time I use ZODB/Durus to store my data. I like it, but I know that it has some weaknesses: - only accesible from python - I need to code your indexes for fast searching yourself. I think about using a RDBMS for the next project. What I don't like about RDBMS: If you need a list of values you need to create a new

Python

4654

multi language site...

by: Aussie Rules | last post by:

Hi, I have a site that Iwant to either display my text in english or french, based on the users prefernces ? I am new to webforms, but I know in winforms, this is pretty easy with a resource file. What is the best way to acheive this with webforms ?

ASP.NET

4938

Multi-targeting (.Net 3.5)

by: bharathreddy | last post by:

Vs 2008 is the MS latest IDE for developing Windows, Web, Smart Device Applications. It comes along with .NET Framework 3.5, C# 3.0, LINQ, ASP.NET AJAX and VSTO . Now with the power of VS 2008 we can target multiple versions of .NET Framework. Installation steps here VS 2008 Multi-Targeting Support: Previously every VisualStudio release supports its own specific version of .NET Framework. That is VS 2002 with .NET 1.0 ...

.NET Framework

1113

Re: Is there no single/uniform RDBMS access API module for Python?

by: M.-A. Lemburg | last post by:

On 2008-05-12 07:43, Banibrata Dutta wrote: Most Python database modules adhere to the Python Database API specification (DB-API). The current version 2 is available in the PEP format as: http://www.python.org/dev/peps/pep-0249/ The spec was created and is maintained by the Python DB-SIG: http://www.python.org/community/sigs/

Python

3498

Cascaded menus and multi-select CheckBoxList

by: dbuchanan | last post by:

There are three parts to this 1.) How do I cascade menus? 2.) And, how do I cascade menus with a multi-select CheckBoxList?

ASP.NET

3395

Multi-threaded C programming (for those fond of portability)

by: =?ISO-8859-1?Q?Tom=E1s_=D3_h=C9ilidhe?= | last post by:

As far as I know, the C Standard has no mention of multi-threaded programming; it has no mention of how to achieve multi-threaded programming, nor does it mention whether the language or its libraries are suitable for multi-threaded programming. For people who are fond of portable C programming, what's the best way to go about multi-threaded programming? I've been reading up on POSIX threads a little, they seem pretty ubiquitous....

C / C++

8478

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8397

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8821

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8670

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

5696

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4225

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

2813

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2052

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1810

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General