MariaDB
Overview
Connect Superblocks to MariaDB to build apps with read and write access to a MariaDB database:
- Read data from a database and utilize it in API steps or UI components
- Save information retrieved by other API steps or UI components by writing data to a database
Setting up MariaDB
1. Add integration
Select MariaDB from the integrations page.
2. Configure settings
Fill out the form with the following settings:
| Setting | Required | Description |
|---|---|---|
| Name | TRUE | Name that will be displayed to users when selecting this integration in Superblocks |
| Host | TRUE | Hostname or IP address to connect to |
| Port | TRUE | Port to use when connecting to MariaDB |
| Database Name | TRUE | Name of database to connect to |
| Database Username | TRUE | Username to use to connect |
| Database Password | TRUE | Password for database username |
| Enable SSL | FALSE | Connect via SSL if selected |
| Use a self-signed SSL certificate | FALSE | Provide Server CA, Client Key, and Client Cert if selected |
3. Test and save
Click Test Connection to check that Superblocks can connect to the data source.
info
If using Superblocks Cloud, add these Superblocks IPs to your allowlist (not necessary for On-Premise-Agent).
After connecting successfully, click Create to save the integration.
4. Set profiles
Optionally, configure different profiles for separate development environments.
success
MariaDB connected Now you can use MariaDB in any Application, Workflow, or Scheduled Job.
Creating MariaDB steps
Connect to your MariaDB integration from Superblocks by creating steps in Application APIs, Workflows, and Scheduled Jobs. You can configure a Superblocks MariaDB integration with read only, read/write, or write only users. You can then configure a Superblocks MariaDB step to read from a database, as well as modify/delete data. To get started, enter your SQL query into the text area of the MariaDB step. Then click "Run" to see the Result and Executed SQL statement below.
info
See a tutorial on how to use inline editing for bulk updating and a basic CRUD guide
Use cases
Applications
Create an admin dashboard that reads from MariaDB and other sources. Mix in APIs to allow support agents to refund orders, update shipping statuses, or transform large datasets in a single UI.
Workflows
Enrich customer order data within MariaDB with shipping data from Snowflake or other datastores.
Scheduled Jobs
Send out a daily report via email of new customer bookings.
info
Note that javascript may be injected via {{ }}. Here we use javascript's moment package to easily manipulate the timestamp to the start and end of the previous day.
Troubleshooting
Check out our guide on common errors across database integrations, in addition to common MariaDB connection issues. If you are encountering an error that you don't see in the guide, or the provided steps are insufficient to resolve the error, please contact us at help@superblocks.com.