I get this warning message after installing 2024.8.3.
However when I run
sudo apt install sqlite3
It says
sqlite3 is already the newest version (3.37.2-2ubuntu0.3)
Does anyone know what I should do?
I get this warning message after installing 2024.8.3.
However when I run
sudo apt install sqlite3
It says
sqlite3 is already the newest version (3.37.2-2ubuntu0.3)
Does anyone know what I should do?
Update Ubuntu first?
I have Linux Mint 21.3, which is based on Ubuntu 22.04.
Many users will be on a 22.04 based system, which receives LTS (Long-Term Support) until 2027. One wonders why this wasnât good enough, it includes v3.37.2 of sqlite
Iâve set the âCritical Repair promptâ to ignored for now.
@bdraco , as you seem to be involved in the upcoming SQLite dependency version bump, could you provide insights?
Iâm surprised about this warning in general. The SQLite client is pulled in via pip, not as an OS-provided client, right? (e.g., I donât have any sqlite apt packages installed in my operating system).
If thatâs so, then it is out-of-scope for the Home Assistant administrator to take care of updating SQLite. Instead, it will take place via an upcoming Home Assistant update.
We would need someone to make a long term commitment to testing and maintaining older versions until 2027, and dealing with writing any manual migrations that canât be done on all versions to realistically be able to support old versions to make that happen.
SQLite is provided by the operating system in almost all cases. Python is generally linked against the SQLite provided by the operating system unless youâve compiled your own custom python, with its statically linked to a different version
I didnât know that. Thank you for this clarification.
My Home Assistant Core installation runs on Ubuntu 22.04.4 LTS jammy (Raspberry Pi 4B).
Because Ubuntu 22.04âs apt package archives only provide Python 3.10, and because previous HA upgrades bumped the minimum Python version requirements to Python 3.12 currently (2024.8.x), I leverage Python3.12 from the deadsnakes PPA.
Assuming I understand the deadsnakes Python3.12 build process correctly, it uses Ubuntu 22.04âs âoriginalâ libsqlite3-dev
, which will probably stay at version 3.37.2
.
Confirming command:
$ python3.12 -c 'import sqlite3;print(sqlite3.sqlite_version)'
3.37.2
# learned from https://discuss.python.org/t/will-sqlite3-be-updated-in-the-standard-library-to-address-fixed-cvss-vulnerabilities/48629
So in case the proposed amendment doesnât make it, us Ubuntu 22.04 homelab users will have a long weekend in February 2025, or just shrug it off and peak/sunset at Home Assistant 2025.01.