Set up instance on Streamlit Community Cloud

[caufieldjh]

@iQuxLE

Trying out an app deployment like this: https://blog.streamlit.io/host-your-streamlit-app-for-free/
See also: https://docs.streamlit.io/deploy/streamlit-community-cloud/deploy-your-app/secrets-management

Currently encountering an issue because the Streamlit cloud platform doesn't have the libraries gpt4all needs:

OSError: /usr/lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.29' not found (required by /home/adminuser/venv/lib/python3.11/site-packages/gpt4all/llmodel_DO_NOT_MODIFY/build/libllmodel.so)
2024-12-02 16:51:39.342 503 GET /script-health-check (127.0.0.1) 248.17ms

So this may work if that library is made optional.

[caufieldjh]

Fixed the gpt4all issue with #120 and #121 , now getting this error on the Streamlit deployment:

RuntimeError: �[91mYour system has an unsupported version of sqlite3. Chroma requires sqlite3 >= 3.35.0.�[0m
�[94mPlease visit https://docs.trychroma.com/troubleshooting#sqlite to learn how to upgrade.�[0m

[caufieldjh]

SCC supports installing/updating system packages with a packages.txt: https://docs.streamlit.io/deploy/streamlit-community-cloud/deploy-your-app/app-dependencies#apt-get-dependencies

Or use pysqlite3-binary as per here: https://discuss.streamlit.io/t/the-sqlite3-version-3-34-1-on-streamlit-cloud-is-too-old-could-you-upgrade-it/48019/3

[caufieldjh]

sqlite3 3.37.2 works well (locally - trying to get this to install on the SCC instance)

[caufieldjh]

Still not quite working even after specifying sqlite3 as an external dependency in packages.txt - unclear if it's getting updated or not.