|
Only
to clarify:
Interbase/Firebird's selectable stored procedures are
unique, there is no other RDBMS that can do what IB/FB do. You have all the
procedural and relational flexibility to get and compute data before
returning rows. It doesnt return cursors as other RDBMS does. Even
the rows you return from this kind of SP hasnt be stored on relational
table.
By the
way, IB/FB runs on Win32, Linux, Solaris and there is some ports to BDS, HPUX
and AIX (I'm not shure in what other platforms runs).
regards.
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.
|
