Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. Qt Creator and other tools
  4. SQL server for (Debian) Linux recommendation?
Forum Updated to NodeBB v4.3 + New Features

SQL server for (Debian) Linux recommendation?

Scheduled Pinned Locked Moved Solved Qt Creator and other tools
8 Posts 3 Posters 2.1k Views 4 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    mzimmers
    wrote on 9 Mar 2017, 16:13 last edited by
    #1

    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.

    1 Reply Last reply
    0
    • S Offline
      S Offline
      SGaist
      Lifetime Qt Champion
      wrote on 9 Mar 2017, 22:56 last edited by
      #2

      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.

      Interested in AI ? www.idiap.ch
      Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

      1 Reply Last reply
      1
      • M Offline
        M Offline
        mzimmers
        wrote on 9 Mar 2017, 23:41 last edited by mzimmers 3 Sept 2017, 23:52
        #3

        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.

        1 Reply Last reply
        0
        • S Offline
          S Offline
          SGaist
          Lifetime Qt Champion
          wrote on 10 Mar 2017, 07:57 last edited by
          #4

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

          Interested in AI ? www.idiap.ch
          Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

          T 1 Reply Last reply 10 Mar 2017, 12:45
          0
          • S SGaist
            10 Mar 2017, 07:57

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

            T Offline
            T Offline
            the_
            wrote on 10 Mar 2017, 12:45 last edited by
            #5

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

            -- No support in PM --

            M 1 Reply Last reply 10 Mar 2017, 21:25
            1
            • T the_
              10 Mar 2017, 12:45

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

              M Offline
              M Offline
              mzimmers
              wrote on 10 Mar 2017, 21:25 last edited by
              #6

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

              1 Reply Last reply
              0
              • S Offline
                S Offline
                SGaist
                Lifetime Qt Champion
                wrote on 10 Mar 2017, 22:06 last edited by
                #7

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

                Interested in AI ? www.idiap.ch
                Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

                M 1 Reply Last reply 10 Mar 2017, 22:42
                0
                • S SGaist
                  10 Mar 2017, 22:06

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

                  M Offline
                  M Offline
                  mzimmers
                  wrote on 10 Mar 2017, 22:42 last edited by
                  #8

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

                  1 Reply Last reply
                  0

                  1/8

                  9 Mar 2017, 16:13

                  • Login

                  • Login or register to search.
                  1 out of 8
                  • First post
                    1/8
                    Last post
                  0
                  • Categories
                  • Recent
                  • Tags
                  • Popular
                  • Users
                  • Groups
                  • Search
                  • Get Qt Extensions
                  • Unsolved