On 10/6/2005 4:37 AM, Tzvetan Tzankov wrote:
They have collation and multiple characterset per table and etc. which
actually is from 4.1 (not new in 5.0), and postgresql have only one
collation per database cluster :-(
Otherwise I think their features are all there, but cannot be used
togather most of them (you can have foreign key, but not using fulltext ...)
AFAIK MySQL's fulltext indexing is only supported on MyIsam tables, so
if you want to use it, you lose ACID, hot backup and a couple other nice
things entirely for that part of your data. Many MySQL users still
believe that the pluggable storage engine design is an advantage ... I
think one storage engine that supports the full feature set is better.
Jan
CSN wrote:
Just so I know (and am armed ;) ), are there any new
comparable features in MySQL 5.0 that aren't in
PostgreSQL up to the forthcoming 8.1? AFAIK, PG just
lacks updatable views (which are on the TODO).
MySQL 5.0 new features
http://dev.mysql.com/doc/mysql/en/mysql-5-0-nutshell.html
Thanks,
CSN
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@xxxxxxxxx #
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
