- Potential performance boost (no need to serialize->transfer->deserialize data on inserts)
- Easier deployment (no external service dependencies)
- Simple architecture implies close to linear insert speed
Requirements:
- Fault tolerance (with write-ahead logs or something similar)
- ACID transactions
- Indexes
We can check something like https://www.litedb.org/ (performance comparison - litedb-org/LiteDB#1354)