Build a CRUD app- SQL

At the time of writing, Budibase has fantastic support for Postgres, MySQL and MariaDB. We intend to add more SQL connectors.

We automate all the most common SQL queries - INSERT, UPDATE, DELETE and SELECT by ID. You can also write custom queries if you need something more complex or use stored procedures.

This guide will take show you how to build a “Vehicle Maintenance Log” application. For this guide, I will use Postgres. As far as Budibase is concerned, the process is the same, regardless of your database.

We will use the following table structure.

Below are Postgres and MySQL scripts to create the necessary tables, and insert test data.

2KB

budibase_guide_mysql.sql

MySQL Demo DB Script

3KB

budibase_guide_postgres.sql

Postgres Demo DB script