#DuckDb

DuckDB 2.0 LTS adds client-server mode and async I/O but breaks file compatibility. What Data Engineers should check before upgrading and before interviews.

TL;DR DuckDB is an open-source analytical database that runs inside one process, and...

In this series, I encountered a pg_duckdb gotcha with unconstrained numeric column. With...

Data arrives as files. A vendor drops a CSV in a container, an upstream system exports...

Six developer tools this week, led by DuckDB 2.0's long-term support release and TorchTPU, plus TypeScript 7.1 Beta, Perplexity SPACE and DeepInfer.

DuckDB v2.0 is coming this fall. In this post, we preview its headline features: DuckDB as a server, triggers, the VARIANT type, asynchronous I/O, a new SQL parser, a new storage format, and much more.

Starting with v2.0, scheduled for fall 2026, DuckDB will support asynchronous reads of Parquet and CSV files. This can significantly speed up queries when synchronous I/O does not saturate the available bandwidth, as is typical in EC2/S3 compute-storage…

Walk through DuckDB's internals: how it skips serialization overhead, parses and optimizes SQL, and stores data in columnar row groups with zone maps.

I built jq for Parquet, then ghosted three v0.14 issues for 21 days. Here's how a hashtag, Copilot, and Cursor finally shipped them — and what I learned when DuckDB lied to me on the cover image.

A comprehensive comparison of pandas, Polars, and DuckDB. Discover the key differences in architecture, performance, and memory usage.

Ongoing Shai-Halud npm supply chain attacks affected popular packages. Vercel responded swiftly, secured builds, and notified impacted users.

From Dev.to - nextjs: Query CSV, Excel, Parquet, and Arrow files in the Browser with DuckDB-Wasm + Next.js 🦆✨

DuckDB makes cross-source SQL easy, but repeatable workflows still need saved connections, S3 paths, schema checks, exports, and reruns.

From Dev.to - database: SQLite Concurrency Corruption, DuckDB Delta Writes, and DuckLake Data Inlining

Compare embedded databases — DuckDB for analytical queries (OLAP), SQLite for transactional workloads (OLTP), when to use each, and how they complement.

News for DuckDB users! Valentina Studio 17.3 now fully supports the new DuckDB VARIANT type on all...