Support for other DB-Engines

[expired user #4516]'s profile image [expired user #4516] posted 13 years ago in General Permalink
Might be useful to support other DB-engines forked from MySQL, like Percona, MariaDB, etc with their native features. At the same time some native MySQL features may not be supported by these engines that causes error messages while using Heidi with these forks.
[expired user #4516]'s profile image [expired user #4516] posted 13 years ago Permalink
this is not the same issue as issue #964 as these are forks with peculiarities, but not really other engines
ansgar's profile image ansgar posted 13 years ago Permalink
What exact features are missing for Maria or Percona?
[expired user #5885]'s profile image [expired user #5885] posted 13 years ago Permalink
As for Percona there one feature missing - an icon in session managersmile
ansgar's profile image ansgar posted 13 years ago Permalink
I have no Percona running here. If you tell me how Percona is reporting its version string I will probably be able to add a different icon. Is there an icon?
[expired user #5885]'s profile image [expired user #5885] posted 13 years ago Permalink
show variables like 'version%'


Variable_name	Value
version	5.5.13-55
version_comment	Percona Server (GPL), Release 20.4
version_compile_machine	i686
version_compile_os	Linux


As for icon I belive you can use favicon http://www.percona.com/static/images/percona_favicon.ico
ansgar's profile image ansgar posted 13 years ago Permalink
Thanks. Is that "percona" string not fetchable via
mysql_get_server_info(FHandle)
?
Fetching it via SHOW VARIABLES LIKE 'version%' will force me to add an extra query to the startup process, just to see if it's Percona or not.
ansgar's profile image ansgar posted 13 years ago Permalink
You can see what mysql_get_server_info() returns by moving your mouse to the status bar panel which says "MySQL 5.x.x", which then pops up some more details. Please report here what it does say. Thanks.
[expired user #5885]'s profile image [expired user #5885] posted 13 years ago Permalink
Popup doesn't say anything about Percona either.

As for extra query, now there are two queries fetching variables, maybe they can be reduced to one:

SHOW VARIABLES WHERE Variable_name IN('hostname','version_comment','version_compile_os')


ansgar's profile image ansgar posted 13 years ago Permalink
That WHERE... syntax would fail on older MySQL servers (was introduced in 5.0.3). Instead I'll just use SHOW VARIABLES and use it also for the host/variables tab.
Code modification/commit from ansgar.becker, 13 years ago, revision 6.0.0.3930
Implement TDBConnection.GetServerVariables, and use that in various places. Also, indicate Percona server version using version_comment variable. See http://www.heidisql.com/forum.php?t=8035 .
ansgar's profile image ansgar posted 13 years ago Permalink
Done in r3930

Please login to leave a reply, or register at first.