Legend

Question

Favorite DB Managment Tool?

Forum|Forum|10 years ago
October 7, 2015
6 replies
6296 views

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?

This topic has been closed for replies.

R

RR456

Inspiring

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.

David_Powers

Inspiring

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.

R

RR456

Inspiring

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?

Brad Lawryk

Legend

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

Rob Hecker2

Legend

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

I wonder how many here are using mariaDB instead of mySQL.

Rob Hecker2

Legend

I upgraded my laptop to mariaDB today. My data driven applications ran fine. PHPmySQL was fine. MySQL Workbench complained but so far seems to work with it fine. I'm using innoDB. I will probably upgrade my main computer on Saturday and if all goes well will upgrade the remote server on Sunday.

siniousAuthor

Legend

Let us know if it keeps working after the upgrade!

O

osgood_

Legend

sinious wrote:

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?

Sticking with phpMyAdmin for the moment - it works well for my requirements - I see no reason to change. I don't much like deploying anything unless its a real necessity to do so just incase it upsets something else.

siniousAuthor

Legend

MySQL Workbench CE is free, have you given it a try?

I love PHPMyAdmin and because we use a large majority of hosts for our sites which only offer PHPMyAdmin, I don't mind using it at all for most tasks.

However, when I was working on some rather large (dozens+) databases, the visualization tools (EER diagrams to be specific) of DB model data helped clients not only understand what they already had but where I wanted them to move to. It has been not just instrumental in sales but the tables visualized are not just pretty pictures but a true, testable system, ready to implement.

Give it a try!

Herbert2001

Inspiring

I agree with Sinuous: PHPMyAdmin is fine for the daily tasks, and is often available through external hosts' control panels. But for visualization purposes and more complex tasks, Workbench is the one I go with. And it is free, which is nice.

Rob Hecker2

Legend

I use MySQL workbench and phpMyAdmin. Since I've been working with MySQL I have not really tried anything else except heidiDB. Sometimes I prefer the simplicity of phpMyAdmin to the power of workbench.