Showing entries 1 to 10 of 57
10 Older Entries »
Displaying posts with tag: SQLyog (reset)
A look at Unicode with bash on Windows

When I wrote this blog about “bash on Windows” a few days ago I omitted one issue, that I already knew about. This is because it needs some elaboration that did not ‘fit in’ the previous blog. So I will do it here.

It is about Unicode. Unicode always was a pain in “cmd” and with the arrival of “bash” in Windows, this has become more significant and important. Actually on any recent *nix platform user will not do anything to make Unicode work ‘out of the box’ in the console and display all or almost all scripts (though I have noticed that the completeness of the ‘monospace’ font mostly used in the Linux console varies between Linux distros – with …

[Read more]
SQLyog MySQL GUI 12.2.5 Released

With SQLyog MySQL GUI 12.2.5, JSON comes to SQLyog. This is a new and major thing.  Also, Foreign Key management with NDB tables was added and the user- filter was improved in the User Manager. Additionally, some non-critical GUI bugs were fixed.

Changes as compared to MySQL GUI 12.2.4 include:

Features:

* Added basic support for the JSON datatype as of MySQL 5.7.8+ and MySQL Cluster 7.5.2+. The datatype is now available in the CREATE/ALTER TABLE dialog and JSON data will open in the BLOB-viewer. In the BLOB-viewer we have added validation that content is valid JSON. Also JSON-related keywords and functions are recognized in syntax highlighting and autocomplete. Also please see note at the bottom.
* SQLyog GUI now supports Foreign Key constraints between NDB tables for MySQL Cluster 7.3+.
* It is now possible to filter the users based on a string in the …

[Read more]
Manage your Amazon Aurora databases with SQLyog

We are elated to announce the availability of SQLyog for Amazon Aurora Databases. You can now manage Amazon Aurora databases with SQLyog, the most powerful database manager, admin and GUI tool.

About Amazon Aurora:
Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases.

SQLyog + Amazon Aurora:
It is very easy to connect Aurora database using SQLyog: just enter the DNS address of the Aurora instance as the host parameter, port number from the endpoint as the port parameter and key in your credentials. You can manage your Aurora databases with powerful tools like Synchronisation, Import External Data, Backup Wizard, Job Scheduler etc.

Not only these, you get all the …

[Read more]
Manage your Amazon Aurora databases with SQLyog

We are elated to announce the availability of SQLyog for Amazon Aurora Databases. You can now manage Amazon Aurora databases with SQLyog, the most powerful database manager, admin and GUI tool.

About Amazon Aurora:
Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases.

SQLyog + Amazon Aurora:
It is very easy to connect Aurora database using SQLyog: just enter the DNS address of the Aurora instance as the host parameter, port number from the endpoint as the port parameter and key in your credentials. You can manage your Aurora databases with powerful tools like Synchronisation, Import External Data, Backup Wizard, Job Scheduler etc.

Not only these, you get all the …

[Read more]
SQLyog – Introducing Session Restore

Ever had this nightmare of your system crashing, or you accidentally closing SQLyog and losing all your open tabs and queries? Don’t worry, we have you covered!

Introducing Session Restore. You can now restore your previous session along with all queries and history tab the way you left it. Here’s a quick video:

Session Restore is available for all SQLyog users. Existing customers can download the latest build from Customer Portal. To evaluate SQLyog, please download a 30-day trial.

We are very excited about this release, and hope that you will like it. We would love to hear your feedback.

Cheers,
Team SQLyog

Tweet

The post …

[Read more]
Speed up your database navigation with SQLyog

While coding, every second counts. And when the complexity of the database increases, you need to find new ways of speeding up your coding workflow. Let us admit it, we developers prefer to get all our work done using keyboard shortcuts, without having to switch to the mouse.

To streamline your entire coding experience and to speed up database navigation, here are a couple of useful keyboard shortcuts to make the most out of object browser filter in SQLyog.

Keyboard shortcuts:

  1. Ctrl + B – sets focus on object browser for operations related to Object Browser.
  2. Ctrl + [Up arrow] – brings focus to server/top-most element in Object Browser.
  3. Ctrl + E – sets focus to Query Editor to write queries.
  4. Ctrl + Shift + B – brings cursor focus on Object Browser filter.
  5. Right Arrow – Expand treeview element
  6. Left Arrow – Collapse treeview element
[Read more]
SQLyog 11 GA – your favorite MySQL GUI in 64 bit avatar

Hi,

64 bit SQLyog is here. It’s no secret that you can make the most out of your PC only when you have the right combination of software, operating system and hardware. You can now take full advantage of your 64 bit environment for your MySQL needs. We are proud to offer the first 64 bit GUI client for Windows.

Additionally, if you are using 64 bit Microsoft Office 2013, SQLyog 11 will work out of the box with the 64 bit drivers shipped with it. Importing from Access, Excel or Text/CSV has never been easier.

Please refer the following posts for detailed release notes:

[Read more]
Visually compare MySQL data and sync the differences

You had requested for a visual tool to compare two instances of a table to spot differences. We heard that. We are delighted to introduce Visual Data Compare (VDC) in SQLyog 10.5. It lets you do exactly that, and more. VDC allows you to compare two tables right next to each other making it easier to spot differences. It is a lot simpler than manually figuring it out all by yourselves.

VDC also doubles as an additional option for data sync. With VDC you will be able to compare differences visually and specify tables and rows that shall be synced as well as to decide in what direction to sync. It comes very handy when you want to copy lookup data from development databases to staging or production in cases where you for any reason don’t feel safe about having an automatic sync job running unattended in the background.


Visual Data Compare in action

What’s more in this release:

[Read more]
How to Personalize your SQLyog Theme

Fascinated by colors? Colors play a pivotal role in all our visual experiences because of its vibrational energy. Consciously or subconsciously we have a visual perception of how a perfect UI should be. This color theory has been applied by designers to create visually appealing modern user interfaces and contributing to the overall user experience. Having said that, color perception changes from one individual to another, some of us prefer subtle colors and few others like to spice it up a bit, and sometimes change can be good.

We’ve had users requesting for tweaks in our default SQLyog theme, and we had added this feature with the Twilight theme not long ago in SQLyog 10.0 with total control over the theming capabilities of SQLyog. …

[Read more]
SQLyog 10.4 improves usability with tens of thousands of databases or tables.

We have released SQLyog MySQL GUI 10.4. The 2 major new features are:

* Autocomplete speed/performance is drastically increased. This is the 3rd time we do this actually since autocomplete was introduced in SQLyog 5+ years ago. Our autocomplete implementation is one of the highest appreciated features of SQLyog according to a survey we did among registered users recently. However some slugginess could occur with a very large number (tens of thousands) databases on the server or a similar number of  tables or other objects in a database. Also a number of small bugs in autocomplete were fixed.

* Also when having a lot of databases, tables or other objects, operating a GUI tool may be tedious to work with (you may need to do a lot of scrolling, for instance). In this release we have implemented a filter in the Object Browser. It works like this: Database objects, where the typed …

[Read more]
Showing entries 1 to 10 of 57
10 Older Entries »