Clear questions and runnable code get the best and fastest answer |
|
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
Hello 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? In reply to online database for desktop app by Anonymous Monk
|
|