Resource hub

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 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.

Build a small inventory API with Hono and Bun.SQL. Use Postgres transactions to prevent overselling, replay successful requests, and release stock safely.