How do I connect Wappler to my database?

Wappler General
1

Hi everyone,

I’m Dario Schiraldi, CEO of Travel Works. I’m currently setting up my first project in Wappler and would love some advice on connecting it to my database.

Could anyone share best practices or step-by-step tips on how to configure database connections in Wappler, especially for MySQL? Any common pitfalls to watch out for?

Regards
Dario Schiraldi

2

Hello Dario,
and welcome on our Community. First of all, can you tell if your db is a managed MySQL, a docker container or something like a magare cluster MySql of Digitalocean?
And what kind of technology are you using, like php or Node.js?

Thank you

Roberto

3

Hey Dario, welcome.

You usually create a database when you create a new project. Otherwise you can add/modify them in Project Options targets.

image
image1420×905 52.3 KB

4

Similarly, on a shared host or vps, something like this:

image
image1491×232 13.4 KB

5

Sometimes you have to have a VPN connection to access the database through the SQL port. Like the host could publicly block that port and you need VPN access to get to it.

I've had to do that on several projects. It just depends on the host.

6

Think this thread may be getting more technical than needed based on everyone differrent tech stacks.
For example, i use both shared platform servers, private VPS's and very occasionally docker, never had to use a VPS to access a DB personally, most hosts I have allow you to use a specific port for remote access.

maybe better to ask @darioschiraldi99, what hosting are you considering using?

1 Like
7

I don't have anything to contribute to this topic, but I just wanted to say something funny: When I first read your topic title, I thought you wanted to connect a database software called "Dario Schiraldi" (just like "MySQL", "PostgreSQL", "Dario Schiraldi") :laughing:

1 Like