# storage

concrete storage systems, from the building side.

- [columnar files](columnar-files.md) — parquet + duckdb over object storage: partition by the skewed dimension, range reads, CORS, bytes per row
- [postgres](postgres.md) — pool-singleton and batch-upsert patterns for asyncpg-shaped clients
- [redis/](./redis/) — streams, eval-lua, embedded
- [sqlite/](./sqlite/) — fts5, sargable joins, point-lookup benchmarking + pager hot paths
- [turbopuffer](./turbopuffer.md) — vector store operations: id limits, schema evolution, cold namespaces, stale attributes
- [turso](./turso.md) — hosted libSQL: hrana vs export endpoints, auth model