Update installers to use SQLite 3.49

[erlend-aasland]

Proposal:

We'e been skipping some SQLite versions lately; currently we're shipping the macOS and Windows installers with SQLite 3.45.3 (released 300 days ago, 2024-04-15). SQLite 3.49.0 recently came out, so we should probably hold off upgrading for a couple of weeks to see if patch releases appear.

See also #129870.

Has this already been discussed elsewhere?

No response given

Links to previous discussion of this feature:

No response

Linked PRs

• gh-129917: Update installers to use SQLite 3.49 #131025
• [3.13] gh-129917: Update installers to use SQLite 3.49.1 (GH-131025) #131957
• [3.12] gh-129917: Update installers to use SQLite 3.49.1 (#131025) #131958

[erlend-aasland]

@mhsmith, could you update the BeeWare sources repo with a tag for SQLite 3.49.0?

[erlend-aasland]

FTR: I've updated our sources repo to SQLite 3.49.0.

[ned-deily]

@erlend-aasland I'll update the macOS installer builds.

[mhsmith]

@mhsmith, could you update the BeeWare sources repo with a tag for SQLite 3.49.0?

Done – the tag for android.py is sqlite-3.49.0-0.

[erlend-aasland]

3.49.1 was released 9 days ago. Let's hold it a little bit more.

[erlend-aasland]

3.49.1 was released 9 days ago. Let's hold it a little bit more.

3.49.2 is on its way: https://sqlite.org/src/info/eaa2503ef699d036

[zooba]

It looks like those changes aren't critical, so it's probably a good time to add this into our 3.14 releases, in case we help flush out any genuine issue.

[erlend-aasland]

It looks like those changes aren't critical, so it's probably a good time to add this into our 3.14 releases, in case we help flush out any genuine issue.

Sure, let's go with 3.49.1. I already updated the sources repo with the .1 patch release. @mhsmith, can you update the BeeWare sources repo again?

[mhsmith]

@erlend-aasland: Since we're planning to migrate the Android sources repo to the Python GitHub organization in the near future, I've given you write access to it. You can automatically trigger a build and release by adding a tag to the head of the main branch, in the same format as the existing tags, and pushing it to GitHub.

I've also added the release managers @Yhg1s and @hugovk, and I'll add anyone else on the core team on request.

[mhsmith]

3.49.1 had some changes which conflicted with the Android patch, so I've fixed that and built a release.

[ned-deily]

The SQLite build changes between 3.45.3 and 3.49.1 have also broken the macOS installer build. I've put a "do not merge" label on the PR until I get it fixed tomorrow.

[erlend-aasland]

The SQLite build changes between 3.45.3 and 3.49.1 have also broken the macOS installer build. I've put a "do not merge" label on the PR until I get it fixed tomorrow.

What's the issue?

[mhsmith]

They've completely replaced their build system (from autoconf to autosetup), so all except the simplest build scripts will need to be updated.

[ned-deily]

I figured out what got broken in our macOS installer builds going from our last rev bump (3.45.3) to 3.49.1 and, yes, it was due to the autoconf to autosetup change in 3.48 (not quite as transparent a change as they believed as we were not the only downstream builders to be affected). In any case, the fixes for the macOS installer are now included in PR #131025 and I've tested them with main (3.14). They should backport OK to 3.13 and 3.12 if you decide to do so.

[erlend-aasland]

Thanks, Ned!

[erlend-aasland]

I wonder if they amended the autoconf changes; the SQLite 3.49.2 changelog has this extremely vague bullet item:

Incremental improvements to the configure/make.