09-10, 15:00–15:30 (America/Chicago), Grand B
DuckDB is a fast, open-source analytical SQL database that's gaining popularity. Discover how it can perform H3 operations on data quicker than other solutions.
DuckDB is a fast, in-process, analytical open source SQL database engine. Isaac maintains the open source H3 hexagonal grid system and the bindings for H3 to DuckDB. In this talk, Isaac will cover why users may choose H3 on DuckDB for ease of use and performance.
Highlights of the talk can include:
* Why DuckDB is fast and gaining popularity. How DuckDB fits into the cloud-native application architecture at edge computing (serverless) and in the browser (WASM).
* Ways to quickly get started with DuckDB locally using open datasets like Overture. DuckDB is a recommended way to read huge cloud optimized Parquet datasets like Overture. DuckDB runs locally and even in your browser.
* Evolution of the DuckDB extension ecosystem, and how it has become easier to install and load open source extensions. Extensions can extend DuckDB with new capabilities, with more flexibility than cloud databases thanks to DuckDB being open source and local.
* How to use the H3-DuckDB extension to perform geospatial operations. Will touch on why a user may want to choose the H3 hexagonal grid system, and how to write common geospatial operations in SQL.
* Performance comparison with other approaches -- DuckDB SQL is much faster than Python or JavaScript calls. The H3-DuckDB bindings are set up for performance-by-default.
