Geobase now supports DuckDB 1.1.3 🎉

DuckDB 1.1.3 is now supported in the latest version of Geobase.

DuckDB use cases

Geobase is a platform for building geospatial applications. With our support for DuckDB you can cheaply handle large geospatial datasets. If you already have data lakes or data warehouses you can use DuckDB to query your data without needing to move it to a different platform. For a use case see our blog post on geospatial analytics with Geobase and MotherDuck.

What's new in DuckDB 1.1.3?

1. CSV and Sniffer Enhancements: Improved header/type detection for small files, better error handling, and default escape quoting.

2. Concurrency Improvements: Added table-level locking for shared locks.

3. Arrow Integration: Fixed BOOL column scanning and memory issues with empty lists.

4. Performance Optimizations: Avoided unnecessary file materialization and improved hash vector handling.

5. Query and Grammar Fixes: Resolved pivot header issues and underflow in CSV row calculations.

6. Serialization Enhancements: Added support for bitstring_agg and logical export serialization.

7. CI and Code Quality: Streamlined CI bots, fixed Windows-specific builds, and addressed typos.

These updates focus on stability, performance, and robustness without adding new features.

As we launch geobase we are going to be educating our community on using these tools better and improving the know-how needed to make such powerful applications.