--- title: "#duckdb articles | Hashnode" description: "Explore 60 articles tagged #duckdb on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/duckdb" --- Tag # #duckdb 60 posts · 15 followers [Edna Maina](https://hashnode.com/@ednaj) · [Oct 27](https://hashnode.com/posts/embedded-retail-analytics-with-duckdb-dbt-polars-and-fastapi/6ae07ec959a6b0ec8369a1ef) ### [Embedded retail analytics with DuckDB, dbt, Polars, and FastAPI](https://qdrant.hashnode.dev/embedded-retail-analytics-with-duckdb-dbt-polars-and-fastapi?utm_source=hashnode&utm_medium=feed) How 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](https://qdrant.hashnode.dev/embedded-retail-analytics-with-duckdb-dbt-polars-and-fastapi?utm_source=hashnode&utm_medium=feed) [Brice Luu](https://hashnode.com/@bluu) · [Oct 26](https://hashnode.com/posts/the-spec-already-wrote-it/6adf47637b8899a8582cc18f) ### [The spec already wrote half your ingestion script](https://bluu.dev/the-spec-already-wrote-it?utm_source=hashnode&utm_medium=feed) apisip 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](https://bluu.dev/the-spec-already-wrote-it?utm_source=hashnode&utm_medium=feed) [IT-Craftsman](https://hashnode.com/@itcraftsman) · [Oct 12](https://hashnode.com/posts/sql-window-function-interview-traps-duckdb/6acd195ee0e9b327716c900a) ### [5 SQL window-function traps that show up in data engineering interviews (with runnable DuckDB examples)](https://itcraftsman.hashnode.dev/sql-window-function-interview-traps-duckdb?utm_source=hashnode&utm_medium=feed) 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](https://itcraftsman.hashnode.dev/sql-window-function-interview-traps-duckdb?utm_source=hashnode&utm_medium=feed) [Neeraj Sharma](https://hashnode.com/@neeraj0786) · [Oct 12](https://hashnode.com/posts/duckdb-2-0-on-a-2-vcpu-box-recursive-queries-20x-faster-variant-80x/6accddabf3c3aed6bd0fd5fd) ### [DuckDB 2.0 on a 2 vCPU box: recursive queries 20x faster, VARIANT 80x](https://axionry.hashnode.dev/duckdb-2-0-on-a-2-vcpu-box-recursive-queries-20x-faster-variant-80x?utm_source=hashnode&utm_medium=feed) I 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](https://axionry.hashnode.dev/duckdb-2-0-on-a-2-vcpu-box-recursive-queries-20x-faster-variant-80x?utm_source=hashnode&utm_medium=feed) [VisuaLeaf - MongoDB Data Workspace](https://hashnode.com/@visualeaf) · [Sep 3](https://hashnode.com/posts/how-to-use-duckdb-for-local-data-analysis/6a991c376e5e809fb20df069) ### [How to Use DuckDB for Local Data Analysis](https://visualeaf.hashnode.dev/how-to-use-duckdb-for-local-data-analysis?utm_source=hashnode&utm_medium=feed) Learn 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](https://visualeaf.hashnode.dev/how-to-use-duckdb-for-local-data-analysis?utm_source=hashnode&utm_medium=feed) [Pragnesh Shah](https://hashnode.com/@prag-matic-builder) · [Aug 4](https://hashnode.com/posts/query-locally-think-remotely-cuts-llm-token-cost/6a91b2cbac000cd52d33fa10) ### [Query Locally, Think Remotely: How DuckDB-Wasm Cuts LLM Token Cost](https://pragmatic-builder.hashnode.dev/query-locally-think-remotely-cuts-llm-token-cost?utm_source=hashnode&utm_medium=feed) Learn 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 cost 17 min read · [pragmatic-builder.hashnode.dev](https://pragmatic-builder.hashnode.dev/query-locally-think-remotely-cuts-llm-token-cost?utm_source=hashnode&utm_medium=feed) [Lack Studio](https://hashnode.com/@lackhosting) · [Jul 30](https://hashnode.com/posts/duckdb-in-the-browser-no-installation-required/6a6b4e26a9998c77e91961b1) ### [DuckDB in the Browser – No Installation Required](https://open-ide.hashnode.dev/duckdb-in-the-browser-no-installation-required?utm_source=hashnode&utm_medium=feed) Tired of installing DuckDB locally? Learn how to run DuckDB directly in your browser using WebAssembly and Pterocos. 5 min read · [open-ide.hashnode.dev](https://open-ide.hashnode.dev/duckdb-in-the-browser-no-installation-required?utm_source=hashnode&utm_medium=feed) [Nishikanta Ray](https://hashnode.com/@nishikanta236) · [May 10](https://hashnode.com/posts/we-let-an-ai-break-our-analytics-platform-here-s-every-bug-it-found/6a00a23de3eebc2e20953d42) ### [We Let an AI Break Our Analytics Platform — Here's Every Bug It Found](https://blog.nishikanta.in/we-let-an-ai-break-our-analytics-platform-here-s-every-bug-it-found?utm_source=hashnode&utm_medium=feed) Github Main- https://github.com/NishikantaRay/InsightTrack Passmark - https://github.com/NishikantaRay/InsightTrack/tree/main/appsv2/passmark-tests InsightTrack — 17 pages, dual-database architectu 33 min read · [blog.nishikanta.in](https://blog.nishikanta.in/we-let-an-ai-break-our-analytics-platform-here-s-every-bug-it-found?utm_source=hashnode&utm_medium=feed) [5](https://hashnode.com/posts/we-let-an-ai-break-our-analytics-platform-here-s-every-bug-it-found/6a00a23de3eebc2e20953d42) [Madukoma Blessed](https://hashnode.com/@mblessed) · [Apr 23](https://hashnode.com/posts/rebuilding-by-removing-20x-faster-sports-analytics-pipeline/69e9bf062fb2fc72b4cfb9e6) ### [Rebuilding by Removing: How I Made My Sports Analytics Pipeline 20x Faster](https://mblessed.hashnode.dev/rebuilding-by-removing-20x-faster-sports-analytics-pipeline?utm_source=hashnode&utm_medium=feed) From Overengineered Kafka Pipeline to a Simple, Lightning-Fast System: What I Learned by Ruthlessly Removing Complexity 12 min read · [mblessed.hashnode.dev](https://mblessed.hashnode.dev/rebuilding-by-removing-20x-faster-sports-analytics-pipeline?utm_source=hashnode&utm_medium=feed) [helianthus](https://hashnode.com/@helianthus) · [Apr 17](https://hashnode.com/posts/duckdb-in-the-wild-what-6-minutes-of-benchmarking-across-4-machines-taught-me-about-real-world-performance/69e2013e4381e460a61255c3) ### [DuckDB in the Wild: What 6 Minutes of Benchmarking Across 4 Machines Taught Me About Real-World Performance](https://wasteland.hashnode.dev/duckdb-in-the-wild-what-6-minutes-of-benchmarking-across-4-machines-taught-me-about-real-world-performance?utm_source=hashnode&utm_medium=feed) \*\*DuckDB benchmark on Mac M5, Intel i7, Xeon server, and Alibaba Cloud VM. See 4 platforms compared. 8 min read · [wasteland.hashnode.dev](https://wasteland.hashnode.dev/duckdb-in-the-wild-what-6-minutes-of-benchmarking-across-4-machines-taught-me-about-real-world-performance?utm_source=hashnode&utm_medium=feed)