SQL server for (Debian) Linux recommendation?

mzimmers

Hi, all -

I'm on a tutorial (not one of the Qt ones) that tells me I need a SQL server and client. I figured I would check in to see if there was a particular product that is known to work well with Qt.

If no one has better ideas, I'm probably going to try this:

MySQL Community Server 5.7.17

This should take care of the server; I'm not sure yet what I'm going to use for the client.

Thanks for any suggestions.

SGaist

Hi,

You have mainly three choices for SQL servers; MySQL MariaDB and PostgreSQL. The second is a drop-in replacement of the first.

As for client, are you building a Qt application to talk with your database ?
Otherwise, all DB server comes with a command line client.

mzimmers

Hi, RGaist -

Thanks for the reply. I have absolutely no idea what I'm going to be doing with this, other than completing the work in the tutorial(s). The tutorial is given on a Windows box and the author is using a GUI client, so I figured I'd better get one for myself.

I settled on MySQL for the server. It installed fairly cleanly. Unfortunately they don't have a Debian version of their client (called "Workbench") so I may have to build my own.

SGaist

IIRC you can grab MySQL Workbench as GUI (though I've never used so I can't comment on its usage).

the_

@SGaist
@mzimmers

MysqlWorkbench is a cute tool, latest version is pretty stable on linux
If you use latest mariaDB the workbench will tell you that it is not compatible with it, but i dont have any problems using it with mariaDB.

at https://dev.mysql.com/downloads/workbench/ you will find a download for ubuntu, maybe this .deb file works with debian too. if not, sorry you have to download the sources ;)

mzimmers

@the_

Yes, the Ubuntu version seems to work. At least it launches. I can't connect, but that's not a problem for this forum.

Thanks.

SGaist

Since you're on Linux, you don't need to grab an external package. Ubuntu already provides MySQL/MariaDB/PostgreSQL.

mzimmers

@SGaist : Ubuntu might provide that, but Debian doesn't. But no matter, because I have the server up and running. Now I just have to figure out why my GUI client doesn't connect even though the CLI client does.