Installing Harlequin on Python 3.12

[erhhung]

pipx install harlequin fails due to pip failing to build the duckdb package:

$ pipx install harlequin
Fatal error from pip prevented installation. Full pip output in file:
    /Users/erhhung/Library/Logs/pipx/cmd_2023-12-04_15.20.19_pip_errors.log

pip failed to build package:
    duckdb

Some possibly relevant errors from pip install:
    error: subprocess-exited-with-error
    src/numpy/numpy_scan.cpp:402:41: error: use of undeclared identifier 'PyUnicode_WCHAR_KIND'
    src/numpy/numpy_scan.cpp:404:85: error: use of undeclared identifier 'PyUnicode_WCHAR_KIND'
    error: command '/usr/bin/clang' failed with exit code 1

Error installing harlequin.

• Shell: Bash 5.2.21
• Terminal: iTerm2
• OS: macOS 14.1.2

[Mause]

The issue is you're trying to install it on Python 3.12, which we (DuckDB) have struggled to provide binaries for

[tconbeer]

Thanks so much, @Mause ! I had forgotten about that. Hope you get it sorted soon.

[tconbeer]

DuckDB can't be installed from wheels on Python 3.12. This is a known issue that is being tracked upstream in the DuckDB repo.

Best workarounds are:

• Downgrade your Python to 3.11
• Install the dependencies for building DuckDB from source.

[erhhung]

I wasn't trying to install from Python 3.12.

$ python3 -V
Python 3.11.6

$ pip3 -V
pip 23.3.1 from /usr/local/lib/python3.11/site-packages/pip (python 3.11)

$ brew install pipx
==> Downloading https://formulae.brew.sh/api/formula.jws.json
############################################################################################################################################################### 100.0%
==> Downloading https://formulae.brew.sh/api/cask.jws.json
############################################################################################################################################################### 100.0%
Warning: pipx 1.3.3 is already installed and up-to-date.
To reinstall 1.3.3, run:
  brew reinstall pipx

$ pipx install harlequin
Fatal error from pip prevented installation. Full pip output in file:
    /Users/erhhung/Library/Logs/pipx/cmd_2023-12-05_12.13.38_pip_errors.log

pip failed to build package:
    duckdb

Some possibly relevant errors from pip install:
    error: subprocess-exited-with-error
    src/numpy/numpy_scan.cpp:402:41: error: use of undeclared identifier 'PyUnicode_WCHAR_KIND'
    src/numpy/numpy_scan.cpp:404:85: error: use of undeclared identifier 'PyUnicode_WCHAR_KIND'
    error: command '/usr/bin/clang' failed with exit code 1

Error installing harlequin.

[erhhung]

OK. Found the culprit.

$ brew deps --tree pipx
pipx
├── python-argcomplete
├── python-packaging
└── [email protected]
    ├── mpdecimal
    ├── openssl@3
    │   └── ca-certificates
    ├── sqlite
    │   └── readline
    └── xz

Will have to downgrade pipx or install Harlequin using just pip.

[halostatue]

If you have Python 3.11 installed along with your Python 3.12, and Python 3.11 is available as python3.11 (this is pretty easy with MacPorts, which is how I have installed pipx), you can do:

$ pipx install --python python3.11 harlequin[postgres]
  installed package harlequin 1.13.0, installed using Python 3.11.7
  These apps are now globally available
    - harlequin
done! ✨ 🌟 ✨

[l1t1]

duckdb 0.10 support python 3.12 now, upgrade it using
pip install duckdb -U
maybe harlequin also works now.

[tconbeer]

Perhaps you should try it and let us know.

[l1t1]

confirmed, it works now.