Features

PugDB delivers exceptional performance with a modular architecture designed for modern applications.

⚡ Performance

  • ✓ 5.8x faster than PostgreSQL - Verified YCSB benchmarks (4.3x - 7.9x range, single-threaded sequential workload)
  • ✓ 3.5x faster than ScyllaDB - Verified YCSB benchmarks (2.3x - 4.4x range, single-threaded sequential workload)
  • ✓ Sub-millisecond latency - P50: 0.029-0.072ms, P99: 0.076-0.272ms
  • ✓ Excellent concurrency - Scales well up to 32 threads
  • ✓ Optimized batch operations - Connection reuse and parallel processing

*Benchmark Methodology: Results from single-threaded sequential YCSB workloads (last updated: January 2026). Both PugDB and competitors tested identically. Real-world performance with concurrent workloads may differ.*

💾 Storage Engines

Memory Storage - Beta - Well Tested

HashMap and BTreeMap backends optimized for high-performance in-memory operations. 813 tests, 80%+ coverage.

LSM-Tree Storage - Beta - Well Tested

Write-optimized persistent storage engine with automatic compaction, crash recovery, and WAL. 51 unit tests + integration tests.

Partitioned Storage - Beta - Well Tested

Horizontally scalable storage with partition management, stress-tested concurrency, and comprehensive crash recovery. 6+ test suites.

File System Storage

Not available in v2 (intentionally not migrated from v1).

🏗️ Modular Architecture

PugDB follows a clean, layered architecture with five distinct layers:

  • • Foundation Layer - Core abstractions and memory storage
  • • Extensions Layer - Advanced storage engines, query language, monitoring
  • • Distributed Layer - Server, client, and clustering capabilities
  • • Cloud Layer - S3-compatible storage and intelligent tiering
  • • Application Layer - CLI tools and utilities

🔧 Additional Features

Compression Support

LZ4, Zstd, Gzip, and Snappy compression algorithms for efficient data storage.

Monitoring & Metrics

Prometheus metrics, health checks, and performance monitoring hooks.

Query Language

Beta (Approaching Production) SQL support with 856+ tests passing. Window functions (100% GA), JOINs (100% GA), subqueries (95% GA), query optimization (100%), and transactions (90%).

Privacy-First

Encryption support, audit logging, and offline-first architecture.

Multi-Language Support (FFI)

C-compatible FFI bindings enable integration from Python, Go, C++, Node.js, and virtually any programming language. Use PugDB's high performance regardless of your tech stack.