{"data":{"slug":"clickhouse","name":"ClickHouse","tagline":"Column-oriented database for analytics","category":"databases","categoryName":"Databases","url":"https://clickhouse.com","github":"https://github.com/ClickHouse/ClickHouse","pricing":"open-source","hook":"ClickHouse makes billion-row queries feel instant.","whatsGood":"Analytics queries that would take minutes in Postgres complete in seconds. Column-oriented storage is perfect for time-series and event data. Compression is aggressive. The SQL dialect is familiar.","theCatch":"Not a general-purpose database—updates and deletes are expensive. Operational complexity for self-hosting. The learning curve for optimal schema design is steep.","verdict":"The analytics database when Postgres is too slow.","addedAt":"2026-08-19","featured":false,"domain":"Databases","subSpecialty":"Data","capabilities":[],"surfaces":["Self-host"],"ecosystem":["Multi-platform"],"licenseModel":"OSS/MIT","githubStars":49625},"related":[{"slug":"supabase","name":"Supabase","tagline":"Open-source Firebase alternative built on Postgres"},{"slug":"turso","name":"Turso","tagline":"SQLite at the edge with libSQL"},{"slug":"redis","name":"Redis","tagline":"The in-memory data store everyone uses"},{"slug":"upstash","name":"Upstash","tagline":"Serverless Redis and Kafka"},{"slug":"pinecone","name":"Pinecone","tagline":"Vector database for AI applications"}],"links":{"self":"/api/gems/clickhouse","html":"/gems/clickhouse","markdown":"/gems/clickhouse.md","category":"/api/gems?category=databases","categoryPage":"/stacks/databases"}}