Oops, I think I was a little out of date with the Foreign Key Support. The last binary I used was 3.22 back in September 2001. However, I think FK Support is still premature as it only supported on the InnoDB table type and not the native MyISAM table type.
If I were in your position, I would wait until v4.1 to come out before using MySQL for a large project. However, if it is a small to mid-sized database project MySQL will suit you fine. There is PostgreSQL. It's much more mature than MySQL and much more complex as well. I haven't used it myself at all, so I can't comment on it. Rob mentioned mysqlfront as a GUI front-end. It's pretty impressive for a free interface, it reminds me a lot of Enterprise Manager. That's the best interface I found... even better than a few commerical ones : ) At 06:00 PM 08/02/2002 -0500, charlie arehart you wrote: >I'm looking forward to such a discussion of MySQL, but I must say I don't >see how admin tools will solve the lack of views, SPs, relational/FK >support, and row locking issues Michael had mentioned. Perhaps you're >instead addressing any assertion one may have that it lacks any admin tools >out of the box? That's certainly useful. If so, no need to respond. > >Actually, I've gone ahead and done some digging since that last note. >There's a site devoted to the DBMS at www.mysql.com, and there's news there >that the new 4.0 release addresses the row locking >(http://www.mysql.com/products/mysql-4.0/index.html). Also, as for Views and >SP's, they're supposedly coming in 4.1: > >Views: http://www.mysql.com/doc/A/N/ANSI_diff_Views.html >SPs: http://www.mysql.com/doc/A/N/ANSI_diff_Triggers.html > >As for FK's, it's there as of 3.23.44 according to >http://www.mysql.com/doc/A/N/ANSI_diff_Foreign_Keys.html > >Looks like MySQL is shaping up to be a pretty cool alternative. Has anyone >used it as an alternative? - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: Michael She <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
