Tag: #analytics
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 10 posts
DuckDB Gets a Client-Server Protocol — What Quack Changes and What It Doesn't
On May 12, 2026, the DuckDB team announced Quack — a client-server protocol built on top of HTTP that lets two DuckDB instances become client and server to each other, so the same database can be read and written concurr
2026-07-16 · 18 min read #database#duckdb#olap#analytics#data-engineeringDuckDB in Practice — The Era of Embedded Analytics That Ends on Your Laptop
Why is DuckDB, often called the SQLite of OLAP, so loved? We start from the architecture and cover direct Parquet querying, hands-on examples of window functions, PIVOT, and ASOF JOIN, zero-copy integration with pandas,
2026-06-12 · 14 min read #duckdb#database#olap#analytics#parquetDuckDB Internals Deep Dive — Embedded OLAP, Vectorized Execution, Morsel-Driven Parallelism, and Storage Format (2025)
DuckDB — the analytical engine that replaces Pandas and brings a ClickHouse-class OLAP database into your process. This post dissects DuckDB from the ground up: the journey from Mark Raasveldt and Hannes Mühleisens 2018
2026-04-15 · 24 min read #duckdb#olap#database#columnar#vectorizationColumnar Storage Deep Dive 2025: Parquet, ORC, Apache Arrow, Dremel — Why Analytics DBs Are 10,000x Faster
How Snowflake, BigQuery, and Spark query terabytes in seconds. A complete tour of Parquet Dremel structure, ORC, Apache Arrow in-memory format, RLE/Dictionary compression, and vectorized execution.
2026-04-15 · 13 min read #columnar-storage#parquet#orc#apache-arrow#dremelClickHouse Internals Deep Dive — MergeTree, Vectorized Execution, Distributed Queries, Keeper (2025)
The analytics engine behind Cloudflare, Uber, Bloomberg, and Yandex — processing tens of trillions of rows daily. This post dissects ClickHouse from the ground up: columnar vs row storage, the MergeTree family (Replacing
2026-04-15 · 15 min read #clickhouse#olap#columnar#mergetree#analyticsClickHouse MergeTree — The Complete Guide to Columnar, Sparse Index, Part, and Materialized View (2025)
Everything about ClickHouse MergeTree — the physical layout of columnar storage, parts and granules and the sparse primary index, why ORDER BY matters so much, projections and skip indexes, real-time aggregation with mat
2026-04-15 · 23 min read #clickhouse#olap#columnar#mergetree#analyticsElasticsearch Complete Guide 2025: From Search Engine to Log Analytics & Vector Search
Everything about Elasticsearch! Inverted index internals, mapping/analyzers, Query DSL, aggregations, ELK stack, vector search (kNN/HNSW), cluster operations, performance optimization, and interview questions.
2026-03-24 · 21 min read #elasticsearch#search#elk-stack#kibana#logstashDuckDB In-Memory Analytics and OLAP Guide
A guide to DuckDB in-memory analytics for OLAP workloads, covering query optimization, data formats, and integration patterns.
2026-03-15 · 28 min read #database#duckdb#olap#analytics#in-memoryDuckDB OLAP Analytics and Data Lake Guide
A guide to using DuckDB for OLAP analytics and data lake querying, covering in-process analytics, Parquet integration, and performance optimization.
2026-03-08 · 22 min read #database#duckdb#olap#analytics#data-lakeChatbot Performance Monitoring and Conversation Quality Analysis: From Metric Design to A/B Test Automation
A practical guide to chatbot performance monitoring and conversation quality analysis. Covers core metric design, tracing with LangSmith/Langfuse, automated quality evaluation pipelines, and A/B testing framework with co
2026-03-08 · 30 min read #chatbot#monitoring#analytics#ab-testing#langsmith