Pandas → QuestDB from Jupyter: the fast path to time-series SQL (ILP + PGWire) Meta description:Move time-series data from Pandas…
Read More
JSONB Without Regret
JSONB Without Regret: When to Model vs Index Paths Decision tree + costed examples for PostgreSQL engineers Introduction — the…
Read More
Tuning Doris for Spiky Traffic
Tuning Doris for Spiky Traffic: Nereids knobs, pipeline parallelism, and MV selection heuristics Meta description (158 chars):Practical Apache Doris tuning…
Read More
Materialized Views in QuestDB
Materialized Views in QuestDB: Real-Time Rollups Without a Lambda Architecture Meta (155–160 chars):Precompute time-series rollups in QuestDB with materialized views.…
Read More
From Lake to Warehouse with Apache Doris
From Lake to Warehouse with Apache Doris: Querying Iceberg/Hudi/Hive via Multi-Catalog (and Designing Tiered Storage) The real-world problem (and why…
Read More
QuestDB Query Engine Internals
QuestDB Query Engine Internals: Vectorized Execution, JIT, and Page Frames Why this matters (hook) You optimized indexes. You pruned partitions.…
Read MoreDesigning for Semi-Structured Data in Snowflake
Designing for Semi-Structured Data in Snowflake: VARIANT, Nested JSON, and Search Optimization Service Hook: Your product logs, clickstream events, and…
Read MoreZero-Copy DataOps in Snowflake
Zero-Copy DataOps in Snowflake: Time Travel, Clones, and Safe Schema Evolution Hook: Your analysts need new columns on Monday, finance…
Read MoreLoading Data the Cloud-Native Way
Loading Data the Cloud-Native Way: OPENROWSET from Blob Storage to Azure SQL at Scale Hook: You’ve got terabytes of CSV/Parquet…
Read More
Snowflake Cost Optimization
Snowflake Cost Optimization: The Hidden Techniques Most Engineers Miss After working with dozens of engineering teams who’ve seen their Snowflake…
Read More
