Storage Adapters
Otso ships with multiple storage backends.
Adapter interfaces
Section titled “Adapter interfaces”All adapters expose put(event), get(id), and query(...) methods. Custom adapters implement this interface.
Built-in adapters
Section titled “Built-in adapters”- SQLite – default local store; supports FTS and transactions.
- Postgres – for multi-user or hosted setups.
- FS-Markdown – writes events as Markdown files for simple sites.
- JSONL – append events to a newline-delimited log.
Trade-offs
Section titled “Trade-offs”| Adapter | Pros | Cons |
|---|---|---|
| SQLite | Simple, fast | Single writer |
| Postgres | Scales, concurrent | Requires server |
| FS-Markdown | Human-readable | Limited querying |