Laurens Kuiper will present his paper 'Robust External Hash Aggregation in the Solid State Age' tomorrow at ICDE 2024 in Utrecht. This work describes the techniques that make larger-than-memory aggregation possible in DuckDB. The paper is co-authored by Peter Boncz (Peter Boncz)

DuckDB's co-creator Hannes Mühleisen (Hannes M​ühleisen) will give an invited talk on Wednesday May 15th at 17:00. The talk, presented at the industry track of ICDE 2024 in Utrecht, is titled 'How I Learned to Stop Worrying About Benchmarks'.

icde2024.github.io/invited

I’m finally updating my book Minimum Viable SQL Patterns!

Here are some of the planned updates:
- Errata
- Update the code to rely on a local DuckDB setup and provide the data as CSVs
- A brand new chapter on how to apply the patterns to dbt

What else do you want to learn?

Just a hypothetical (that wasn't hypothetical for me)... Say you need to query data from:

1. Postgres
2. JSON logs on S3
3. a Google Sheet

What do you do?

DuckDB can directly query all these things. SQL here: definite.app/blog/query-any…

DuckDB is introducing support for vector similarity search through the new VSS extension.

Read Max Gabrielsson's blog post for a sneak preview on the new extension's capabilities: duckdb.org/2024/05/03/vec…

DuckDB's release calendar was recently extended with pictogram of the ducks used for the release codenames. Check it out at duckdb.org/docs/dev/relea…

PS: The next version of DuckDB, v0.10.3 is expected to be released on May 20.

Did you know that DuckDB's documentation is available as a single PDF? It includes all documentation pages and guides, and just surpassed 1,000 pages.

duckdb.org/duckdb-docs.pdf

The DuckDB v0.10.2 R package is now available on CRAN.

DuckDB was recently covered in Andy Pavlo (@[email protected])'s Advanced Database Systems course at CMU. The lecture covers DuckDB's history, internals, and integration with other systems.

Slides: 15721.courses.cs.cmu.edu/spring2024/sli…
Recording: youtube.com/watch?v=4iD4h4…

Did you know that you can connect to a DuckDB database file via HTTPS or S3 with just two SQL statements? We have a new guide that explains how to do this.
duckdb.org/docs/guides/ne…

Save the date: DuckCon #5 will take place in Seattle on 2024-08-15.

For details and the registration link, see duckdb.org/2024/08/15/duc…

Looking forward to my keynote at #PyConDE / #PyDataBerlin tomorrow morning - will be talking about “Creating Software like DuckDB in Academic Institutions” PyConDE & PyData Berlin - happy to chat about anything DuckDB, just find me, this is what I look like

Visualizing #geospatial data in #DuckDB 🦆with #leafmap 🍀 and #lonboard 🗺️🌎

Video: youtu.be/r3A_OLT-JBM
Notebook: geog-414.gishub.org/book/duckdb/08…
Playlist: youtube.com/playlist?list=…

#dataviz #geopython

New Post: Introduction to DuckDB buff.ly/3VTzjRh

Folks, tons of goodies even in a bugfix release!
- DuckDB Wasm ❤️ Pyodide for in-browser Python/DuckDB fun!
- Attach directly to DuckDB files on S3
- Read LZ4 parquet files
- Deletes are more RAM efficient
- Faster inserts from wide parquet files
- Fixes for ODBC / Power BI

We just released DuckDB v0.10.2, a bugfix release.

See the installation page and the release notes for details:

– duckdb.org/docs/installat…
– github.com/duckdb/duckdb/…

We invite our community to submit talk proposals until April 29. We especially encourage members of underrepresented groups to share their DuckDB-related projects.

Please use the form at forms.gle/RgFazaawkfx9YK…

Hi DuckDB community! We are hosting an informal pub session with Hannes M​ühleisen in Berlin on 2024-04-22 (Monday) starting at 8PM near U Oranienburger Tor.

We only have 10 seats available – if you are interested in participating, please send an email with the subject “DuckDB