"PremiumSoft MySQL Studio is a set of graphical database management, reporting and monitoring tools for MySQL database systems."
I recently installed this product and at first glance it really impressed me. It is basically a Windows (or Mac OS) version of phpMyAdmin. Personally, I think phpMyAdmin is great. But, if you are in and out of the database all day long, a product like MySQL Studio is going to make you that much more efficient. I am used to working on Microsoft SQL Server all day, and I can see some similarities between this product and Microsoft's Enterprise Manager. With this product, you have a graphical view of all your database, tables and users. Speaking of users, the user management portion of this script is wonderful! As for SQL functionality, all the pieces are there that you would expect. Adding and deleting tables, creating new databases and running queries. One very nice feature about this product is the ability to do a database backup. With this software you can specify a source and destination server to move data. This alone is worth the price on this tool. Beyond what I have mentioned, this product also has a very "Crystal Reports" style reporting feature.
One problem I found with this application is in it's color coding of code. The functionality works great, but in order for it to work you have to go in and type all the keywords you want highlighted and choose the color to highlight them with. They should include a default color coding scheme. Another wierd thing I found was that they have a "Design Query" option. I figured this would be a graphical method to design a query. But, upon clicking the button, nothing happens! What this button really is is an "Edit Query" button. You must first create a query and save it, then go back to edit it with the "Design Query" button. Bad wording, but it works.
All in all, I would recommend this product. It has a couple small problems, but I think the benefits outweigh the pitfalls.
DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.
