v0.3.0: Dual-Engine Storage Layer (SQLite & PostgreSQL)

Kuben v0.3.0 — Dual-Engine Storage Layer (SQLite & PostgreSQL)

Kuben v0.3.0 brings a production-ready persistence layer, offering zero-dependency embedded operation with SQLite and scalable multi-node clustering with PostgreSQL.

---

Key Highlights

• Dual-Engine Architecture (crates/kuben-store):
  • Embedded SQLite 3: Write-Ahead Logging (WAL), synchronous normal, and busy timeout handlers for embedded, zero-ops deployments.
  • PostgreSQL 16+ Engine: High-concurrency connection pooling via sqlx::postgres for multi-replica clustered environments.
• Atomic Embedded Migrations:
  • Database schema migrations compiled directly into the binary using sqlx::migrate!.
  • Advisory lock synchronization prevents migration races when multiple instances boot concurrently.
• Core Repositories:
  • UserRepo: User lifecycle management with email uniqueness constraints.
  • SessionRepo: Cryptographically secure stateful sessions with sliding expiration windows.
  • AuditRepo: Append-only audit logs tracking all control-plane modifications.
• Cross-Engine Parity:
  • Automated integration test suite validating identical semantics across both SQLite and PostgreSQL backends.