Streamlit show unable to install dependencies

this was the error message i got when trying to deploy my interactive dashboard.

[     UTC     ] Logs for akhcapital-investment-dashboard.streamlit.app/

────────────────────────────────────────────────────────────────────────────────────────

[09:14:04] 🚀 Starting up repository: 'akh_project', branch: 'master', main module: 'Investment_dashboard1.1.py'

[09:14:04] 🐙 Cloning repository...

[09:14:04] 🐙 Cloning into '/mount/src/akh_project'...

[09:14:04] 🐙 Cloned repository!

[09:14:04] 🐙 Pulling code changes from Github...

[09:14:05] 📦 Processing dependencies...


──────────────────────────────────────── uv ───────────────────────────────────────────


Using uv pip install.

Using Python 3.12.9 environment at /home/adminuser/venv

  × No solution found when resolving dependencies:

  ╰─▶ Because sqlite3 was not found in the package registry and you require

      sqlite3, we can conclude that your requirements are unsatisfiable.

Checking if Streamlit is installed

Installing rich for an improved exception logging

Using uv pip install.

Using Python 3.12.9 environment at /home/adminuser/venv

Resolved 4 packages in 119ms

Prepared 4 packages in 169ms

Installed 4 packages in 16ms

 + markdown-it-py==3.0.0

 + mdurl==[2025-03-25 09:14:07.289852] 0.1.2

 + pygments==2.19.1

 + rich==13.9.4


────────────────────────────────────────────────────────────────────────────────────────



──────────────────────────────────────── pip ───────────────────────────────────────────


Using standard pip install.

Collecting streamlit (from -r /mount/src/akh_project/requirements.txt (line 1))

  Downloading streamlit-1.43.2-py2.py3-none-any.whl.metadata (8.9 kB)

Collecting pandas (from -r /mount/src/akh_project/requirements.txt (line 2))

  Downloading pandas-2.2.3-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.metadata (89 kB)

     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 89.9/89.9 kB 3.7 MB/s eta 0:00:00[2025-03-25 09:14:09.317186] 

Collecting yfinance (from -r /mount/src/akh_project/requirements.txt (line 3))

  Downloading yfinance-0.2.55-py2.py3-none-any.whl.metadata (5.8 kB)

Collecting plotly (from -r /mount/src/akh_project/requirements.txt (line 4))

  Downloading plotly-6.0.1-py3-none-any.whl.metadata (6.7 kB)

ERROR: Ignored the following versions that require a different python version: 0.55.2 Requires-Python <3.5

ERROR: Could not find a version that satisfies the requirement sqlite3 (from versions: none)

ERROR: No matching distribution found for sqlite3


[notice] A new release of pip is available: 24.0 -> 25.0.1

[notice] To update, run: pip install --upgrade pip

Checking if Streamlit is installed

Installing rich for an improved exception logging

Using standard pip install.

Collecting rich>=10.14.0

  Downloading rich-13.9.4-py3-none-any.whl.metadata (18 kB)

Collecting markdown-it-py>=2.2.0 (from rich>=10.14.0)

  Downloading markdown_it_py-3.0.0-py3-none-any.whl.metadata (6.9 kB)

Collecting pygments<3.0.0,>=2.13.0 (from rich>=10.14.0)

  Downloading pygments-2.19.1-py3-none-any.whl.metadata (2.5 kB)

Collecting mdurl~=0.1 (from markdown-it-py>=2.2.0->rich>=10.14.0)

  Downloading mdurl-0.1.2-py3-none-any.whl.metadata (1.6 kB)

Downloading rich-13.9.4-py3-none-any.whl (242 kB)

   ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 242.4/242.4 kB 14.3 MB/s eta 0:00:00[2025-03-25 09:14:10.770298] 

Downloading markdown_it_py-3.0.0-py3-none-any.whl (87 kB)

   ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 87.5/87.5 kB 127.6 MB/s eta 0:00:00[2025-03-25 09:14:10.782687] 

Downloading pygments-2.19.1-py3-none-any.whl (1.2 MB)

   ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.2/1.2 MB 85.3 MB/s eta 0:00:00[2025-03-25 09:14:10.808632] 

Downloading mdurl-0.1.2-py3-none-any.whl (10.0 kB)

Installing collected packages: pygments, mdurl, markdown-it-py, rich

  Attempting uninstall: pygments

    Found existing installation: Pygments 2.19.1

    Uninstalling Pygments-2.19.1:

      Successfully uninstalled Pygments-2.19.1

  Attempting uninstall: mdurl

    Found existing installation: mdurl 0.1.2

    Uninstalling mdurl-0.1.2:

      Successfully uninstalled mdurl-0.1.2

  Attempting uninstall: markdown-it-py

    Found existing installation: markdown-it-py 3.0.0

    Uninstalling markdown-it-py-3.0.0:

      Successfully uninstalled markdown-it-py-3.0.0

  Attempting uninstall: rich

    Found existing installation: rich 13.9.4

    Uninstalling rich-13.9.4:

      Successfully uninstalled rich-13.9.4

Successfully installed markdown-it-py-3.0.0 mdurl-0.1.2 pygments-2.19.1 rich-13.9.4


[notice] A new release of pip is available: 24.0 -> 25.0.1

[notice] To update, run: pip install --upgrade pip


────────────────────────────────────────────────────────────────────────────────────────


[09:14:13] ❗️ installer returned a non-zero exit code

[09:14:13] ❗️ Error during processing dependencies! Please fix the error and push an update, or try restarting the app.

Indeed sqlite3 cannot be installed, don’t try to install it.

Thanks

It is now working