storage #

concrete storage systems, from the building side.

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