We at Webyog produce the SQLyog program. SQLyog is an advanced
graphical client for MySQL.
SQLyog records at winehg.com applications database are available here:
http://appdb.winehq.org/appview.php?appId=1328
As you can read versions up to 5.0.x worked fine with Wine. Basically
version 5.1.x does too. However we have two issues with two new
features of SQLyog version 5.1.x (we tested primarily on SuSE 10.0 and
Wine 0.9.15/16). The installation procedure followed is the one we
describe in our FAQ: http://webyog.com/faq/31_71_en.html (but it makes
no difference if we install under ../.wine/drive_c either). We would
like some help/hints to get every detail in relation to Wine
compability fixed - also with the new features of the program.
But let us try first to explain the the details
1) the 'favorites' feature. This is a folder tree in 'application
data' with plain text files. From the program menu you can build/edit
this folder tree and insert plain text file in there from the program's
editor component, or you can insert a file-URL to an existing file on
any drive that is mapped. That works! And the 'favorites menu'
displays every folder and file in the 'favorites' tree correctly. But
when copying a file from a folder into the editor nothing is inserted.
With some Wine versions before 0.9.15 ther where even more problems
(problem with creating the folder). But things have improved with
0.9.15 and 0.9.16. But we still suspect that the problem is with the
implementation of 'applications data' in recent Wine releases.
Comments?
2) the 'auto-complete' feature. This feature makes use of a SQLite
database. For each MySQL database that has been connected to, an
SQLite .db file is built in a subfolder to the program installation
folder. The database is built OK. To insert from it the keyboard
shortcuts CTRL+ENTER and CTRL+SPACE are used. However they do not
insert what the should. We are not sure if it is a problems with the
KEY combination only or what else it can be. There is another SQLite
.db file with the names of MySQL keywords and functions and this one is
being read OK, so it is not that the compiled-in SQLite library does
not work.
No need to say that there are no such issues on neither Win9x or WinNT
-based systems.
You can get SQLyog versions from here to test with:
FREE version (has 'favorites' but not 'auto-complete' feature):
http://www.webyog.com/sqlyog/download_sqlyogfree.html
ENTERPRISE TRIAL version (has both features):
http://www.webyog.com/sqlyog/download_sqlyogent.html
Now the last 2-3 month have been quite turbulent to Wine and to SQLyog
as well. Quite a lot of new code has seen the light of day in both -
and both are now in a 'consolidation' proces. We really would like to
fix the remaining issues in relation to Wine, but we are uncertain
where to look for the reason for those two minor 'defects'. We believe
that all the code that we write is standard Windows API calls. SQLyog
is developed and compiled on Microsoft Visual C++ 6 (but uses use only
pure C). Is there anyone out there that can figure out why:
1) The 'favorites' feature can create the 'favorites' folder,
sub-folders, and create files in there with the correct content. The
program (menu .. favorites) reads the content file names and
foldernames) of this 'favorites folder' but cannot copy the content of
a file from there into the program editor. Why?
2) The CTRL+ENTER and CTRL+SPACE keyboard shortcuts are not functional
with 'autocomplete'. However the TAB key is! And the program builds
the database files OK.
Ideas on how can we find if they are issues with SQLog, with Wine or
both would be much appreciated! Considerations, testing on other
distro's, proposals, good questions, proposals for small test programs,
code review. Whatever you think you can do that could help to spot the
nature of the problems. Source code is not public but we can find a
solution, if someone can use it ...
Manoj