MySQL Database tools - Navicat, Toad and CFMyAdmin

2006-06-22 12:16:00.0

MySQL Database tools - Navicat, Toad and CFMyAdmin

We generally use 2 databases MSSQL and MySQL for our applications. Our personal preference is MySQL but sometimes due to customer requirements we have to use MSSQL.

For ages we were looking for a MySQL manager program like MSSQL Enterprise and in the earlier days used to use MySQLFront, a great little app which is no longer being actively developed. In fact our ColdFusion based MySQL admin tool, CFMyAdmin was modelled on this great little app.

As time moved on and we needed more functionality and reliability, we found Navicat. We bought 4 licenses (best value ever - $139 per license for Enterprise Windows Edition) and havent looked back! The latest version 7.2.5 has absolutely everything we require and is FAST.

Yesterday, I found another FREE MySQL database tool that looks interesting called TOAD for MySQL.

Its extremely complex at first and the user interface isnt as polished as Navicat but the SQL tools and syntax colouring looks promising.

The only thing lacking in both TOAD and NaviCat is an intellisense type interface while writing your sql but hopefully this feature will be introduced shortly.

EDITED 26th June 2006 - Thank you Gary for your comment on the Intellisense. My error, it appears TOAD has intellisence built in. i will turn it on, check it and report back!

As I mentioned above, we developed a ColdFusion based MySQL manager called CFMyAdmin a few years ago and unfortunately, the development has stalled. We plan on picking this free community project up again in the near future, start from scratch and developing a more robust and powerful ColdFusion based MySQL manager.

The problem with CFMyAdmin was that it is extremely hard to make a connection to a MySQL database using a connection string. It works perfectly in ColdFusion 5 as CF5 supports dynamic connection strings but MX removed this option so we had to use Macromedias Java Factory classes to make a connection to the database by creating a DSN on the fly. A lot of thought will have to go into how to connect to the DBS before we can start developing.

Tags: ColdFusion | MySQL
Add to your del.icio.us    DIGG This!    Technorati Cosmos Link    Post to Reddit    Add to your Furl    Add to Blinklist
Comments [3] - Leave a comment

Comments

I am the Product Manager for Toad for MySQL, and we do have intellisence in the product so this information above is incorrect. We refer to it as Toad Insight, and you can find the settings for it in the options under Options|Editor|Toad Insight. You may also want to take a closer look at our Auto Replace, Code Snippets, SQL Formatting, Connection Management, Multi-Server Execution, and the Customizable User Interface (tabs, treelist, toolbars, keyboard). We also have a v1.0 Toad for SQL Server release available at http://www.quest.com/toad_for_sql_server/ and we will have a v2.0 available in mid July 2006.
Hey Dan, any news on your plans regarding CFMyAdmin? I'm sure there are some out there who would still like to see the product updated--and may even want to contribute. Or have there perhaps been other solutions that are meeting the need? Haven't investigated it much, I'll admit. Just learned of PHPMyAdmin today, and thought to look if there was a CF version, and found this and read your blog entry, etc.
Martin said:
Ye, here is a cool way to manage databases with multiple connections. its best with GUi and their functionalities i was referred to use <a href="http://webyog.com">sqlyog</a> by most of my friends and i have got free version. have a try! its really worth!!