SQLyog 7.5 RC Has Been released

Changes (as compared to 7.15) include:

Features:
* New major feature: Query Formatter. Any SELECT, UPDATE, INSERT or DELETE statement can be formatted with a single click. Various formatting options/styles are available in ‘preferences’.
* New major feature: Query Profiler. With this feature enabled every SELECT statement will trigger execution of EXPLAIN (EXTENDED) and SHOW PROFLE (if supported by server) for the query and will detect changed SESSION STATUS VARIABLES (with some additional explanation of the meaning of those) due to execution of the query. The feature is highly configurable. The information will display in an ‘Profiler’ tab opening in the DATA/RESULT area. With this new feature there is no longer an excuse not to profile queries continously in the application development process – simply because whether you do it or not the effort will be practically the same! Refer to documentation for full details and for limitations of current implementation. This beta contains first step (only) planned for this feature.
* New improved icon theme with larger icons (in progress). The old icon theme originated back from a time where monitor resolutions were lower than what is mostly the case today. Also added an option to for user to select various icon sizes in the icon toolbar.
* The ‘info-line’ displaying at the bottom of DATA, RESULT and PROFILER tabs can now be turned on/off as defined by user.
* Added an option to force LETTERCASE (Uppercase/Lowercase) for display of keywords and functions in the editor. Note that only the display in editor is affected. When copying or saving, the LETTERCASE will copied be as it was entered.
* A VIEW can now be generated directly from the Query Builder.
* Status bar will now display information like “showing x rows of total y”.
* Column width’s defined by user in Data GRID will now be preserved when refreshing, filtering, sorting and using previous/next buttons.
* Some minor GUI usability improvements and fixes in Data GRID and in Object Browser.

Bug Fixes:
* If BLOB-viewer was closed by clicking the upper-left corner ‘x’ symbol, changes were lost without warning.
* A SQL script with a userĀ“defined DELIMITER using semicolon failed in editor as well as when importing an external script. Most important “DELIMITER ;;” (double semicolon) did not work – but other DELIMITER strings using semicolon (like triple semicolon etc.) did not either (however note that with HTTP tunnelling and when importing external files this is not yet completed)

Funtionality changed:
* The SQL_WHERE option in Data Sync is changed so that WHERE-condition is evaluated against <source> only (before it was both <source> and <target> (logically OR’ed)).

Miscellaneous:
* The ENTERPRISE uninstaller will now remove registration info from the system. This is a request by users who misspelled the registration name or by mistake registered to themselves as a person and not to their company/organisation. Note that as a consequence you now should have your registration details available if you uninstall and reinstall!

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Join the newsletter

3 Comments

Add yours

+ Leave a Comment