MariaDB, Internal tool, Data visualization, Low-codeMariaDB is a popular open-source relational database management system (RDBMS) and a drop-in replacement for MySQL. It was created by the original developers of MySQL, who were concerned about the future of MySQL after its acquisition by Oracle Corporation.

MariaDB offers a wide range of features including high availability, scalability, security, and compatibility with various programming languages and frameworks. It also provides a number of additional features over MySQL such as improved performance, enhanced storage engines, and support for a variety of data types. MariaDB is widely used by businesses, organizations, and developers for various applications including web-based, mobile, and cloud-based platforms.

Connect to MariaDB in Openblocks

Step 1: Create new data sources > Select MariaDB, and fill in the fields.

Step 2: Create MariaDB queries. Openblocks supports SQL mode and GUI mode. Select the one that suits you best.

Step 3: Finish your query, select a trigger method, and display the query result.

Using MariaDB in Openblocks

CRUD operations

When connected to MariaDB in Openblocks, you can perform create, read, update, and delete operations. In SQL mode, you can insert queries. If you are not familiar with SQL syntax, then you can use GUI mode for the following operations:

• Insert

• Insert, update if conflict

• Update

• Delete

• Bulk Insert

• Bulk Update

Access data

In both SQL and GUI modes, you can check the data structure in the data browser panel, and access query results via {{queryName.data}} anywhere in your app.

About Openblocks

Openblocks is an open-source low-code platform where you can find 50+ built-in components. It also offers excellent documentation to discuss technical details, present practical tutorials, and provide all the information you need know for building an app. On Openblocks, you can get connected to most databases and any API within clicks, design custom components, share apps with colleagues or customers, and more.

Start your first app now and feel free to reach the vibrant community on Discord if you encounter any issue or would like to share an idea!