I've been deep in 𝗞𝗮𝗳𝗸𝗮 + 𝗗𝘂𝗰𝗸𝗗𝗕 development the past few weeks, but here are some late-night benchmarks from my couch 🛋️:

⚡ Inserted 50M messages (𝟰.𝟯 𝗺𝗶𝗹𝗹𝗶𝗼𝗻 𝗺𝘀𝗴𝘀/𝘀𝗲𝗰)
👀 Scanned from Kafka (𝟮.𝟴𝟱 𝗺𝗶𝗹𝗹𝗶𝗼𝗻 𝗺𝘀𝗴𝘀/𝘀𝗲𝗰)
🐤 Inserted into a local table (𝟭.𝟲𝟵 𝗺𝗶𝗹𝗹𝗶𝗼𝗻 𝗺𝘀𝗴𝘀/𝘀𝗲𝗰)

#DuckDB #Kafka #QueryFarm

🌍 New DuckDB extension: A5 geospatial indexing

Millimeter-accurate, equal-area cells for spatial analysis. Convert coordinates to cells, navigate hierarchies, extract geometry—all in SQL.

31 resolution levels from global to sub-30mm².

query.farm/duckdb_exten...

#DuckDB #GIS #OpenSource

DuckDB keeps growing, and so do the number of community extensions. To make sense of them, I put together a guide of DuckDB extensions, to simplify the way to see what’s available and what each extension does.

Here's the guide: query.farm/duckdb_commu...

#DuckDB #DuckDBExtensions #SQL

Yesterday in Amsterdam, Lorenzo Mangani from Query.Farm presented these slides to DuckDB Meetup #3. Thank you to DuckDB and Adyen for hosting the meetup.

query.farm/events/duckd...

Query.Farm will a part of DuckDB Amsterdam Meetup #3 on September 17th, See details here: www.meetup.com/duckdb/event...

Here's the first slide:

We just launched the “DuckDB in Science” site, a curated collection of papers, lectures and podcasts about DuckDB in research: duckdb.org/science/

🎡 If you would like to learn more about DuckDB in Science, consider joining our meetup in London this Thursday: www.meetup.com/duckdb/event...

I am excited to announce Query.Farm is expanding! We've integrated 12 high-quality DuckDB community extensions from the QuackScience project.

Learn more on our blog: query.farm/posts/mergin...

#DuckDB #DuckDBExtensions #QuackScience #QueryFarm

Announcing Textplot - bringing data visualization directly to your SQL queries!

Create bar charts, density plots, and sparklines without leaving DuckDB.

Try it out: query.farm/duckdb_exten...

#DuckDBExtension