Important: Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

SQL server for (Debian) Linux recommendation?



  • 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.


  • Lifetime Qt Champion

    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.



  • 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.


  • Lifetime Qt Champion

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



  • @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 ;)



  • @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.


  • Lifetime Qt Champion

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



  • @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.


Log in to reply