Howdy, I decided to move forward with Wappler after using many other platforms. I am going through videos and training. I have created a database connection to a mysql 8 server in a datacenter and with the database Connections tool, I can see the tables from the database and pull/view data in each table.
I have no real pages, brand new blank project. Problem - following videos from ken, when I go into the server actions, I create a new folder then “add” a new action, I name it “test_action”, I then goto the execute - steps and create a new “database Connection” step,
Problen - on the connection properties, my database connection is not visible. The project is using node.js , own server with local docker setup for development. The database is in a datacenter…
Any idea why I cannot select the DB that I set up a connection with, in the connection properties it says “empty list” ?
Did you set up the server connect connection? In your first screen shot, I see that the direct connection is setup. The direct connection allows you to directly interact with the database to view and edit the database directly. The server connect connection is what allows your server actions to interact with the database.
Recheck the direct database connection, you need that.
Both direct database connection and server connect connection are used, just for different things.
Direct database connection - Manipulate the database directly. So you can add tables, add fields, add data, change data, and delete data directly from the database. This is most commonly used by the web developer (such as yourself)
Server connect connection - Allows the server actions to interact with the database. So you can do a server action for inserting data, updating data, querying data, deleting data. (This provides the server actions that users of your website or application will use)
ok, it is there now… I closed wappler and re-opened… I am sorry for your wasted time… I am started to really like this product, much better than Caspio and bubble… thank you very much for helping!!
