Internal supports the latest versions of MariaDB 10.2, 10.3, 10.4, 10.5, and 10.6.
To add MariaDB, you'll need to select MySQL as your data source and enter your credentials.
- Display Name: Give your data source a name for use within Internal.
- Host: The hostname or IP address of your data source.
- Port: Port to connect to.
- Username: Credentials for this data source.
- Password: Credentials for this data source.
- Database: The name of the database (this must match the actual name of your MariaDB database).
When you connect MariaDB to Internal, we'll generate the following for you automatically:
- A resource for each table in your database. Think of these as prebuilt SQL queries, so you don't have to write queries for everything.
- An insert, update, and delete function for each table in the database (if the connecting user account has these privileges).
In some cases, you may want to create a view that combines data from various tables or elevates nested JSON fields to top-level attributes. To accomplish this, create a custom SQL Resource (a.k.a. SQL Query). To enable custom operations that write directly to your database (e.g. bulk actions), create a custom Function.
While Internal enables filtering and sorting on all columns, we recommend indexing columns on large tables to improve performance. Supported operators include =, !=, <, <=",">, >=, IN, ILIKE for all data types except geometry, point, linestring, polygon, multipoint, multilinestring, multipolygon, geomcollection, and json. Only the = and IN operators are supported for the latter. </,>
Updated 6 months ago