Skip to content

Improve error message when opening a .sqlite db with duckdb #401

Closed
@garyrob

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

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions