MySQL is not hard to manage anymore. There was a time that you had to use the command prompt or go into the configuration files to get important administration done. Those days are over and MySQL AB not only provides excellent GUI tools for database server management but they are also free!
Recently saw a blog where the author gives some short information on how to control memory on a MySQL database server. Though you can do in his way using the GUI is much easier and provide more information on how and what to do. Rather than go through each area of the GUIs and each tool. see the sceenshots and recommend that you download and install the tools. You won’t be sorry.
As you can see the offerings are numerous and detailed. Especially of interest to most is the slow query log. This is one of the tools that you spend hours surfing the we to find. Within the package is also the Query browser which has one outstanding feature. It lets you create and view stored procedures. There is only one caveat that you have take notice of and that is that the tools are made to run against the “localhost”. This is a problem for many and places the MySQL GUI tools long behind SQL Server and Microsofts database management tools which can all be run from a remote node.
MySQL refers to the GUI Tool kit as the “Essentials” package and they are right. This package is essential not only to time restricted professionals but for new users of the MySQL database software. It is also one of the essentials in learning MySQL which programmers do not spend enough time on in my opinion.
source
Categories: MYSQL Tags: blog, caveat, database management tools, database software, Essentials, GUI, gui tool, GUIs, localhost, memory, memory settings, mysql database server, mysql gui tools, node, offerings, programmers, queries, query log, server management, tool kit I am very excited to announce that Zend Studio for Eclipse 6.1 has been released, and would like to share with you some of its new features.
This release is a “Complete Web Development Environment for PHP Developers”, as it provides significant improvements for Web developers who utilize a rich code base that includes PHP, JavaScript, and CSS.
I would particularly like to emphasize the following new features:
- Source editing and navigation of JavaScript, Dojo and CSS resources.
- Better integration with Zend Framework 1.6 features.
- Improved data tools management with new SQL query builder.
- Bug fixes and usability improvements.
Read more…
Categories: Technology Tags: ability, base, Better, Builder, cascading style sheet, code, code completion, complete web development, Controller Action, Controller Test, CSS, css resources, development, dojo, Eclipse, editing, editor, Environment, example, Explorer, feature, file, framework, framework project, Grid, Helpers, integration, Item, javascript, javascript elements, javascript files, javascript resources, library, list, Management, navigation, New, node, PHP, php developers, php javascript, project resources, property, Query, release, repository, Rich Internet, significant improvements, source, SQL, sql query builder, storage, Studio, Support, toolkit, type dialog, usability, usability improvements, user, variable, view, web, web developers, web development environment, wizard, Zend, zend framework, zend studio 
