Which databases systems are supported? #
- 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 20.0 and 20.1 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.
- MariaDB and MySQL support is planned, but not developed yet. See issue Add mariadb/mysql support