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.
budibase_guide_mysql.sql
2KB
Binary
MySQL Demo DB Script
budibase_guide_postgres.sql
3KB
Binary
Postgres Demo DB script
Last modified 13d ago
Export as PDF
Copy link