Upgrade Windows and macOS installers to use SQLite 3.45

[erlend-aasland]

SQLite 3.45 was released a couple of weeks ago. A patch version recently arrived, so more might follow. There are som bug fixes for long standing bugs included, so we might want to backport this to the 3.12 and 3.11 installers.

Linked PRs

• gh-115009: Update Windows installer to use SQLite 3.45.1 #115065
• gh-115009: Update macOS installer to use SQLite 3.45.1 #115066
• [3.12] gh-115009: Update macOS installer to use SQLite 3.45.1 (#115066) #115071
• [3.11] gh-115009: Update macOS installer to use SQLite 3.45.1 (#115066) #115072
• [3.12] gh-115009: Update Windows installer to use SQLite 3.45.1 (#115065) #115110
• [3.11] gh-115009: Update Windows installer to use SQLite 3.45.1 (#115065) #115111
• gh-115009: Update macOS installer to use SQLite 3.45.3. #117443
• gh-115009: Update Windows installer to use SQLite 3.45.3. #117445
• [3.12] gh-115009: Update macOS installer to use SQLite 3.45.3 (GH-117443) #117981
• [3.12] gh-115009: Update Windows installer to use SQLite 3.45.3 (GH-117445) #118008

[JinBridger]

Hi! May I ask will 3.9 and 3.10 be updated to use SQLite 3.45.1? @erlend-aasland

[erlend-aasland]

Hi! May I ask will 3.9 and 3.10 be updated to use SQLite 3.45.1? @erlend-aasland

Probably not. Normally we only backport these changes to bugfix versions (currently, those are 3.12 and 3.11). 3.10 and 3.9 are only accepting security patches.

[JinBridger]

Hi! May I ask will 3.9 and 3.10 be updated to use SQLite 3.45.1? @erlend-aasland

Probably not. Normally we only backport these changes to bugfix versions (currently, those are 3.12 and 3.11). 3.10 and 3.9 are only accepting security patches.

Got it. Thanks!

[erlend-aasland]

You could try pysqlite3 or apsw on PyPI :)

[deresatom]

You could try pysqlite3 or apsw on PyPI :)

Thanks for the tip!

Btw, the latest 3.12.2 windows installer (v3.12.2:6abddd9) from python.org is installing 3.43.1 instead of 3.45.1. shouldn't it install the latest as this is closed & merged? Thanks!

[erlend-aasland]

Btw, the latest 3.12.2 windows installer (v3.12.2:6abddd9) from python.org is installing 3.43.1 instead of 3.45.1. shouldn't it install the latest as this is closed & merged? Thanks!

Unfortunately, the Windows PR was merged after 3.12.2 landed, IIRC. It should be included in 3.12.3, though.

[jiangwen365]

Hello! May I ask will 3.12.3 and 3.11.8 get the update of SQLite 3.45.2, which fixed some minor query result bugs?
It would be great if it could catch up the next bug-fixing release which will come out soon.
Really appreicated~ @erlend-aasland

[felixxm]

Hello! May I ask will 3.12.3 and 3.11.8 get the update of SQLite 3.45.2, which fixed some minor query result bugs? It would be great if it could catch up the next bug-fixing release which will come out soon. Really appreicated~ @erlend-aasland

I was thinking the same thing yesterday, #117443, #117445.

There are some new bugfixes in the 3.45 branch so we can try waiting a few days for 3.45.3 🤔

[erlend-aasland]

@jiangwen365, I don't think we'll get it in the upcoming 3.11 release; Pablo is already working on getting it out.

[erlend-aasland]

@felixxm: yeah, perhaps we should wait for the .3 release.

[erlend-aasland]

@jiangwen365, I don't think we'll get it in the upcoming 3.11 release; Pablo is already working on getting it out.

Sorry, the last bug-fix 3.11 release is just out now, and the 3.11 branch is now only accepting security fixes. This means the bundled SQLite won't be updated unless there is a pressing security need.

[jiangwen365]

@jiangwen365, I don't think we'll get it in the upcoming 3.11 release; Pablo is already working on getting it out.

Sorry, the last bug-fix 3.11 release is just out now, and the 3.11 branch is now only accepting security fixes. This means the bundled SQLite won't be updated unless there is a pressing security need.

Many thanks! I have already moved my all production code to Python 3.12 since 3.12.1 came out. Was thinking many people were still using Python 3.11, and didn't realize 3.11 is already in security fix only status, while this sqlite version is actually a new feature release.

[erlend-aasland]

The Windows and macOS installers are now updated to use SQLite 3.45.3. The 3.12 backport for macOS is in flight, and Mariusz is working on the Windows backport.