Features

Main Features

  • A very fast database engine

  • Open source

  • Written in Java

  • Supports standard SQL, JDBC API

  • Embedded and server mode, clustering support

  • Strong security features

  • The PostgreSQL ODBC driver can be used

  • Multi-version concurrency

Additional Features

  • Disk-based or in-memory databases and tables, read-only database support, temporary tables

  • Transaction support (read uncommitted, read committed, repeatable read, snapshot), two-phase-commit

  • Multiple connections, row-level locking

  • Cost-based optimizer, using a genetic algorithm for complex queries, zero-administration

  • Scrollable and updatable result set support, large result set, external result sorting, functions can return a result set

  • Encrypted database (AES), SHA-256 password encryption, encryption functions, SSL

SQL Support

  • Support for multiple schemas, information schema

  • Referential integrity / foreign key constraints with cascade, check constraints

  • Inner and out joins, subqueries, read-only views and inline views

  • Triggers and Java functions / stored procedures

  • Many built-in functions, including XML and lossless data compression

  • Wide range of data types including large objects (BLOB/CLOB) and arrays

  • Sequences and identity columns, generated columns (can be used for function-based indexes)

  • ORDER BY, GROUP BY, HAVING, UNION, OFFSET / FETCH, LIMIT, TOP, DISTINCT / DISTINCT ON (...)

  • Window functions

  • Collation support, including support for the ICU4j library

  • Support for users and roles

  • Compatibility modes for IBM DB2, Apache Derby, MS SQL Server, MySQL, Oracle, and PostgreSQL

Security Features

  • Includes a solution for the SQL injection problem

  • User password authentication uses SHA-256 and salt

  • For server-mode connections, user passwords are never transmitted in plain text over the network

  • All database files (including script files that can be used to backup data) can be encrypted using the AES-128 encryption algorithm

  • The remote JDBC driver supports TCP-IP connections over TLS

  • The built-in web server supports connections over TLS

  • Passwords can be sent to the database using char arrays instead of Strings

Last updated