When we talk about a tool to manage the database MySQL, is a priori believe that it will be phpMyAdmin. At any hosting phpMyAdmin - de-facto standard. Bad one - this rather auxiliary tools are often used as a basic Mysql GUI tool. But when constantly dealing with a database, then the tool must be chosen properly.
No, against the phpMyAdmin I have nothing, but let's judge for sober. Implementation in PHP allows you to use the solution virtually anywhere, but immediately imposes severe restrictions on the ease of use. What are fully reloads the page in the absence of AJAX. Working through such an interface provides a tight, and editing data in general is maddening. Have you ever accidentally pressed the button "Delete page", although only wanted to delete one entry? I - pressed. In addition, phpMyAdmin must configure each server separately. On access to different servers from one place can only dream. Yes, the implementation of a Web-based applications a plus in some situations, but for designing databases, data editing, programming stored procedures and complex SQL queries is a much more successful solutions.
HeidiSQL
Unlike phpMyAdmin, HeidiSQL is no longer a web application. This program with convenient user interface, through which work with databases and converted into a pleasure. The advantages of a desktop program on the face. Viewing and editing data is carried out through a convenient grid (a table with the possibility of editing). Compare this with phpMyAdmin, where the tables only displays data, and change any of the entries made on a separate page. HeidiSQL can sort the data and that is especially convenient to use the filters, selecting records on a specific mask. For greater clarity to the table, you can use different color schemes - feature from the category of those that initially seem insignificant trifle, but after a while you get used to it so that even you can not refuse.
However, hardly work with the database limited only by editing the tables. One of the key features of the program - the editor of SQL-queries. As in modern development environments available to the user fashionable features editing package: autocompletion of names of databases and spreadsheets, as well as tips to the constructions of the request. Now do not be tense about the names of tables and fields - HeidiSQL itself tells an option. Moreover, the user is provided with blanks template system code (called snippets) owing to which it is possible not only simplify but also speed up development. Cannot only - no tabs for different queries. Without this vital details of the interface will be oh how difficult, if at the same time have to perform several different queries. But the wildly delighted editor of stored procedures is extremely user-friendly and simplifies the process of creating functions and triggers.
Generally with HeidiSQL any action with databases are an order of magnitude more pleasant. Nothing is easier than, for example, dumping the database with its structure and data: HeidiSQL quickly generate any SQL-exports. A user-friendly interface you can dump database structure and data itself to a file, or indeed to another server. But before a stupid move dump, just think: if both servers have the same base, then perhaps more appropriate to use the built-in synchronization. And if the data to be transferred to another format, then there is a sin not to use export to CSV, HTML and XML formats.
Now, with regard to administration. HeidiSQL can monitor and delete client processes. This is an excellent opportunity to analyze the query and remove the left processes. In addition, you can conveniently edit the server variables, as well as manage user privileges using an interface similar to edit the ACL-sheet files NTFS.
Unfortunately, all the advantages and charm of the program flies in the hell, if the server port is blocked by MySQL daemon. HeidiSQL trite can not connect to the server and will be absolutely useless. Even more sad about the fact that the cheap hosting such a situation in order to things, and mechanisms to circumvent this limitation have no program.
SQLyog
So what can we do? If the hoster firewall blocks the ports that belong to the MySQL-server, then connect to the database can be extremely local programs and scripts. Often with their help and have to manage (hell, again phpMyAdmin!), But there is another option - use them as a mediator! If you pour a special script on the server, which will have access to MySQL and is available at the same time "outside", then it may well be used as a link between the database and our desktop environment. This method is called HTTP-tunnel, and maintained excellent tool for working with databases and MySQL - SQLyog. Specify the connection settings, address script SQLyongTunnel.php, previously located on hosting - and the firewall is not destiny. Need security? SQLyog supports connection over HTTPS.
Moreover, in SQLyog integrated SSH-client and, if you have in your possession is a normal hosting with support for Secure Shell, it is possible (and even - to) use the SSH-tunnel. This is, firstly, will establish a secure communication channel between SQLyog and MySQL server, and, secondly, will apply to the demon, even if its port (default 3306) is closed. It is only necessary to specify the address and port of the SSH-host (assuming the daemon database resides on the same machine), specify a password or private key access to SSH, as well as authorization information directly to the MySQL daemon. This connection is more stable than the support HTTP-script.
However, various options for connecting to a server - it is naturally not the only plus program. Generally, SQLyog - a kind of pioneer, which is often the first to introduce the most juicy and fresh features. We will not touch trite functions such as creating tables and editing their structure and content - I dare to assure they are implemented at the highest level. Cool tabs implemented system allows to operate with several requests, and the system Smart Autocomplete helps make inquiries and avtodopolnyaet database and table names. Also in the SQLyog query profiler built - a unique tool for debugging and optimizing queries. Profiler shows how much time is spent on the query, laying on the shelves of each of its execution (transfer request, opening tables, lock tables, etc.). Thus it is possible to identify the most expensive operation and try to get rid of them. For example, by creating an index for the desired table. Or, more radically - by increasing the cache size for. Thus, it is also a great way to assess the effect of changes in those or other server settings.
In SQLyog built a powerful mechanism for synchronizing databases, and management of this process is maximally simplified by a special master. At various steps is introduced: the parameters of servers and databases, the direction of synchronization, compared fields, etc. Similarly configured and automatic backup on a schedule. In general, strongly encouraged by the overall well thought-out program, through which SQLyog equally well be used as an advanced user, which necessarily have to taste, for example, the editor of stored procedures, as well as novice users, in whose hands would be simple visual aids for the query and database structure design data.
SQLyog is distributed in two versions: free and paid Community Enterprise-variation. Unfortunately, most succulent chip programs like visual editors, tunneling and autocompletion queries freeware truncated version, but even with such functionality SQLyog two heads higher than phpMyAdmin.
dbForge Studio
On the official page of the program among users of a well-known brands: Hitachi, Honda, Samsung, BMW, Siemens. From this doubly pleased that dbForge Studio is completely free for noncommercial use (for russian users). By and large this is another convenient front-end for working with databases MySQL. Prepare and execute queries, edit data, carry out their export and import, develop SQL-scripts and stored procedures - we get a standard set of features, but even with high-quality implementation of it will surprise few people. But add to that stored procedure debugger MySQL, visual editor for the compilation of SQL-queries, class code editor with autocompletion of commands and the names of databases / tables - and probably anything else you will not use you want.
Manual debugging of stored procedures and triggers with the interim findings and calculations in his head, perhaps, giving old school romance, but in most cases wild inhibits development. But chic debugger of stored procedures, embedded in dbForge Studio, - above all praises. Right in the code editor can be in the right place to set breakpoints, to the performance of all or part of the procedure step by step, and at each iteration tracking variables and query results. Incidentally, SQL-queries do not necessarily gain manually - at your service special visual aids. It is unlikely to help if you need to really bungled the complex query, but will have an invaluable aid to those who have yet to SQL frets.
In general, visual aids and in particular database designer - is one of the main trump dbForge Studio. If you need to quickly bungled the base, then the best solution does not seem to find. Be placed on the workspace separate entities, and establish relations between them, edit options fields - and the base is ready for use. It is noteworthy that right from the visual designer can refer to any element of the base, whether it's normal field of the table or stored procedure. Very convenient to use even then, when the base is ready, but you quickly find and correct one of its elements - personally, I'm doing.
dbForge Studio boasts advanced export and import of data. The Export Wizard allows you to select the columns and columns, specify a different mapping of data and convert the data into one of the following formats: Text, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, CSV and XML.
Important point - the connection to the database. Honor and praise to the developers who are not too lazy to realize the possibility of simultaneous connections to different servers, and in addition to direct connect support for tunneling through SSL, SSH and HTTP.
"And anything you do not forget?"
Perhaps reading the material, some wonder: "What about the program Navicat or what else?". But we have not aimed to tell about all the decisions immediately and consciously avoided by commercial products (like Navicat). Instead, we wanted to share experiences, what decisions and when we were useful. And most importantly - open the eyes of those who still uses only one phpMyAdmin, giving up the use of different instruments.
Other similar programs are not included in our review:
SQL Maestro for MySQL
MySQL GUI Tools:
Toad for MySQL:
EMS SQL Manager for MySQL:
0 Comments:
Post a Comment