Qt connection to the database, via the Internet (desktop application)
Good afternoon, I wanted to ask. I wrote an application on Qt that interacts with the database (MySQl). Is it possible in any way to organize an application for this database if the database is on a remote PC (on the Internet). If so, what do you need to do (where to put the database or upload to the server) and how to connect to it in this case?
Hi and welcome to the Qt forum,
Here is a good starting point using DSN
Hi and welcome to devnet,
To add to @Eddy, please secure the connection. It's never a good idea to expose a database directly over internet.
Currently, the technique commonly used is to expose a web service that allows to interact with the database in a known and restricted manner through a REST API.