50.8kResource hub
Engineering
View all EngineeringColumnar storage formats: Parquet, ORC, and Arrow explained
Al Brown • Last updated: May 8, 2026
How Apache Parquet, ORC, and Arrow lay out columnar data, and why they coexist instead of converging on one format.
How columnar storage works
Al Brown • Last updated: Jun 1, 2026
A mechanism-level look at how columnar storage works on disk (per-column blocks, zone maps, and predicate pushdown), with ClickHouse MergeTree and Apache Parquet internals side by side.
Best Postgres extensions for analytics in 2026: pg_clickhouse, pg_duckdb, pg_lake and more
Al Brown • Last updated: Oct 30, 2026
How pg_clickhouse, pg_duckdb, pg_lake, TimescaleDB, Citus columnar and AlloyDB speed up analytics on Postgres, where each one runs its compute, and which to choose.
Build a habit tracker with Next.js, Drizzle ORM, and ClickHouse Managed Postgres
Al Brown • Last updated: Oct 27, 2026
Build a Next.js 16 habit tracker with Drizzle ORM and node-postgres on ClickHouse Managed Postgres. A composite primary key keeps one check-in per day, and a window query computes streaks.