So for my quest on how to connect a database I first tried to add a so called ‘dev database’ from the app platform dashboard. This is setup really easily.
However, when I want to connect to the database through Wappler I get this ‘the pool is probably full’ error. So I think that the issue is that my ip-address is not added as a trusted source for this database. I can’t seem to find this option for the dev database, sadly. (I did find it for the managed database, I use this for another project).
So I opened up a ticket with DO to see if this is actually possible or not:
Hi there,
Is it possible to add my own ip-address as a trusted source to a dev database that you can create on the app platform?
I know the app is automatically added, but I want my local dev version of the app to be able to connect to the database in a secure manner.
I do know this is possible with the managed database product. I use this for another project, already. Just wondering if this is possible for the dev databases.
EDIT
it turns out that it is not possible to add your own ip address to the trusted resources on a dev database. So you either have to disable that feature and allow any source to connect to your database (not recommended, but I tried and it does work) or upgrade to a managed database. I will do this tomorrow and get back with the results.
UPDATE:
Upgrading to a managed database was easy as pie. Just walk through some wizard on DO and make sure to add your own ip and the app as trusted sources.
Connecting to the managed database through Wappler gave me a connection timed out error. The fix for me was:
- deleting the trusted sources
- connecting to the db without those security settings
- re-adding the app and my ip as trusted sources
- connect to the db without errors this time
So all in all this app platform seems to be a total win for me. You don’t have to manage your ubuntu setup, you don’t need to fiddle with Traefik for your ssl, you don’t need pm2 or whatever to run different scrips if you like, it’s all done for you! For me this takes away a LOT of the hosting pain and brings Wappler closer to Bubble in terms of N00b friendliness.
Also, I quite like to run Wappler without docker desktop
Be sure to try this out!