What’s Inside an Iceberg Table? 🧊 📦

An #ApacheIceberg table looks like a regular table when you query it, but beneath the surface…it’s like an iceberg. 😅

With #DuckDB, you can inspect every layer with plain SQL. In this post, we create a small Iceberg table and walk through it from the top down:

"hannes closed this as completed"

github.com/duckdb/duckd... #DuckDB

Using DuckDB to effortlessly modernize your legacy 🦆🧓🏽

In this talk from DuckCon, Nicolas Renkamp from Merck shares how the team used SQLFrame to migrate from #PySpark to #DuckDB without any code changes.

Video below or slides here: blobs.duckdb.org/events/duckc...

10 states vote on a different congressional map this November.
I turned the Census Bureau's 2026 district boundaries into open GeoParquet and mapped every redrawn district against its 2024 version. #PMTiles #GeoParquet #DuckDB
#MakeDemocracyGreatAgain

🗺️ census.geomermaids.com

First time at FOSS4G NA? Our guide maps a beginner-friendly path from the Hitchhiker's Guide to #QGIS workshop to #DuckDB and Spatial Datasets: A Geo-Practitioner's Feedback. Come meet a welcoming community in Sacramento, Nov 2–4.

#ArcGIS #GIS #EO #CNG

Wild. #duckdb gets an "agent mode" that effectively prints all output in #markdown. 😅 Crazy how dominate markdown has become that to agents.

new bionic enhancement: putting #DuckDB 2.0 on all the nodes in the tailnet, firing up the Quack server in each of them, and fronting each with a tailscale caddy reverse proxy.

DuckDB 2.0が速くなった。地味に嬉しい。ローカルでCSVやParquetをそのままSQLで直接集計できるやつで、わざわざDBを立てる手間がない。クラウドの分析基盤に課金する前に手元で試行錯誤できるのが正直デカい。個人開発のログ分析でずっと世話になってる身としては、エンジン改善ほどテンション上がる話はない。 #DuckDB

Tajer Studio: CSV scan success isn't full validation. Our DuckDB demo returns 7 IDs; a full typed scan rejects 3 records. AI-produced, tested code, synthetic data.
tajer-studio-menu.nazar-al-aru-7391.chatgpt.site/writing/duck...
#DuckDB #Python

#DuckDB is already a solid building block for fast and reliable agentic applications.

And it’s getting even better with a dedicated ‘agent mode’ coming in DuckDB 2.0.

🐣🤖👍

The #DuckDB v2.0 CLI has an agent mode that gets AI coding agents to a correct result faster and with fewer tokens.

When the CLI detects an agent, it prints compact Markdown tables instead of padded boxes, says clearly when a result was cut, stops runaway queries early, and reports errors as JSON.

A #DuckDB file doesn't have to contain any data.

It can store nothing but view definitions pointing at files stored somewhere else, such as Parquet on object storage. The file stays a few hundred KBs no matter how large the data it describes. In this post, we create such a small shareable catalog:

[Guest blog:]
When the analytics screen running on our main operational database got too slow, we moved 1 year of data into #DuckDB on the same server. Getting the data in was the hard part.

This is the story of every method we tried and why a table function written in Java is the one we shipped:

#osmium extension for #duckdb to process #openstreetmap data #osm
https://duckdb.org/community_extensions/extensions/osmium

Grouping on repeated strings is expensive. 💰

By moving strings into a small dimension table with sorted, narrow integer keys, #DuckDB can aggregate on fixed-width integers and keep its hash tables compact.

Here’s how to achieve faster string aggregations with dimension tables:

I feel like #rstats #dplyr and #dbplyr were lying in waiting for a decade+ for #parquet and #duckdb to materialize

Not to dunk on Parquet files, at all but here's an example of something I can do in #duckdb : Create views. Sometimes a DB view (i.e. virtual table) is an easy way to ensure mulitple different scripts "see" exactly the same underlying aggregates. #Rstats

What would you do?

It took #duckdb plugins to make me realize the power of #jev. 🤣 excellent overview on what you can do.

Now scanning through a bunch of random local data to see of other quick analytical wins like this. 😁

🌐 Whether you're new to Cloud-Native Geo #CNG or a practitioner, there is something for you. Explore hands-on workshops & talks covering #STAC, #GeoParquet, #DuckDB, vector tiles, #Zarr, cloud-optimized point clouds, reproducibility, and large-scale data publishing.

🦆 Working with RDF in DuckDB (@duckdb.org)? duck_rdf 2.8.3 is out with SPARQL enhancements, Turtle/quads export fixes, and performance improvements. Read, write, and query RDF alongside your SQL workflows.

Release notes:
github.com/nonodename/d...

#KnowledgeGraphs #DuckDB