Q&A

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

Bigquery #

• Starting with v0.22.0, LESQL supports Google Cloud Bigquery

See Bigquery for configuration

MariaDB / MySQL #

• MariaDB and MySQL support is planned, but not developed yet. See issue Add mariadb/mysql support