duckdb / duckdb-wasm

WebAssembly version of DuckDB
https://shell.duckdb.org
MIT License
1.26k stars 131 forks source link

[SQLITE experimental] Unable to open database #1213

Open carlopi opened 1 year ago

carlopi commented 1 year ago

As reported here: https://github.com/duckdb/duckdb-wasm/issues/1202#issuecomment-1483742558

reproducible also as

LOAD sqlite_scanner;
CALL sqlite_attach('https://raw.githubusercontent.com/duckdblabs/sqlite_scanner/main/data/db/count.db');
PRAGMA show_tables

Plus, but the extension short-name should be sqlite (there is confusion between repo name and extensions names)

carlopi commented 1 year ago

Update here:

This is connected to a missing functionality in the sqlite_parser extension, and there is a path to solve this via providing a virtual file system backed by DuckDB's own file system.

And on the extension name I was wrong, proper name is sqlite_scanner, and now aliases works as intended.

carlopi commented 9 months ago

Reproduction: https://shell.duckdb.org/#queries=v0,LOAD-sqlite~,CALL-sqlite_attach('https%3A%2F%2Fraw.githubusercontent.com%2Fduckdb%2Fsqlite_scanner%2Fmain%2Fdata%2Fdb%2Fcount.db')~