Tag

#duckdb

60 posts15 followers

Explore Hashnode

Alternatives

Edna Maina4d ago · 9 min read

Embedded retail analytics with DuckDB, dbt, Polars, and FastAPI

Most small and mid-sized retail datasets fit comfortably on a single laptop, yet teams often rent expensive cloud data warehouses to query a few million rows. The Deterministic SME Retail Analytics En

qdrant.hashnode.dev

Brice Luu5d ago · 10 min read

The spec already wrote half your ingestion script

You need the data from some API. There's no connector for it, or the connector costs more than the problem. So you write a script. The first version is twenty lines. A token in a header, a loop over ?

bluu.dev

IT-CraftsmanOct 12 · 5 min read

5 SQL window-function traps that show up in data engineering interviews (with runnable DuckDB examples)

Window functions are the most common SQL topic in data engineering interviews, and most candidates know the syntax. The follow-up questions are where people stumble. Here are five traps, each with a t

itcraftsman.hashnode.dev

Neeraj SharmaOct 12 · 5 min read

DuckDB 2.0 on a 2 vCPU box: recursive queries 20x faster, VARIANT 80x

MotherDuck's "Why DuckDB 2.0 is faster" was on the Hacker News front page this weekend. It benchmarks the 2.0 alpha against 1.5.5 on an M5 laptop and reports big wins: a recursive engine the DuckDB te

axionry.hashnode.dev

VisuaLeaf - MongoDB Data WorkspaceSep 3 · 10 min read

How to Use DuckDB for Local Data Analysis

You have data on your computer and want to explore it with SQL. It might be a CSV export, an existing database, or files produced by another analytical tool. Setting up a database server just to answe

visualeaf.hashnode.dev

Pragnesh ShahAug 4 · 17 min read

Query Locally, Think Remotely: How DuckDB-Wasm Cuts LLM Token Cost

Subtitle: Using DuckDB-Wasm as an agent context layer to keep raw data local and send only small SQL results to the LLM. TL;DR DuckDB-Wasm runs entirely in a browser Web Worker — no backend data proc

pragmatic-builder.hashnode.dev

Lack StudioJul 30 · 5 min read

DuckDB in the Browser – No Installation Required

Run DuckDB in Your Browser – No Installation Required In the realm of analytical databases, the ability to execute DuckDB queries directly within a web browser presents a significant advantage, elimin

open-ide.hashnode.dev

Nishikanta RayMay 10 · 33 min read

We Let an AI Break Our Analytics Platform — Here's Every Bug It Found

Github Main- https://github.com/NishikantaRay/InsightTrack Passmark - https://github.com/NishikantaRay/InsightTrack/tree/main/appsv2/passmark-tests InsightTrack — 17 pages, dual-database architectu

5 blog.nishikanta.in

Madukoma BlessedApr 23 · 12 min read

Rebuilding by Removing: How I Made My Sports Analytics Pipeline 20x Faster

Athletic performance data contains patterns. Some patterns reflect natural improvement through training. Others represent statistical outliers that warrant investigation. My thesis explored a fundamen

mblessed.hashnode.dev

helianthusApr 17 · 8 min read

DuckDB in the Wild: What 6 Minutes of Benchmarking Across 4 Machines Taught Me About Real-World Performance

This is not a lab benchmark. It is an engineering gut-check: same query, different machines, different storage. The numbers are messy, the comparisons are unfair, and yet they are surprisingly useful.

wasteland.hashnode.dev

Search Hashnode