Remote DB on Digital Ocean

Ok I have reached a level of frustration that I need to reach out.

Firstly, love wappler, it’s outstanding and if I can get my little frustratiion figured it will transform what I do!

I’ve spend way too many hours now trying to figure out getting a remote DB working. I am sure I am being super dumb and missing something obvious so please point me in the right direction, I’ve trawled the docs, but whatever I try doesn’t work on the live site.

Set up is:

Docker deployment - NodeJS - MariaDB
Digital Ocean hosting no managed database, though tried that too!
Dev and production setups created in targets. with default mariadb settings for both.

Created tables in dev on wappler and built all crud - everything works tickety-boo locally.
Deployed to remote and no crud - form data not saving and hence not retrieving etc.

Am I wrong to expect Docker to have set up the db and tables on Digital Ocean and the connection just magically happening via the wappler production target settings?

I’m using the latest beta 5 wappler. I did also try a managed digital ocean db and adding connection details using CA cert in global DB connection properties, but no luck with that either.

I’m an old hand php coder, wanting to move to Node with this killer dev tool - but this remote DB understanding/getting working, is killing me.

If anyone can simply walk me through how to get this working I’d be super appreciative.

As said, I am sure I’m being dumb and missing the obvious, but thank you!

Community Page
Last updated: