Error with "select load extension"

[mamereu]

The load_extension(x) is a sqlite3 built-in function, but in deno-sqlite it throws an error:

const db = new DB("books.db")
db.query("SELECT load_extension('/opt/sqlite3/sqlite/ext/misc/regexp.so')")
error: Uncaught SqliteError: no such function: load_extension`

Why is that ? In the shell the same select works without problems.

[dyedgreen]

The Deno SQLite package runs SQLite in a WebAssemby runtime. This means, we can't load dynamic libraries/ shared objects at runtime (or at least I'm not aware if this is possible, please do correct me if it is).

This means, that the build of SQLite used here removes the load_extension build in function.

[dyedgreen]

Out of curiosity: Which extension are you trying to load?

[craigmulligan]

I've just run into this too. I was trying to load the fts5 extension.