Which databases systems are supported? #
Postgresql & compatible #
- LESQL was developed for PostgreSQL 9.5, but we have tested it with PostgreSQL 10, 11 and 12 as well. So all PostreSQL versions >= 9 should work.
- As CockroachDB uses the wire protocol from PostgreSQL, LESQL works with CockroachDB out of the box. We tested CockroachDB 19.2, 20.1 and 20.2 with LESQL successfully.
- You can use LESQL with TimescaleDB as well, as it is an add-on to PostgreSQL, but we do not support the TimescaleDB specific stuff like ‘create_hypertable`. But we plan to add this in the future.
See Postgesql for configuration
See Bigquery for configuration
MariaDB / MySQL #