|
I have used PostgreSQL extensively. It has
everything you mentioned (PK, FK, Check constraints,
triggers, stored procedure, selectavle stored
procedures (functions?), transactional control). The
only thing that PostgreSQL lacks to compete with
Oracle and DB2 (and later SAP/DB by the way)
directly is point-in-time recovery and hot backup.
They promise to have this feature by July plus
a native Win32 port which is also a must.
Regards,
Nicolai
----- Original Message -----
Sent: Tuesday, May 27, 2003 8:14 PM
Subject: RE: SAPDB and mySQL
I
have experience in Oracle, Interbase / Firebird, MS SQL and
SAPDB.
If
you are looking for new open source RDBMS instead of SAPDB I recomend you
FireBird. It is the fork of Interbase 6, and Interbase has almost 20 years of
existence since it early days on DEC. It has all you need for an active
database (PK, FK, Check constraints, triggers, stored procedures, selectable
stored procedures, transaction control, etc.). I ran succesfully up to 100 to
150 users in C/S environment with very modest server hardware. Above that
level you should look for more powerfull RDBMS such Oracle. I never use
PostgreSQL then I cant say anything about it.
MySQL was the first database which I learned from. It wasn't long
before I realized I needed something more powerful. Then I found PostgreSQL.
I haven't used much else. Oracle... just a bit. Then very recently, I found
SAPDB and was impressed. How ironic that I have just found a database server
that meets my requirements, and to hear that they are possibly merging with
MySQL.
So do I "rollback" to using PostgreSQL? What about Firebird? I would
like to use Oracle, but there are too many restrictions, not to mention a
hefty pricetag.
I don't want to be hasty, but I think I should start looking around
again, just in case these rumors are true. Does anyone have a second runner
up in the open source database race?
Ray Harrison
<[EMAIL PROTECTED]> wrote:
Like
many on this list I was disheartened by this news. My main
questions,
if Daniel, Elke et al are still available, are:
1.) What happens to
the SAP DB code tree? Will it merge with mySQL or
will it be a
separate product? Or will the code tree just go away?
2.) Will SAP
LABS do any work on the 7.5 fork or will it only do minimal
work on
7.4?
3.) If the answer to (1) is that it will merge with mySQL,
what versions
of mySQL will end up as the co-product of SAP DB and
mySQL?
To re-name a product that carries with it a substantial
amount of weight
(SAP DB) to mySQL (despite their recent advances, it
still comes across
as a toy in the minds of many) is a
travesty.
Cheers
Ray Harrison
Managing Partner
TSG
International,
LLC
_______________________________________________
sapdb.general
mailing list
sapdb.general! !
@listserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general
Edgar Castanedo [EMAIL PROTECTED]
http://www.geocities.com/ecastanedo/
Do you Yahoo!?
The
New Yahoo! Search - Faster. Easier.
Bingo.
|
