duckdb geo in Observable

[neocarto]

DuckDB is now very much used in Observable. Is it possible to use this extension in this context? If yes, how?
https://observablehq.com/@observablehq/duckdb

[blackrez]

Good question, the version of DuckDB used in Observable is based on WASM. I will check how it's possible to use unsigned extension.

[neocarto]

It would be great if it could work.

[blackrez]

For now, it's impossible to use unsigned extension with duckdb-WASM. But there is some interesting change from duckdb-wasm.
duckdb/duckdb-wasm#1190

[carlopi]

Hi! Carlo from DuckDB Labs here.

We are actively experimenting with DuckDB Wasm extensions, but for this to be live on Observable a few things will have to happen:

• Extension loading support is iterated on and eventually becomes part of duckdb-wasm
• GEO extension can be compiled to Wasm (might requires some hopefully minor modifications)
• Observable updates duckdb-wasm to not-yet-existing extension-loadable version

I think partially 1 and 2 can be worked in parallel, I will modify extension-template repo with instructions on how to generate the WebAssembly-enabled files, and then I will be very happy to get feedback on from this extension perspective.

Here the trackign issue on extension loading: duckdb/duckdb-wasm#1202, feedback is very welcome also from extension-authors!

[tobilg]

This should work nowadays, right? duckdb/duckdb-wasm#1202 (comment)