Menu

SQLite 3.54 stops rewriting an expression index when the indexed value hasn't changed
📰

SQLite 3.54 stops rewriting an expression index when the indexed value hasn't changed

DEV Community: database·Alex Georgiev·16 days ago
#7KsfIDIb
#devtodatabase#devto#dev#index#sqlite
Reading 0:00
15s threshold

I update a column, the value SQLite computes from it for an index doesn't actually change, and until 3.54 that index still got rewritten anyway. That's a real line from SQLite's own changelog, not a bug report I filed: "when doing an UPDATE on a table that has expression indexes, do not change the expression index if the value being indexed is unchanged." I wanted to know what that was worth in bytes written, not just in changelog prose.

SQLite 3.54.0 shipped on 9 October 2026, with a point release, 3.54.1, on 16 October fixing an unrelated 32-bit buffer bug. I compared 3.54.1 against 3.53.0, the previous stable line, using the precompiled Linux CLI builds from sqlite.org.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.