|
|
Posted by Jerry Stuckle on 06/06/05 00:07
Gary L. Burnore wrote:
> On Sun, 05 Jun 2005 14:49:24 -0500, Jerry Stuckle
> <jstucklex@attglobal.net> wrote:
>
>
>>Gary L. Burnore wrote:
>>
>>>I'm aware of many good database independent apps. Sorry you've not
>>>had the same experience. Having an app that works well in Oracle,
>>>Informix, MS SQL and Mysql isn't really all that hard to do.
>>>
>>
>>Gary,
>>
>>I have more than 25 years of relational DB experience, including 13
>>years with IBM.
>
>
> Jerry, like you I have more than 25 years of relational database
> experience. I've written several applications that use that are
> database independent and I still receive royalty checks for them.
>
>
>
>>It covers everything from PC' with 20KB databases to
>>mainframes with database sizes in the 100's of terabytes. And I agree
>>with Mladen - I have never seen a *good* database independent application.
>
>
> Sorry for your loss.
>
>
>>I've also seen many "database independent" applications. But if they
>>truly are completely database independent, then they can't take
>>advantage of the power of the particular database they are using.
>
>
> That's simply not true.
>
>
>>They must code to the "least common denominator", which means they must use
>>only those features available in all database.
>
>
> Actually, "they" don't. Coding can be done so as to make use of the
> features of whichever database is used. Takes more up front planning,
> but it works.
>
And if it takes advantage of features of a particular database which
aren't available in other databases, then it's not truly "database
independent", is it?
For instance - write an application using triggers in Oracle or DB2.
Now make it work on MySQL - without changing any code in the application.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|