Connecting to a remote Postgres Server

Xojo is new to me and before I invest time and money I want to know. Can Xojo connect to a remote Postgres database server by default? Or do you have to buy additional add-ons/plugins?

All of the purchase options for Xojo include the plugins required to connect to Postgresql… Except the “Lite” and “Mobile” licenses.

1 Like

This has to be done with an api not a direct connect.

Well that’s not true. If the user has a VPN or an ssh connection, remote database connections are certainly possible.

Now… you shouldn’t connect directly to a database over the internet. Without some other sort of protection, and yes, an API is one way to solve it, but there’s nothing that prevents you from doing it.

You are right, I connect 10 users to the server via WireGuard (VPN). Access to the database is only possible within the VPN network.

1 Like