MySQL and Qt5 how to start? by Newbee

eniac

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 !! :)

SGaist

Hi and welcome to devnet,

Everything database driver related can be found "here":http://doc-snapshot.qt-project.org/qt5-stable/qtsql/sql-driver.html 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":http://doc-snapshot.qt-project.org/qt5-stable/qtsql/sql-programming.html and examples, this will put you on the right track

Hope it helps

eniac

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 data..it seems so daunting. Not simple at all! But i know i have to look on other place for help on that

SGaist

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

eniac

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 ?

SGaist

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

eniac

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

eniac

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

SGaist

You're welcome !

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