Does not work with python 3.11.1

[ikkysleepy]

Description

Trying to run the first command and it fails on my M2 Macbook with python 3.11.1

Expected Behavior

Install should work.

Current Behavior

(.venv) jorge@Jorges-MacBook-Pro-M2-555 aibot % python --version
Python 3.11.1
(.venv) jorge@Jorges-MacBook-Pro-M2-555 aibot % pip install mindsql==0.2.1

Collecting mindsql==0.2.1
Using cached mindsql-0.2.1-py3-none-any.whl.metadata (6.6 kB)
Collecting chromadb<0.5.0,>=0.4.22 (from mindsql==0.2.1)
Using cached chromadb-0.4.24-py3-none-any.whl.metadata (7.3 kB)
Collecting faiss-cpu<2.0.0,>=1.8.0 (from mindsql==0.2.1)
Using cached faiss_cpu-1.8.0.post1-cp311-cp311-macosx_11_0_arm64.whl.metadata (3.7 kB)
Collecting google-generativeai==0.3.2 (from mindsql==0.2.1)
Using cached google_generativeai-0.3.2-py3-none-any.whl.metadata (5.9 kB)
Collecting llama-cpp-python==0.2.47 (from mindsql==0.2.1)
Using cached llama_cpp_python-0.2.47.tar.gz (36.9 MB)
Installing build dependencies ... done
Getting requirements to build wheel ... done
Installing backend dependencies ... done
Preparing metadata (pyproject.toml) ... done
Collecting mysql-connector-python<9.0.0,>=8.3.0 (from mindsql==0.2.1)
Using cached mysql_connector_python-8.4.0-cp311-cp311-macosx_13_0_arm64.whl.metadata (1.9 kB)
Collecting numpy<2.0.0,>=1.26.4 (from mindsql==0.2.1)
Using cached numpy-1.26.4-cp311-cp311-macosx_11_0_arm64.whl.metadata (114 kB)
Collecting openai<2.0.0,>=1.12.0 (from mindsql==0.2.1)
Using cached openai-1.43.0-py3-none-any.whl.metadata (22 kB)
Collecting pandas==2.2.0 (from mindsql==0.2.1)
Using cached pandas-2.2.0-cp311-cp311-macosx_11_0_arm64.whl.metadata (19 kB)
Collecting plotly==5.19.0 (from mindsql==0.2.1)
Using cached plotly-5.19.0-py3-none-any.whl.metadata (7.0 kB)
Collecting psycopg2-binary<3.0.0,>=2.9.9 (from mindsql==0.2.1)
Using cached psycopg2_binary-2.9.9-cp311-cp311-macosx_11_0_arm64.whl.metadata (4.4 kB)
INFO: pip is looking at multiple versions of mindsql to determine which version is compatible with other requirements. This could take a while.
ERROR: Ignored the following versions that require a different python version: 1.21.2 Requires-Python >=3.7,<3.11; 1.21.3 Requires-Python >=3.7,<3.11; 1.21.4 Requires-Python >=3.7,<3.11; 1.21.5 Requires-Python >=3.7,<3.11; 1.21.6 Requires-Python >=3.7,<3.11
ERROR: Could not find a version that satisfies the requirement pysqlite3-binary<0.6.0,>=0.5.2.post3 (from mindsql) (from versions: none)
ERROR: No matching distribution found for pysqlite3-binary<0.6.0,>=0.5.2.post3

Steps to Reproduce (for Bugs)

Setup New PyCharm Project
Run command to install
pip install mindsql==0.2.1

Provide steps to reproduce the issue, if applicable.

Screenshots or Code Snippets (if applicable)

If applicable, include screenshots or code snippets to help explain the issue.

Possible Solution

If you have a suggestion for how to fix the issue, please describe it here.

Additional Context

Add any other context about the problem here.

Your Environment

• Operating System:
• Python Version: 3.11.1
• LLM, Vectorstore or Database (with version):
• Version of MindSQL (if known):
• Any other relevant details:

[Sammindinventory]

Have you tried installing the package from Git or Package manager? You can try the new env with

Create a new virtual environment

python -m venv mindsql_env

Activate the virtual environment

source mindsql_env/bin/activate # On macOS/Linux

mindsql_env\Scripts\activate # On Windows

Upgrade pip

pip install --upgrade pip

Install pysqlite3-binary

pip install pysqlite3-binary==0.5.2.post3

Finally, install MindSQL

pip install mindsql==0.2.1