Wappler documentation
Database Operations
Browse Database Operations tours: Quick Overview, Connections, and Queries.
Choose a Database Operations tour to start.
Setup & read
How database actions fit togetherThe role of connections, queries and record changes in a Server Connect workflow.Connecting to a DatabaseWappler’s powerful visual server-side tools allow you to easily connect to your Database in a few clicks. Before you create your databse connection, make sure to setup the target(s) for your project (Creating Database QueriesAfter you created your Database Connection, now it's time to setup a Database Query. The first thing we need to do is to create a new API Action (also known as Server Action). The API Actions are locaApplying Dynamic PagingYou can add paging to your dynamic data, using the paging generator included in Wappler. First, you need to create a server action: And add a name for it. We call it - records_paged: Right click steps
Write operations
Insert Database RecordCreating an insert record form with Wappler is an easy task as Wappler generates the form for you. The first thing you need to do is to create a server action, so open the Server Connect panel: Then, Update a database recordA complete update action: validate the record ID, map form values, filter the update and check the saved record.Delete Database RecordsYou can delete database records using the built in Delete Database step in server connect. We will add a delete button to an existing repeat region, which shows the records on our page - so when click