Sqlite3 not working

Community Cloud
1

If you’re creating a debugging post, please include the following info:

  1. Share the link to the public app (deployed on Community Cloud).
  2. Share the link to your app’s public GitHub repository (including a requirements file).
  3. Share the full text of the error message (not a screenshot).
  4. Share the Streamlit and Python versions.

My sqlite3 app was working for a week and then all of a sudden it’s saying this:

13:22:35] 🚀 Starting up repository: 'streamlit_andrew-s_app', branch: 'main', main module: 'andrew_is_3.py'

[13:22:35] 🐙 Cloning repository...

[13:22:36] 🐙 Cloning into '/mount/src/streamlit_andrew-s_app'...
Warning: Permanently added the ED25519 host key for IP address '140.82.113.3' to the list of known hosts.

[13:22:36] 🐙 Cloned repository!

[13:22:36] 🐙 Pulling code changes from Github...

[13:22:37] 📦 Processing dependencies...



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



Using uv pip install.

  × No solution found when resolving dependencies:

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

      sqlite3, we can conclude that the requirements are unsatisfiable.

Checking if Streamlit is installed



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





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



Using standard pip install.

Collecting pandas (from -r /mount/src/streamlit_andrew-s_app/requirements.txt (line 1))

  Downloading pandas-2.2.2-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.metadata (19 kB)

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

ERROR: No matching distribution found for sqlite3

Checking if Streamlit is installed



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



[13:22:40] ❗️ installer returned a non-zero exit code

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

[13:24:15] ❗️ Streamlit server consistently failed status checks

[13:24:15] ❗️ Please fix the errors, push an update to the git repo, or reboot the app.
2

Remove sqlite3 from your requirements.

1 Like
3

Thank you for the reply. The app is now working but all the information that was stored with sqlite3 was lost. I was using this to track rsvp’s. Any suggestions for future use of streamlit that can store information even if the app reboots?

4

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.