Improve error message when opening a .sqlite db with duckdb #401
Closed
Description
Describe the bug
I can't connect to a database with Harlequin; I get an error involving DuckDB saying to INSTALL sqlite. sqlite does exist on my system and I have no problem using it with or without python.
To Reproduce
pip install harequin
Try to run it with harlequin /path/to/db
Expected behavior
It should connect to the database and do something useful.
Actual behavior
DuckDB couldn't connect to your database.
IO Error: Extension "/xxxxx/xxxxx/.duckdb/extensions/v0.9.2/osx_amd64/sqlite_scanner.duckdb_extension" not found.
Extension "sqlite" is an existing extension.
Install it first using "INSTALL sqlite".
Additional context
The output of harlequin --version
is:
harlequin, version 1.9.2
Installed Adapters:
- duckdb, version 1.9.2
- sqlite, version 1.9.2
What database adapter are you using with Harlequin? (Default is DuckDB)
I'm just using the default.
Can you tell us more about your system?
- Shell: zsh
- Terminal: iTerm. Note however that I run iTerm under Rosetta because I want to use x86 software on my M1 Mac. So perhaps that has something to do with the issue.
- OS of the shell: MacOS 14.2.1