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
• LanceDB — independent native thread pools and process limits
• postgres — pool-singleton and batch-upsert patterns for asyncpg-shaped clients
• redis/ — streams, eval-lua, embedded
• sqlite/ — sargable queries and keyset paging, fts5, point-lookup benchmark configuration
• turbopuffer — vector store operations: id limits, schema evolution, cold namespaces, stale attributes, namespace listing
• turso — hosted libSQL: export endpoints vs hrana cursors, pipeline batching, cloud pragma no-ops, per-query usage