Tag: #duckdb
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 11 posts
How to Read the 2026 Data Tooling Landscape — Layer-by-Layer Decisions, Not a Tool List
On July 28, 2026, "A Data Tooling Landscape Guide for Developers" landed on GeekNews and picked up 51 points. It is a good map, but a map does not choose your destination for you. This post redraws the same landscape acr
2026-07-31 · 16 min read #data-engineering#lakehouse#iceberg#duckdb#data-platformDuckDB 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#parquetPython Ecosystem 2026 Deep-Dive — Python 3.13 · FastAPI · Django 5 · Litestar · SQLAlchemy 2 · Polars · Pydantic 2 · Ruff · uv · mypy
A 2026-05 snapshot of the entire Python ecosystem in one post. Python 3.13 free-threaded build and JIT, FastAPI / Django 5 / Litestar / Flask 3 / Sanic / Robyn, SQLAlchemy 2 with Polars / DuckDB / pandas 2, the Pydantic
2026-05-16 · 20 min read #python#fastapi#django#litestar#sqlalchemyDatabase Engines 2026 Deep-Dive — Postgres Won the API, ClickHouse and DuckDB Won Analytics
PostgreSQL 17/18, MySQL 9, MariaDB 12, SQLite + libSQL + Turso, DuckDB 1.x, ClickHouse, StarRocks, Doris, Druid, Pinot, TiDB, CockroachDB 25, YugabyteDB, Cassandra 5, ScyllaDB, Aerospike, Neon, Supabase, PlanetScale, Xat
2026-05-16 · 17 min read #database#postgresql#mysql#clickhouse#duckdbData Lakehouse & Modern Data Engineering 2026 — Iceberg / Delta / Hudi / Paimon / Tabular (Databricks acquisition) / Trino / Spark 4 / Flink 2 / DataFusion Deep Dive
Data engineering in 2026 is no longer the era of "data warehouse vs data lake." Apache Iceberg emerged as the winner of the 2024-25 table format war — Netflix, Apple, LinkedIn, Stripe, Airbnb all converged on it. Databri
2026-05-16 · 30 min read #data-engineering#data-lakehouse#apache-iceberg#delta-lake#apache-hudiPolars 1.x vs Pandas — End of an Era? A Modern DataFrame Deep Dive for 2026
Polars hit 1.x with a stable-API promise, Pandas 2.2 finally adopted PyArrow as a real backend, and the gravity of the dataframe world shifted. Is Polars actually replacing Pandas? This deep dive walks through the Rust p
2026-05-14 · 20 min read #polars#pandas#dataframe#apache-arrow#duckdbOLAP Engines 2025 Comparison Guide: DuckDB, ClickHouse, Snowflake, StarRocks, Pinot, Druid, Trino, Benchmark Traps, Engine Placement (2025)
Season 5 Ep 3. No single engine covers all of OLAP. DuckDB brings the single-node revolution, ClickHouse handles real-time OLAP, Snowflake and BigQuery offer managed convenience, StarRocks, Doris, Pinot and Druid take on
2026-04-15 · 12 min read #olap#duckdb#clickhouse#snowflake#bigqueryDuckDB 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#vectorizationDuckDB 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-lake