It’s easier for me to store my data offsite and use DreamFactory to provide a REST API.
First I tried to do this by loading my data into a Postgres database hosted on a RAMNode Debian VPS. I created a DreamFactory service for a remote database and filled in all of the details. It failed to connect, because I could not specify on the RAMNode/Debian/Postgres side what IP address to allow for the connection. I then tried to edit pg_dba.conf, postgres.conf, and iptables in Debian to allow any IP address to connect, but asides from creating a security issue, it ended up screwing up the database configuration and not working.
As a 2nd attempt, I tried loading the data into Google’s CloudSQL hosted MySQL database. I created a user for DreamFactory and a static IP, then provided those details to DreamFactory via the “Services” tab. Again, the service failed to connect because on Google’s side they require that you specify the external IP addresses allowed to connect to your Cloud SQL instance (and you can’t specify “all IP addresses”).
Is there a solution? I’d like to make Cloud SQL work, but I don’t know what IP DreamFactory will use to connect.