How to update the bundled SQLite3 amalgamation (sqlite3/sqlite3.c and sqlite3.h), the Meson wrap, README.md, and CHANGELOG.md. Use when upgrading SQLite, refreshing the vendored amalgamation, or bumping the sqlite3 wrap.
91%
Does it follow best practices?
Run evals on this skill
Adds up to 20 points to the overall score
Low
Low-risk findings worth noting
SQLiteCpp ships a copy of the SQLite3 amalgamation under sqlite3/ so the CMake build works with
no system dependency. The Meson build instead pulls SQLite from wrapdb via a wrap file. An upgrade
touches both.
Do this on a dedicated branch named update-sqlite-X.Y.Z (for example update-sqlite-3.52.2),
matching the SQLite version you are moving to.
Get sqlite-amalgamation-NNNNNNN.zip from the SQLite download page.
NNNNNNN encodes the version with two digits per component: 3.51.3 is 3510300.
Extract and overwrite, verbatim, with the files from the zip:
sqlite3/sqlite3.csqlite3/sqlite3.hDo not hand-edit them. Build-time feature flags (SQLITE_OMIT_LOAD_EXTENSION,
SQLITE_ENABLE_COLUMN_METADATA, and the rest in [[sqlitecpp-sqlite-flags]]) are passed as compile
definitions, never by patching the amalgamation.
sqlite3/README.md"sqlite3.c" and "sqlite3.h" files from sqlite-amalgamation-3510300.zip (SQLite 3.51.3 2026-03-13)Bump the year in sqlite3/CMakeLists.txt if it changed (it tracks the same 2012-<year> range).
subprojects/sqlite3.wrap points at a wrapdb release and can lag behind the CMake amalgamation
version. Bump it to the matching sqlite3_X.Y.Z-N package (the directory, source_url,
source_filename, source_hash, patch_*, and wrapdb_version fields). This is often a separate
PR from the amalgamation drop.
CHANGELOG.md following [[sqlitecpp-workflow]] conventions:
Add one line (or update the existing one) under the current unreleased version heading:
- Update SQLite from A.B.C to X.Y.Z (YYYY-MM-DD) (#NNN).The SQLite version bump is independent of the SQLiteCpp version. Bumping the SQLiteCpp version and tagging are the release process: see [[sqlitecpp-release]].
SRombauts/SQLiteCpp
7302cd3
If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.