Allowing connections to server

Databases
1

I’m just starting with remote databases and have found that by default external connections to remote database servers are not allowed by VPS because it seems to compromise security.
But as far as I know xojo cloud and similar services allow them and this is actually the sense for desktop applications connecting with remote servers.

I plan to develop a web app, no problem as this will be calling localhost but also a desktop application connecting with the same database, which is the correct way?

  • Using Xojo database server capabilities
  • Adding a method to my web app to receive json or xml data from the desktop app and only allowing the web app to actually connect to the database

In case you prefer the second method, can someone instruct me on how to do this? Tutorials or samples are highly welcome.

2

I (and I think most) would recommend this technique.

I did a 2-part webinar earlier this year on this topic:

REST Web Services with DB

3

Paul,

thanks so much, this is of great help. Just watching your awesome tutorials.

4

100% agree with you Alejandro. The webinars from Paul are a big help in many cases. I have learned a lot from them!

THANKS (= BIG Thanks) to Paul!