Internal supports the latest versions of MySQL 5.6, 5.7, and 8.
When you connect MySQL 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. </,>