duckdb wasm in marimo is old ?

[yharby]

In marimo wasm:

INSTALL httpfs;
LOAD httpfs;

Traceback (most recent call last):
  File "/lib/python3.12/site-packages/marimo/_runtime/executor.py", line 138, in execute_cell
    exec(cell.body, glbls)
  File "/tmp/marimo_42/__marimo__cell_vblA_.py", line 2, in <module>
    _db_setup = mo.sql(
                ^^^^^^^
  File "/lib/python3.12/site-packages/marimo/_sql/sql.py", line 74, in sql
    df = sql_engine.execute(query)
         ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/lib/python3.12/site-packages/marimo/_sql/engines/duckdb.py", line 42, in execute
    relation = wrapped_sql(query, self._connection)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/lib/python3.12/site-packages/marimo/_sql/utils.py", line 41, in wrapped_sql
    relation = eval(
               ^^^^^
  File "<string>", line 1, in <module>
duckdb.duckdb.IOException: IO Error: Failed to download extension "httpfs" at URL "http://extensions.duckdb.org/v1.1.2/wasm_eh_pyodide/httpfs.duckdb_extension.gz"
Extension "httpfs" is an existing extension.
 (ERROR Could not establish connection)

INSTALL spatial;
LOAD spatial;

Traceback (most recent call last):
  File "/lib/python3.12/site-packages/marimo/_runtime/executor.py", line 138, in execute_cell
    exec(cell.body, glbls)
  File "/tmp/marimo_42/__marimo__cell_vblA_.py", line 2, in <module>
    _db_setup = mo.sql(
                ^^^^^^^
  File "/lib/python3.12/site-packages/marimo/_sql/sql.py", line 74, in sql
    df = sql_engine.execute(query)
         ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/lib/python3.12/site-packages/marimo/_sql/engines/duckdb.py", line 42, in execute
    relation = wrapped_sql(query, self._connection)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/lib/python3.12/site-packages/marimo/_sql/utils.py", line 41, in wrapped_sql
    relation = eval(
               ^^^^^
  File "<string>", line 1, in <module>
duckdb.duckdb.IOException: IO Error: Failed to download extension "spatial" at URL "http://extensions.duckdb.org/v1.1.2/wasm_eh_pyodide/spatial.duckdb_extension.gz"
Extension "spatial" is an existing extension.
 (ERROR Could not establish connection)

SELECT version();

v1.1.2

but it seems that everything is working in duckdb wasm shell :
https://shell.duckdb.org/#queries=v0,INSTALL-spatial~,LOAD-spatial~,INSTALL-httpfs~,LOAD-httpfs~,SELECT-version()~,SELECT-ST_AsText(ST_Point(1%2C2))~,SELECT-COUNT(*)-FROM-read_parquet(%27https%3A%2F%2Fduckdb.org%2Fdata%2Fprices.parquet%27)

[yharby]

i think it's related to : #4308 and duckdb/duckdb-pyodide#2

[mscolnick]

You are correct, its an upstream issue to support extensions in their wasm build.

The version is old because it has not been updated for 1.3.0, and 1.2.0 was not in the pyodide package registry.

[agriyakhetarpal]

See also: #5995