Skip to content

DecentDb

Durable. Fast. Embedded.

DecentDb is an embedded, single-machine relational database engine focused on durable ACID writes and fast reads.

Features

  • ACID Transactions - Full durability with WAL-based persistence
  • Single Writer + Many Readers - Optimized for read-heavy workloads
  • PostgreSQL-like SQL - Familiar syntax for common CRUD operations
  • Efficient Substring Search - Trigram inverted index for LIKE '%pattern%' queries
  • Cross-Platform - Linux, macOS, Windows support

Quick Start

# Install DecentDb
nimble install decentdb

# Create a database
decentdb exec --db=mydb.ddb --sql="CREATE TABLE users (id INT PRIMARY KEY, name TEXT)"

# Insert data
decentdb exec --db=mydb.ddb --sql="INSERT INTO users VALUES (1, 'Alice')"

# Query
decentdb exec --db=mydb.ddb --sql="SELECT * FROM users"

Use Cases

  • Music Library Apps - Fast queries across artists, albums, tracks
  • Embedded Applications - Local data storage with SQL interface
  • Analytics & Reporting - Aggregate functions and GROUP BY support
  • Search-Heavy Workloads - Trigram indexes for text search

Performance

  • Point lookups: P95 < 10ms
  • FK joins: P95 < 100ms
  • Substring search: P95 < 200ms
  • Bulk load: 100k records < 20 seconds

Getting Started