EEdna Maina·Oct 27Embedded retail analytics with DuckDB, dbt, Polars, and FastAPIHow to build a sub-16ms embedded retail analytics engine over 8,494 products and 1,094,411 customer reviews without cloud data warehouse overhead.9 min read·qdrant.hashnode.dev
BBrice Luu·Oct 26The spec already wrote half your ingestion scriptapisip reads an OpenAPI spec once, then downloads every list endpoint to JSONL or Parquet, typed from the spec and safe to run again.10 min read·bluu.dev
IIT-Craftsman·Oct 125 SQL window-function traps that show up in data engineering interviews (with runnable DuckDB examples)Default frames, ties, LAST_VALUE, filters before windows and sparse moving averages. Five small traps that separate knows SQL from writes correct pipelines.5 min read·itcraftsman.hashnode.dev
NNeeraj Sharma·Oct 12DuckDB 2.0 on a 2 vCPU box: recursive queries 20x faster, VARIANT 80xI reran DuckDB 2.0 benchmarks on a 2 vCPU box: a recursive ancestry walk went from 426 to 21 ms, VARIANT queries from 1,315 to 16 ms.5 min read·axionry.hashnode.dev
VVisuaLeaf - MongoDB Data Workspace·Sep 3How to Use DuckDB for Local Data AnalysisLearn how to use DuckDB for local analysis: open a database, query CSV and Parquet files, inspect relationships, edit data, and create charts.10 min read·visualeaf.hashnode.dev
PPragnesh Shah·Aug 4Query Locally, Think Remotely: How DuckDB-Wasm Cuts LLM Token CostLearn how DuckDB-Wasm queries CSV files in the browser, keeps raw data local, and sends compact SQL results to AI agents to cut LLM token cost17 min read·pragmatic-builder.hashnode.dev
LLack Studio·Jul 30DuckDB in the Browser – No Installation RequiredTired of installing DuckDB locally? Learn how to run DuckDB directly in your browser using WebAssembly and Pterocos.5 min read·open-ide.hashnode.dev
NNishikanta Ray·May 10We Let an AI Break Our Analytics Platform — Here's Every Bug It FoundGithub Main- https://github.com/NishikantaRay/InsightTrack Passmark - https://github.com/NishikantaRay/InsightTrack/tree/main/appsv2/passmark-tests InsightTrack — 17 pages, dual-database architectu33 min read·blog.nishikanta.in65NSE
MMadukoma Blessed·Apr 23Rebuilding by Removing: How I Made My Sports Analytics Pipeline 20x FasterFrom Overengineered Kafka Pipeline to a Simple, Lightning-Fast System: What I Learned by Ruthlessly Removing Complexity12 min read·mblessed.hashnode.dev
Hhelianthus·Apr 17DuckDB in the Wild: What 6 Minutes of Benchmarking Across 4 Machines Taught Me About Real-World Performance**DuckDB benchmark on Mac M5, Intel i7, Xeon server, and Alibaba Cloud VM. See 4 platforms compared.8 min read·wasteland.hashnode.dev
