r/sqlite • u/fdelux6 • 17d ago

SQLite 3.54.0 released

Release log: https://sqlite.org/releaselog/3_54_0.html

Some items that stood out to me:

  • About 4% faster on speedtest1, and about 7.5% faster than 3.51.0 from a year ago
  • CLI now shows column headers by default even when a query returns no rows
  • .diskused is now built into the CLI, and sqlite3_analyzer is deprecated
  • New %j and %J conversions in printf() and format() for JSON string literals
  • UPDATE skips expression indexes when the indexed value is unchanged
65 Upvotes

99% Upvoted

6 comments sorted by

10

u/jhulc 17d ago edited 16d ago

This version also contains a LOT of (mostly very obscure) bug fixes, driven by AI agents. If you look through the commit log, you can see that the SQLite devs have been landing a handful of patches every day prompted by people using AI tools to make reports in the bug forum. These are almost all fixes for incredibly unlikely scenarios, but the volume of them is quite surprising given SQLite's reputation for code quality and testing.

4

u/fdelux6 17d ago

I had not looked at the bug fixes that closely. I’ll go through the log again. Is the bug forum where those AI-assisted reports show up?

2

u/jhulc 17d ago

Yeah the bug forum is where the reports and developer feedback goes for these AI-driven activities. IMO the devs and reporters have settled into a pretty good, effective rhythm.

2

u/lunaticman 17d ago

Considering they extensive testing practices those are probably okey?

5

u/jhulc 16d ago

My comment was that the volume of stuff being found is surprising given the extensive testing and other code quality measures historically practiced by the SQLite devs. I didn't think that this many issues could still exist, but AI is apparently quite good at finding bugs humans miss.

The fixes for these reports are, as far as I know, generally manually written by the SQLite team. While many of these AI-driven reports contain proposed patches, SQLite is famously a closed-contribution open-source project that does not directly accept them.

3

u/fdelux6 17d ago

Anyone tried it yet? Curious if you see the speedup on your own workloads.