amelielabs/amelie

Full Parallelization of IO and Compute

Amelie is a lightweight, full-featured, in-memory OLTP SQL relational database that allows full parallelization and lockless transaction processing.

It scales linearly with the number of CPU cores both for IO and Compute separately, performs automatic partitioning, and generates parallel group plans for all types of queries.

Amelie can be used both as a stand-alone server or as an embeddable database library.

Learn more about How It Works and Get Started.

Join us on Slack.

(Official Docker image is coming soon)

Asynchronous Replication

Amelie has support for Hot Backup and Async Logical Replication, which allows fault-tolerant primary-replica setups to be created.

Easy to use

It works over HTTP and does not require additional client libraries. Any modern programming language or tooling that supports HTTP and JSON can be used directly.

Additionally Amelie support embeddable async API interface which allows it be used as a part of your application.

Compiles and distributes as a single binary and a shared library.

Development and Features

The SQL dialect is based on ANSI SQL, PostgreSQL and extended with unique features, such as native JSON support and Lambda aggregates.

The short list of features:

• Strict Serializable ACID Multi-statement transactions
• Secondary indexes (Tree/Hash)
• CTE with DML RETURNING
• Parallel partitioned DML including UPSERT
• Parallel JOINs
• Parallel GROUP BY and ORDER BY
• Parallel VECTOR operations
• Partitioned Generated Columns
• Native VECTOR support
• Native JSON support
• Parallel snapshotting and recovery
• Hot Remote Backup
• Asynchronous Logical Replication
• HTTP API
• Embeddable Async API

---

Build and Install

OS

Currently only Linux environments are supported.

Dependencies

• cmake
• clang or gcc
• openssl
• libpcre
• libzstd

Build Release

git clone https://github.com/amelielabs/amelie
cd amelie
make release

Build Release (pass cmake options directly)

git clone https://github.com/amelielabs/amelie
cd amelie
cd build
cmake -DCMAKE_BUILD_TYPE=Release -DCMAKE_INSTALL_PREFIX=<install_path> .
make

Build Debug

git clone https://github.com/amelielabs/amelie
cd amelie
make debug

Running tests

make
cd test
../build/amelie test