registerFileHandle and spatial extension?

[nshiab]

Hello!

You have great examples showing how to load data from a File handle here: https://duckdb.org/docs/api/wasm/data_ingestion

But this doesn't seem to work with the spatial extension. Here's what I tried to do:

// file is picked by the user with the File API
await db.registerFileHandle(
  file.name,
  file,
  DuckDBDataProtocol.BROWSER_FILEREADER,
  true
);

await c.query(
  `INSTALL spatial; LOAD spatial;
  CREATE OR REPLACE TABLE table1 AS SELECT * FROM ST_Read(`${file.name}`)`
);

But I get this error:

IO Error: Unknown file type

Any idea what I am doing wrong?

Thank you! 🙏

[yfyf]

I have a similar issue, it seems like ST_Read is unable to handle any files registered via registerFile{Text,Buffer,Handle}.

Here's an example with registerFileText:

const geoData = {
  "type": "Feature",
  "geometry": {
    "type": "Point",
    "coordinates": [125.6, 10.1]
  },
  "properties": {
    "name": "Dinagat Islands"
  }
}

const fileName = 'geodata.json'; 
await db.registerFileText(
    fileName,
    JSON.stringify(geoData)
);

const c = await db.connect();
await c.query("INSTALL spatial; LOAD spatial;");
const rez = await c.query(
    `SELECT * FROM ST_Read('${fileName}');`
);

which outputs Error: IO Error: Unknown file type

ST_Read via an HTTP(S) URL works fine. I have also tried to install latest spatial from nightly extensions.

Running [email protected]

[nshiab]

Since I am not alone with this problem, I created an issue: #1793