Internal supports the latest versions of MariaDB 10.2, 10.3, 10.4, and 10.5.
To add MariaDB, you'll need to select MySQL as your data source and enter your credentials.
When you connect MariaDB to Internal, we'll generate the following for you automatically:
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. </,>