Zero-Account Cryptographic Enclaves: Why Microservices Don't Need Postgres Just to Store a Password
A critique of the multi-tier enterprise secret manager architecture, and a case for self-contained single-blob SQLite Write-Ahead Logging (WAL) with AES-256-GCM authenticated encryption.
1. The Secret Manager Bloat Paradox
Over the past decade, secrets management has drifted from simple cryptographic security into complex enterprise SaaS sprawl. To store a 32-character database password, modern tools often demand:
- A PostgreSQL 15 or MySQL database container with persistent storage volumes.
- A Redis 7 in-memory cache for session management and rate limiting.
- A web backend written in Go or Node.js running interactive authentication APIs.
- Mandatory browser onboarding flows requiring organization IDs, team invites, and interactive 2FA tokens.
2. The Single-Blob Alternative
Sovereign Vault replaces the 3-tier database architecture with an embedded, atomic, single-file SQLite database configured with:
PRAGMA journal_mode = WAL;
PRAGMA synchronous = NORMAL;
Every write transaction is atomic. Readers never block writers, and writers never block readers.
The entire database is stored as a single file (vault.db) on the attached volume.
Backing up your entire secrets estate is as simple as copying one file.