Basic Features Missing

[Efolia]

I use SQLyog (ultimate, paid) on a daily basis in a development environment, as an alternative to PHPMyAdmin.

Here's a couple of missing basic features that I find quite a bit annoying, since they should be rather simple to implement.

1) The ability to jump to the first/last row of a table in a paged display (the double arrows in PHPMyAdmin). This is an important feature to have quick access to when you're testing actual data because you usually want to validate the last value that was entered.

2) The ability to upload and download backups in an archived format (at least gzip). I understand that this is partly dependent on the host server's MYSQL configuration, but it should be rather simple to have this option available when it is activated, which is quite common as most web server software comes preconfigured to handle compressed dumps. It does require quite a bit of bandwidth to backup a 500K-records database… 😉

Beside this, a Linux version, or at least a version compiled to run without bugs under Wine, would be really appreciated. I know that SQLyog runs functionally under Wine, but there are quite a few incompatibilities that make it difficult to use. I run it under Crossover (codeweavers.com) on my Ubuntu Linux box but find it hard to use because of the UI problems. It should be relatively easy to insure that at least the UI part works smoothly under Wine/crossover, since it is, after all, mostly text-based. Solving these issues would also open up the market for Mac users (Crossover/Wine run on both Linux and MacOS).

[ashwin]

Hi Efolia,

Quote:

1) The ability to jump to the first/last row of a table in a paged display (the double arrows in PHPMyAdmin). This is an important feature to have quick access to when you're testing actual data because you usually want to validate the last value that was entered.

We already have feature request to add “|<" and ">|” buttons (go to first/go to last) in addition to “<" and ">“(go to first/previous). It is added here: http://code.google.com/p/sqlyog/issues/detail?id=1604

Currently the priority is not set, but we will discuss and prioritize accordingly.

Quote:

2) The ability to upload and download backups in an archived format (at least gzip).

You can use 'Scheduled backup'(Powertools->Scheduled backup) to backup in zip format. But we do not have an option to decompress from inside SQLyog. There is similar request in our issue tracker: http://code.google.com/p/sqlyog/issues/detail?id=1306

We will discuss about this and prioritize.

Thanks,

Ashwin A

[peterlaursen]

1) This is already recorded here: http://code.google.c…s/detail?id=898 . It is not selected the next 'round' of features to be added. Actually the idea of first and last row does not apply to a database. There is no guarantee in what order the server will return rows unless an ORDER BY clause is used. So the 'last inserted row' will not necessarily be 'the last returned'. But in simple cases (like a table with a Primary Key on an auto_increment colum) it will.

2) Do you use HTTP tunnel? If you don't this “as most web server software comes preconfigured to handle compressed dumps” is not valid. Only with HTTP tunnel a webserver is involved. With direct connection and SSH-tunnel we have an option to use 'compressed protocol'. It results in same level of compression as gzip over HTTP (it is exactly same compresssion algorithm actually). We also have the option to compress backups (in the 'scheduled backup' tool, but not in the 'export' tool), but they will have to be unzipped manually though before importing. This is also recorded http://code.google.c…/detail?id=1306

We still have no plans for a 'native' Linux build. We have seen complaints before about similar issue as what you report with Crossover – but never/rarely with the free Wine from winehq.com (and as shipped with most distro's)

[Author]

Posts