Concurrency model
agentOrc is designed for multiple agents sharing one database. Within a process, write-critical sections are serialized. Across processes, SQLite WAL mode coordinates readers and writers.
Guarantees
- ACID transactions for writes
- Prepared statements
- No partial memory + embedding inserts
- Crash-safe commits under WAL