Hybrid Embedded-Server Database Architecture with Lock-Free Concurrency

We present a hybrid database architecture that enables simultaneous operation of embedded (in-process) and server (network-accessible) modes on the same persistent data store without mode switching overhead. Our system uses lock-free concurrency primitives including atomic state transitions (Atom-icU8) and concurrent write buffering (DashMap) to enable multiple access patterns without mutex contention. This architecture addresses a fundamental limitation in existing database systems whereusers must choose between embedded deployment (SQLite) or server deployment (PostgreSQL) but cannot have both simultaneously.