30 Comments
- spadin, on 10/12/2007, -0/+2This update could be what finally makes MySQL a competitor to other big database engines like MSSQL or Oracle. Granted we have to see how the speed tests turn out. Stored procedures, Triggers, Views... This is awesome news!!
- damanfoo, on 10/12/2007, -0/+1personally, i would never use a product just out of RC status for any type of production environment.
- djoek, on 10/12/2007, -0/+1donnex, if you get this to front page no doubt someone will tell you ;)
- donnex, on 10/12/2007, -0/+0Anyone know hos the performance is compared to 4.x?
Will this update break existing pages? - Lesli, on 10/12/2007, -1/+1Erm.. I'm going to hang on to the hope that that was sarcasm.
- soyverde, on 10/12/2007, -0/+0Yes, I tried Navicat, but it seems to have some problems with stored procedure syntax when nothing is wrong with the procedure...I learned this the hard way trying to troubleshoot non-problems with Navicat, and will likely not go back to that tool. ADS seems pretty decent for now, my only complaint is a lack of an easy way of editing procedures (short of dumping and recreating them, or running an ALTER PROCEDURE statement in the query browser). I don't see this as a compelling reason not to use it, I just wondered if there were any better tools out there that I had not seen.
Philodox: I realize ASA has a much older code base, and it happens to be the default back end for the thick client we are using, but it leaves far fewer options when it comes to web development, particularly when you are looking at RoR or PHP frameworks... ASA just isn't as well supported in the dev community as ASE, and has nowhere near the same level of community support as MySQL. We had to make some major schema changes, so making a back-end switch at that point really wasn't such a huge deal. We have used earlier versions of MySQL pretty extensively, and by the time this app gets back out of alpha, then beta, MySQL 5 will probably be in pretty heavy use. - longofest, on 10/12/2007, -0/+0donnex-
It shouldn't break any of your existing pages, such a question is very specific to exactly what you are doing. Try it in a dev environment, then go production.
This probably would be better if it was in the Programming section, but I can see why it is in tech. - inactive, on 10/12/2007, -0/+0"Mysql said: Field 'Attributes' doesn't have a default value"
Anyone knows how to set those values.. when encountering such error? - white, on 10/12/2007, -1/+1lesli? what's a girl doing on digg? i'm in shock
- Lesli, on 10/12/2007, -0/+0Go figure that I downloaded and installed 4.1 this morning on my new dev box :|
- spadin, on 10/12/2007, -0/+0Actually, I just looked up your Aqua Data Studio and it looks a little better. I'm downloading it right now to test it out.
- jesusphreak, on 10/12/2007, -0/+0So does PostgreSQL have anything better than MySQL now?
- GreenAlien, on 10/12/2007, -0/+0soyverde, personally recommend sqlyog for mysql admin/queries. The latest RC supports mysql 5 by the looks of it. I like sqlyog mainly because of the HTTP tunneling and database sync tools.
- Jasoco, on 10/12/2007, -0/+0I wonder how long before my host upgrades my server for me. And will it break anything I already have? Like phpBB?
- spadin, on 10/12/2007, -0/+0I've used Navicat for MySQL. It's pretty straightforward.
- djoek, on 10/12/2007, -0/+0Major New Version Delivers Advanced SQL Standard-Compliant Features
Such as Stored Procedures, Triggers, Views & New Pluggable Storage Engines - zonemen, on 10/12/2007, -0/+0Any review about it?
- Leftyshields, on 10/12/2007, -0/+0Nobody answered if it breaks 4.1 sites...
- GameDNA, on 10/12/2007, -0/+0mysql has a long testing cycle for their Release Candidates. I am sure that this is pretty stable.
- Philodox, on 10/12/2007, -0/+0Soyverde, I can't believe you traded ASA for MySQL. I hope you know what you're doing because I certainly wouldn't want RC (I guess technically final now) software backing my business/appication. Not to mention that ASA is light years ahead of MySQL as far being a good database goes.
- djoek, on 10/12/2007, -0/+0thanks soyverde! keep on digging this, and enjoy once more how alex wrangles his way thru 'Deejay Oyek' in diggnation ;-)
- soyverde, on 10/12/2007, -0/+0We've been using 5.0 RC in development for a few weeks now (switched from Sybase ASA mid-project when we found out it was in RC). It shouldn't be breaking anything from 4.1 that I know of, and it is quite stable. If only their Admin and Query Browser tools were stable as well... Anyone using 5.0 recommend a good GUI tool for administration and querying (currently trying out Aqua Dataq Studio)? Thanks for the heads-up djoek, definite digg.
- jiminoc, on 10/12/2007, -1/+0sweeeeet! this is the one we've been waiting for
- inactive, on 10/12/2007, -1/+0I dig it. We've been waiting for this.
- jesusphreak, on 10/12/2007, -1/+0WOW!!!
- Sh|fty, on 10/12/2007, -1/+0*joins in in the golf claping*
- listerine, on 10/12/2007, -1/+0"MySQL 5.0, the most significant product upgrade in the company's ten-year history."
Sounds like a big upgrade :) - MacSawD, on 10/12/2007, -1/+0I have no idea what MySQL does besides something with Databases, but if it improves the rate, ease, and security at which the internet operates, I'm all for it!
w00t! - snapya, on 10/12/2007, -3/+0http://www.techheaven.net


What is Digg?
Browsing Digg on your phone just got easier with our enhancements to the