Database Suggest with Qt Framework
I want to make an desktop application to manage document database.
- 1 server pc
- 3-4 user
- Lots of files(document)
My aim is read the documents with sensor and save the database. Only document's id and reading time information.
So, to make this project for my office, what is the best and free solution with Qt?
For example, Qt with MySql or Qt with xxxxSql or whatever? I'm not a database expert. I need a free and correct solution my project.
Thanks four your support.
If u want ev everything free better go MySQL on ubuntu. It should work. U can check how to work with qt and db in google.
@ideadesigner "read the documents with sensor" - what does this mean? What sensors? How can sensors read documents?
If I understand you correctly (your description is unclear) you do not want to store documents in the db but some information like id (what ever it is) and access time? 3-4 users and small amount of data? Then you can just use SQLite - no need to install a SQL server then.
I've tried postgresql database and I've watched and red the qt examples.
Sorry for unclear explanation.
From my GUI, I will query the document's last RFID log.(The document's place and document's reading time from hardware)
Documents are tagged with RFID sticker.
- I will read the documents's sticker with UHF hardware.
- Amount of query transaction about ~200-300 in a day.
- All of the documents about ~20000.
@ideadesigner Well, you can use MySQL or PostgreSQL, both are free and supported by Qt.
@jsulm Thanks, I have used PostgreSql and it worked. Also, I tried SQLite and it is easier than PostgreSql.
No setup required and SQLite's querying interface on Qt is easier.
@ideadesigner Yes SQLite is very easy to use as there is no server to install/configure and no connection between server and client needed.
Qt opensource can connect to any SQL server, even without having the specific driver using the ODBC driver.