Load spatial extension in JavaScript

[kbatchu]

Hello,

I am using the following code to instantiate duckdb in JavaScript using duckdb-wasm in a web app. How do I then load the spatial extension?

import * as duckdb from "@duckdb/duckdb-wasm";

const JSDELIVR_BUNDLES = duckdb.getJsDelivrBundles();
  // Select a bundle based on browser checks
   const bundle = await duckdb.selectBundle(JSDELIVR_BUNDLES);

   const worker_url = URL.createObjectURL(
     new Blob([`importScripts("${bundle.mainWorker}");`], {
       type: "text/javascript"
     })
   );

   // Instantiate the asynchronus version of DuckDB-Wasm
   const worker = new Worker(worker_url);
   const logger = new duckdb.ConsoleLogger();
   db = new duckdb.AsyncDuckDB(logger, worker);
   await db.instantiate(bundle.mainModule, bundle.pthreadWorker);
   URL.revokeObjectURL(worker_url);

Thanks,

[parkerziegler]

Hey @kbatchu! You load the spatial extension via db.query. Beneath your code above you can do:

await db.query(`
  INSTALL spatial;
  LOAD spatial;
  ... // Your SQL query here. 
`);

For example, to load the spatial extension and read in a remote GeoJSON file, you can do something like this:

await db.query(`
  INSTALL spatial;
  LOAD spatial;
  CREATE TABLE tableName as SELECT * FROM 'https://somedomain.com/file.geojson');
`);