poetry Unable to find installation candidates for pysqlite3-binary

[franziskavonalbedyll]

Hi there!
Hope this is the right place to ask, otherwise I will move this to the poetry community.

• Poetry version: 1.6.1
• Python version: Python 3.11.4
• OS version and name: Mac OS Ventura 13.0
  pyproject.toml:

[tool.poetry]
name = "chatwithmycv"
version = "0.1.0"
description = "Build a simple chatbot which answers questions about your CV"
authors = <author>
readme = "README.md"

[tool.poetry.dependencies]
python = "^3.11"
openai = "^0.28.1"
langchain = "^0.0.308"
python-dotenv = "^1.0.0"
chromadb = "^0.4.13"
tiktoken = "^0.5.1"
streamlit = "^1.27.2"
streamlit-chat = "^0.1.1"
azure-storage-blob = "^12.18.2"

[tool.poetry.group.dev.dependencies]
pre-commit = "^3.4.0"
pydocstyle = "^6.3.0"

[build-system]
requires = ["poetry-core"]
build-backend = "poetry.core.masonry.api"

Issue

I am trying to install the pysqlite3-binary using the following command:

 poetry add pysqlite3-binary 

Which returns the following exception:

Configuration file exists at /Users/fva/Library/Preferences/pypoetry, reusing this directory.

Consider moving TOML configuration files to /Users/fva/Library/Application Support/pypoetry, as support for the legacy directory will be removed in an upcoming release.
Using version ^0.5.2.post1 for pysqlite3-binary

Updating dependencies
Resolving dependencies... (0.8s)

Package operations: 1 install, 0 updates, 0 removals

  • Installing pysqlite3-binary (0.5.2.post1): Failed

  RuntimeError

  Unable to find installation candidates for pysqlite3-binary (0.5.2.post1)

  at /opt/homebrew/Cellar/poetry/1.5.1/libexec/lib/python3.11/site-packages/poetry/installation/chooser.py:73 in choose_for
       69│ 
       70│             links.append(link)
       71│ 
       72│         if not links:
    →  73│             raise RuntimeError(f"Unable to find installation candidates for {package}")
       74│ 
       75│         # Get the best link
       76│         chosen = max(links, key=lambda link: self._sort_key(package, link))

I tried the following to solve this issue:

• Verified on pypi.org that the version 0.5.2.post1 exist
• Connected to a different network
• Tried with and without VPN
• Updated poetry
• Tried several older versions
• Re-installed poetry
• Set poetry config repositories.pypi.url https://pypi.org/simple/

None of these approaches worked.

[coleifer]

Yeah we don't publish wheels for macos, you'll want to compile it yourself by swapping pysqlite3-binary for pysqlite3. Just ensure you have the sqlite3 headers and you should be set.

[franziskavonalbedyll]

Thanks for your quick answer

Yeah we don't publish wheels for macos, you'll want to compile it yourself by swapping pysqlite3-binary for pysqlite3. Just ensure you have the sqlite3 headers and you should be set.

I ran brew install sqlite3and then poetry add pysqlite3, which throws me another exception:

Updating dependencies
Resolving dependencies... Downloading https://files.pythonhosted.org/packages/de/c2/34341d97acec471e26964811230209f3e604fdcd68587f314607ff1a2753/pysqlite3-0.5.1.tar.gz (0.6Resolving dependencies... (5.7s)

Package operations: 1 install, 0 updates, 0 removals

  • Installing pysqlite3 (0.5.1): Failed

  TypeError

  Can't instantiate abstract class IsolatedEnv with abstract methods make_extra_environ, python_executable

  at /opt/homebrew/Cellar/poetry/1.6.1_1/libexec/lib/python3.11/site-packages/poetry/installation/chef.py:109 in _prepare
      105│     ) -> Path:
      106│         from subprocess import CalledProcessError
      107│ 
      108│         with ephemeral_environment(self._env.python) as venv:
    → 109│             env = IsolatedEnv(venv, self._pool)
      110│             builder = ProjectBuilder(
      111│                 directory,
      112│                 python_executable=env.executable,
      113│                 scripts_dir=env.scripts_dir,

Did I misunderstand what you want me to do?

[coleifer]

That appears to be a bug in “poetry”. I suggest asking them or just use pip.

[franziskavonalbedyll]

That appears to be a bug in “poetry”. I suggest asking them or just use pip.

I will report to them, thank you for your help.