QT Desktop Database Application and Remote Connection
-
Hi All,
I am in the process of developing a QT C++ based application using QT creator.
My application supposed to get user data and store the data in a database in a local server or in cloud.
The issue is that the data stored in the database should be able to access from a different location and different network.
At the moment I haven't decided on what database to use. I may have to go with a no SQL database based on my data structure.I would like to know, what is the best approach to go with to implement this? And what are the recommended technologies?
Appreciate if you can share any resources like tutorials or courses I can learn from.
Thanks!
-
@Radio1985 said in QT Desktop Database Application and Remote Connection:
I would like to know, what is the best approach to go with to implement this?
From your description it sounds like you need a database server.
What exact technology I can't say based on the information you provided. It depends on the data and what you want to do with it. Can be NoSQL or SQL. -
@jsulm
Thanks for the reply. Let's say the data contains some production data in a factory. An example of my data as follows:
Production Quantity: 1000 kg
Number of Bags Completed: 52
Raw Materials Used:
Test Results:
Sample 1 data 1 pass/fail
Sample 2 data 2 pass/fail
....
Data are mostly in text format.When you say a database server did you mean a cloud base database?
-
@Radio1985 said in QT Desktop Database Application and Remote Connection:
When you say a database server did you mean a cloud base database?
You wrote: "the data stored in the database should be able to access from a different location and different network". That means that you need a server which can be accessed from all locations where the access is required. Whether it is a traditional database server or cloud is again something you need to decide. Cloud would require less maintenance on your side I guess, but then you have to trust the cloud provider.
If your data has a well defined structure and you need the possibility to query it then I would recommend SQL.