PostgreSQL dialect and protocols

PostgreSQL

Support for SQL (dialect PostgreSQL) is implemented in Tengri.

In particular supported:

  • Basic syntax elements of SQL dialect PostgreSQL:
    SELECT, INSERT, UPDATE, DELETE, JOIN, WITH, UNION.

  • Window functions

  • Working with JSON via SQL

  • Principles ACID

  • Transactions

  • Transactional data integrity

  • Data isolation at the Repeatable read level

  • JDBC-driver PostgreSQL

Data loading

The operability of data loading tools (Airflow, dbt) and analytics tools (BI, ML) is guaranteed due to the ability to connect via JDBC-driver PostgreSQL.

All BI- and ETL-tools work as if it were PostgreSQL.

Analysts don’t need to retrain on new tools.