Re: LINUX is the "one" ? .... -- MIDRANGE-L

Look at PostreSQL at www.postgresql.org much farther along than My SQL..

JMS..

At 05:40 PM 4/2/2003 -0600, you wrote:

I agree that mySQL has nice features for web
page development purposes, but the last time I
checked, mySQL didn't have database triggers nor
stored procedures.  I believe the next version
(4.1) just added support for subqueries
(subselects).

Different databases are optimized for different
purposes.  It's one thing to use a database to
serve stateless web pages... it's another to
guarantee that data is consistent and
recoverable in an interactive environment.

But mySQL is constantly improving... maybe it
has jumped these hurdles already.

William


---- Begin Original Message ----
date: Wed, 2 Apr 2003 13:13:36 -0700 (MST)
 from: James Rich <james@xxxxxxxxxxx>
subject: RE: LINUX is the "one" ? ....
Comments???

On Wed, 2 Apr 2003, Booth Martin wrote:

> I am not clear on something.  The iSeries
IFS...  could we have MySQL on the
> IFS and still have DB/400?

Yes, assuming the C and C++ code that MYSQL is
written in is portable
enough to compile and run under OS/400.  MySQL
creates standard stream
files for it's tables and indexes.  These stream
can exist anywhere.

And btw, MySQL has some very nice features which
would be great to have on
the iSeries.  Like a great API.  And an
AUTOINCREMENT feature which while
non-standard, provides a great method to
uniquely key records which just
need an ascending number as the key.

James Rich

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


Jeffrey Silberberg
CompuDesigns, Inc.
Atlanta, GA. 30350
(770) 399-9464