Installing Chasten for MacOS

[rodriguez03]

We could write in the issues that here are several ways to install chasten. Anyone is welcome to contribute more ways

pip failed to build package:
    pysqlite3

Some possibly relevant errors from pip install:
    error: subprocess-exited-with-error
    src/connection.c:1385:10: error: implicit declaration of function 'sqlite3_enable_load_extension' is invalid in C99 [-Werror,-Wimplicit-function-declaration]
    src/connection.c:1409:10: error: implicit declaration of function 'sqlite3_load_extension' is invalid in C99 [-Werror,-Wimplicit-function-declaration]
    error: command '/usr/bin/clang' failed with exit code 1

or another error looks like:

failed to building wheels for pysqlite3

[Jaclynpqc]

Here are the ways I've tried to install pysqlite3 on MacOS but failed. Maybe they will work for you. The aim of this issue is to provide a comprehensive guide for troubleshooting 'pysqlite3' installation issues on macOS.

1. Guidance from Discord (Claire's Instruction) @churd01 Attempted to follow installation instructions provided by Claire in Developer Development community, details of which can be viewed here: https://discord.com/channels/1145161007459745852/1146079356402278521/1146576453161467904 Outcome: when I run this command, the Error indicates 'Permission Denied ln -s /usr/local/opt/sqlite/bin/sqlite3 /usr/local/bin/

2. Pip Install Attempt Command: pip install pysqlite3 Outcome: Error message as follows ERROR: Failed building wheel for pysqlite3 Running setup.py clean for pysqlite3 Failed to build pysqlite3 ERROR: Could not build wheels for pysqlite3, which is required to install pyproject.toml-based projects Actions Taken:

• Verified macOS version
• Verified Python version (Python 3.11)
• Attempted to upgrade 'pysqlite3' and the package that depends on it using pip install --upgrade
• Investigated Github issue trackers related to 'pysqlite3'. including: https://github.com/coleifer/pysqlite3/issues/61 and https://github.com/coleifer/pysqlite3/issues/57

3. Virtual Environment Setup Command: Created a Python venv using python -m venv myenv and activated using ource myenv/bin/activate Outcome: Within the virtual environment, repeated the attempt to pip install pysqlite3, resulting the same error.

At the moment, I'm trying to remove pysqlite3 package from dependencies and make sure that Chasten is installed and run correctly. You can check out the issue here: https://github.com/AstuteSource/chasten/issues/46

Suggestions @rodriguez03 suggested overriding pysqlite3 in the Developer Development Discord group. You can read more details about her suggestion here: https://discord.com/channels/1145161007459745852/1145801720811765800/1149054131126943895

[gkapfham]

Briefly, here are some points to consider in regards to this issue:

• If possible, I would like to avoid the manual creation of virtual environments or the installation of dependencies with pip, at least when we are developing the tool ourselves. This means that, as developers, we should stick to using poetry.
• With that said, it is perfectly valid for you to raise an issue connected to the installation of the tool with either pipx or pip
• While I appreciate that this issue is specifically about MacOS we need to be absolutely sure that the suggestion works for all operating systems.

[gkapfham]

What is the status of this issue @Jaclynpqc and @rodriguez03?

[boulais01]

Is this resolved with the recent merging of pysqlite3-removal-test-branch?

[rodriguez03]

Most of our colleagues with Mac OS have gotten chasten to work