I am in need of some good advice. I have a small desktop program written in Tk. It normally uses a local SQLite database to save/read data. Now I want to give it the possibility to query some data I want to store online on a MySQL database. This would give me more freedom to control/update/etc the data the users can query. I have to admit this is my first attempt to let a desktop application access an online database, I beg for mercy.
The first possibility is to give the application direct access to the database. I have already implemented it and it just works. When a user starts a query, results are presented to the Desktop app. However, I have some obvious concerns about this approach as it exposes the database to the external world through my desktop apps. Even if the database does not contain any sensitive data, I guess this is not good practice. Am I right?
Sorry if my questions are naive.
I read online that I could/should build a web service layer between the desktop app and the database. What is the most basic Perl solution/modules to achieve this? Could you point me to some information keeping in mind I really need a simple solution to implement? It is a small project. Any online database service that you know work well with the Perl proposed solution?