MySQL is pretty fast and very reliable. It's also simple to use. It
supports standard ANSI-92 SQL, as far as I can tell, and the standard
distribution does not have certain features such as:
- triggers
- stored procedures
- referential integrity
- transaction support (this may have been implemented through Gemini, but
the legal status of this contribution appears to be in question now)
Hence, 'how good' MySQL is depends on your intended use. It's very good to
build web applications and db-independent applications that need basic, fast
and reliable database storage.
If you want to embed a lot of the business logic in stored or needb other of
the more advanced db features, you should look at other alternatives. The
open source one would be PostgresSQL.
Many MS-SQL and Oracle applications that do not use all the bells and
whistles of these costly dbs could be implemented as MySQL apps at very
favorable cost/benefit ratios.
Use of T-SQL and PL-SQL can make your application overly db-dependent. The
current trend is away from that model towards architectures that use a
data-access abstraction layer, possibly complemented by stored procedures.
Paul Dubois' book on MySQL is an excellent source of information for the
pros-cons of MySQL.
Hope this helps
-----Original Message-----
From: Nexus Terminator [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 15, 2001 9:59 AM
To:
Subject: I'd like to use MySQL but actually I'm not sure ...
Hello:
I'd like to know how good MySQL is, also what SQL
extension it uses (like T-SQL, PL-SQL or something
else?).
Any comment will be appreciated
_________________________________________________________
Do You Yahoo!?
Obtenga su dirección de correo-e gratis @yahoo.com
en http://correo.espanol.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
