Summary

In this chapter, we saw how DuckDB extensions enhance it with a range of specialized features and capabilities that are not available in DuckDB core. We saw how these extensions enable DuckDB to directly query other database systems such as SQLite, read and write remotely hosted files, and perform powerful and efficient full-text searches over large collections of documents. We also went on a deeper dive into the spatial extension, seeing how we can leverage the geospatial data types and operations it provides for performing analytical queries on geospatial data.

You should now feel comfortable with the process of installing and loading DuckDB extensions, which will allow you to leverage their powerful capabilities in your own workflows and projects. We should also highlight that we have only explored a selection of DuckDB’s extensions in this chapter. We encourage you to explore DuckDB’s full catalogue of extensions, to see what other functionality to can...