Favorite DB Managment Tool?

Report · Oct 07, 2015

What DB management tool do you prefer overall?

Over the years I've mostly used PHPMyAdmin on MySQL DBs. In the last few years I've been tampering with Visual Studio DB projects and got pretty hooked there and then moved over from PHPMyAdmin to MySQL Workbench.

Yes you can be a show pony and say mysql terminal, if that's what you really choose to use. But I'm mostly interested in visual environments for their ability to bring useful schemas into models and visual EER diagrams for their human friendliness.

I'm also not really referring to IDEs that integrate and automate database connections, but tools for directly managing and manipulating databases themselves, the bigger the better. Your favorite?

Report · Nov 04, 2015

Keep in mind while MariaDB seeks to emulate the root of MySQL by branching it directly, it differs in features and storage methods. That squarely puts anything that does not say it is "MariaDB" compaible in a situation, beyond just being optimization problematic to feature reluctance.

I have absolutely no knowledge of PHPMyAdmin moving away from MariaDB compliance and even see PMA mention MDB compatibility. And I also remember tons of issues with it and several versions of MySQL. If it had issues with the primary purpose, I would never assume it would have growing pains with alternate DBs either. I think you did the best thing. Bring the issue up with the developers while you give them time to address the potential issue.

And all of us here are grateful to hear of your discoveries.

Report · Nov 04, 2015

sinious wrote:

I have absolutely no knowledge of PHPMyAdmin moving away from MariaDB compliance and even see PMA mention MDB compatibility. And I also remember tons of issues with it and several versions of MySQL. If it had issues with the primary purpose, I would never assume it would have growing pains with alternate DBs either.

I tested phpMyAdmin with MariaDB for the updated version of my Up and Running with phpMyAdmin course on lynda.com. I didn't find any incompatibilities in my tests. Although MariaDB is described as a drop-in replacement for MySQL, I don't think the tables created in one are accessible in the other. The MariaDB 10.0 FAQ states that a MySQL master cannot replicated to MariaDB slaves and vice versa.

As for bugs in phpMyAdmin, I discovered a couple of important ones when preparing my course. I reported them to the phpMyAdmin issues tracker on GitHub, and they were fixed pretty quickly.

Report · Nov 04, 2015

I don't think the tables created in one are accessible in the other.

If innodb is the storage engine, then no problem. MariaDB does provide storage engines that MySQL is not compatible with, so if you use those, there would obviously be problems. There are also some features in MariaDB that are not in MySQL, and if any of those are used, there could also be problems.

Report · Nov 05, 2015

In any compatibility test it doesn't surprise me a function or feature in MariaDB is absent. It's just the opposite. If you continuously follow, branch and update a master, of course you'll pass a comparison. But this isn't the point really.

The name of the app is PHP"My"Admin. Not PHP"Ma"Admin. I'd give it some time to update to the latest. Just keep in mind since Oracle owns MySQL and the features/bugs are slowed by their cycle, MariaDB was created for the opposite reasons. Open, fast, similar, but the tools like PHPMyAdmin may need time to catch up to a product they never expected to handle. Even if they say they do.

I think in a short time these things are less like bugs but more like indicators where changes and improvements have been made.

(phone keyed, forgive lack of spell check)

Report · Nov 05, 2015

Shouldn't the heart of the discussion, currently being had, be the following: The behavioral characteristics of table db (e.g. at times on boot-up user data is populated and other times table db is empty) in MariaDB 10.x vis-a-vis MySQL server?

The GUI, including PMA, is simply collateral damage of the true bug. HeidiSQL, current version, had parallel characteristics to PMA in this matter.

It seems to me the MariaDB dev team has an issue of compatibility with regard to this specific issue. However, I'll quickly note, it may be an install problem on my client and not a systemic MariaDB 10.x problem.

Report · Nov 06, 2015

I'm so torn. I really want to play with Maria (hey now..) but as much as I agree Oracle may not have too much vested interest in a competing product, it's REALLY hard to get burnt-in brand names out out peoples minds.

Oracle would be making a political and financial mistake to kill MySQL "fast". The past decades are littered with companies stacking or eliminating the odds.

At this point, I'd just hold up SQL and be grateful for it's existence. I feel only confident in 2 things. SQL will continue to be the base of interaction and which company has the best recipe will change. Since Maria appears to have upwards of 5% overall performance bump under real world benchmarks, I'm riding this wave as it goes. Right know, MySQL is still extremely in the game, tools work with it well and my clients haven't met Maria.

Report · Oct 28, 2015

I've decided to try maridDB (mySQL replacement), and at the same time I am going to take another look at HeidiSQL (phpMyAdmin replacement).

Have you looked at HeidiSQL yet?

I got the latest XAMPP stack that has MariaDB 10.0.17 and have had many problems creating User accounts using phpMyAdmin. I replaced version 10.0.17 with MariaDB 10.1.8 and am still getting the SQL errors in PMA. PMA is quite unstable. Nothing like it was when the database server was MySQL. You may recall my thread discussing these problems XAMPP v5.6.14 Table db in Database mysql has Possible Corruption Problem

Can HeidiSQL significantly replace PMA, especially when it comes to making User accounts? In PMA with MariaDB 10.1.8, if I could get to the Use account tab (e.g. if the SQL bug didn't show up) I could create the user and assign privileges, but could not restrict the user to specific databases; rather, they all had global privileges.

Report · Oct 28, 2015

I ran into problems upgrading to mariaDB from mysql, but the problems had had to do with compatibility between the remote database and the development database and the version of PHPmySQL. Once I had everything in sync, with the same versions of the database engine and phpMySQL, then it has all been fine.

PHPmyAdmin v 4.5.1 is working fine with MariaDB. For the moment I have kind of forgotten about HeidiSQL.

Note that collations in databases, tables, and columns can cause problems. You should have the collations all in sync. I use utf8_unicode_ci throughout.

Report · Oct 28, 2015

Thanks for the info

Report · Oct 20, 2015

Navicat is awesome. Best one that I have used yet.

Report · Feb 24, 2016

Don't mean to drag out an old thread. But now that MariaDB 10.1 Community Edition is stable and is exclusively included in XAMPP stacks I conclude, as Rob noted, MySQL is kinda drifting away. Thus Workbench may not be the most efficient tool and, I'm looking at GUIs in addition to PMA.

Since I operate in a self-hosting environment, thus am investigating MariaDB Enterprise 10.1, I'm researching various GUIs. I did not see SQLyog SQLyog MySQL Editor, Visual GUI Tool mentioned in this thread. Curious if anyone has experience with it. I installed it recently and it seems, from my limited time (and knowledge), to be pretty comprehensive, including a scheduler.

Report · Feb 24, 2016

I've used SQLyog in the past. I bought a copy because I wanted to be able to write about different options for administering MySQL. From what I remember, it was quite good, but I never used it enough to bother upgrading to newer versions.

I'm not sure that I would agree with the assessment that MySQL is drifting away. You might also want to take a look at the other thread, where I report on a serious problem with MariaDB and phpMyAdmin.

Report · Feb 24, 2016

Thank you David for your reply and valuable information. Your writings, for a beginner such as myself, are always extremely valued.

I quickly acknowledge that my "drifting away" comment was too flippant. I simply noted last weekend when installing the current testing stack Download XAMPP Apache Friends did not provide, anymore, MySQL as the database server; but rather, only MariaDB. Thus, for us beginners going forward, our exposure will be more to MariaDB database server. Again, I apologize for the comment.

Also, thanks for noting the serious problem going on in the other thread XAMPP Stacks Now Have MariaDB As Default, Any Issues?