Skip to main content

MariaDB

Provides access to MariaDB database using SQL queries via JDBC driver.

Connection parameters

{
"server": "",
"port": "",
"db": "",
"connString": ""
}

Supported Parameters

TypeValueDescription or Example
num, int, double==100
>>1.02
>=>=4.1
<=<=100
!=!=5
inin (1, 3, 10.2)
min-max1.5-10.0
stringcontainscontains ea
starts withstarts with R
ends withends with w
inin (ab, "c d", "e\"f\"")
regexregex ^(.+)@(.+)$
datetimeanytime
beforebefore 1/1/2022
afterafter 1/1/2022
today
this week
this month
this year
last year
min-max
April 2021
list<string> (1)
  • (1) default parameters are not supported

Supported output types

TypeSupported
INTEGER, SMALLINT
DECIMAL, NUMERIC
FLOAT, REAL, DOUBLE PRECISION
DATE, TIME
TIMESTAMP, YEAR
CHAR, VARCHAR, TEXT
JSON (1)
GEOMETRYlimited support (2)
BITlimited support (3)
BINARY, VARBINARY, BLOBnot tested
  • (1) supported as a string
  • (2) you get unreadable representation, but in query you can cast such a types to text (e.g. ST_AsText function)
  • (3) requires explicit cast (e.g. BIN function)

Supported features

  • Schema browsing
  • Join DB tables
  • Aggregation query
  • Connection test

See also: