Update SQLite to 3.40.1 or later (can't update)

1

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?

1 Like
2

Update Ubuntu first?

3

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.

4

image
image1309×889 63.3 KB

@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.

5

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.

6

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

1 Like
7

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.