Nominate our 2022 Qt Champions!

MySQL and Qt5 how to start? by Newbee

  • Hi everyone,
    I am going to start developing some bookkeeping software for POS terminal and desktop
    application on Linux, and i am aware i will need some database to store all accounting
    information, as well receipt data and so on. The question is how to install, configure and
    set all i need for database managing app i want to develop? My biggest issue is how to setup all i need so i
    can start using database in my code. I don't know what database is good for sales bookkeeping.
    I installed MySQL server on my Mint Olivia,
    but i also heard that i will need "database drivers" but i don't know how or what and how they are used.
    There is a lot i still don't know but i want someone to point me in a right direction with this.
    Thank you for reading all of this !! :)

  • Lifetime Qt Champion

    Hi and welcome to devnet,

    Everything database driver related can be found "here": You can also find the same document for Qt 4

    For the underlying database engine, MySQL or MariaDB, Postgresql, it's pretty much up to you to decide what fits you needs best.

    The database setup part is not really Qt related, you should rather use a more specific forum, you'll get better answer there.

    To get started you should read the "QtSql module documentation": and examples, this will put you on the right track

    Hope it helps

  • Thank you for that wery much ! I will look at those links as soon i resolve some issues with mysql server configuration .. it gives me a headache already! I have stumbled on a problem with some JDBC connectors in LibreOffice.. I thought i will use it to start editing seems so daunting. Not simple at all! But i know i have to look on other place for help on that

  • Lifetime Qt Champion

    Try searching for LAMP, this might help you get started a bit easier.

  • I don't really need PHP and Apache.. :( I just want to create some database
    to store bookkeeping data. Is it possible to create MySQL and edit database directly from C++ or QML inside of Qt IDE without needing to install mysql server and all of that ?

  • Lifetime Qt Champion

    Accessing the databases from C++, ? Yes
    Having a MySQL database without a MySql server ? No

    Tools for managing the server should come with the installation of the server, having a LAMP installed you could use phpmyadmin to do the administrative tasks on your server (like creating a database and handling and adding a non root user) with a friendly interface

  • Thank you, i will go ahead now and try that solution and see how it will behave.

  • It seems that is it ! :) thank you for help! I am yet to be asking questions though! :D

  • Lifetime Qt Champion

    You're welcome !

    Don't hesitate to ask ! But please, create a new thread for your each new questions.

Log in to reply