Soyverde, 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.
Yes, 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.
soyverde, 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.
Closed AccountOct 24, 2005Submitter
donnex, if you get this to front page no doubt someone will tell you ;)
Closed AccountOct 25, 2005
I dig it. We've been waiting for this.
jasocoOct 25, 2005
I wonder how long before my host upgrades my server for me. And will it break anything I already have? Like phpBB?
zonemenOct 25, 2005
Any review about it?
gamednaOct 25, 2005
mysql has a long testing cycle for their Release Candidates. I am sure that this is pretty stable.
philodoxOct 25, 2005
Soyverde, 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.
spadinOct 25, 2005
I've used Navicat for MySQL. It's pretty straightforward.
soyverdeOct 26, 2005
Yes, 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.
greenalienOct 27, 2005
soyverde, 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.