Sqlitecpp Update Sqlite
Developmentsqlitecpp-update-sqliteSqlitecpp Update Sqlite is an Agent Skill for development published in the SRombauts/SQLiteCpp repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.
How to update the bundled SQLite3 amalgamation (sqlite3/sqlite3.c and sqlite3.h) and the Meson wrap. Use when upgrading SQLite, refreshing the vendored amalgamation, or bumping the sqlite3 wrap.
How to use this skill
Bring this guide into your coding agent with a prompt tailored to the tool you use.
- Open your project in Codex.
- Copy and paste the prompt below.
- Review files and risks before approving any action.
Inspect the Agent Skill at https://github.com/SRombauts/SQLiteCpp/blob/HEAD/.claude/skills/sqlitecpp-update-sqlite/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/sqlitecpp-update-sqlite, but wait for my approval before writing files or running scripts.
Copying this prompt does not install or run the skill. Review third-party files before use.
Updating the bundled SQLite3
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.
1. Download the amalgamation
Get sqlite-amalgamation-NNNNNNN.zip from the SQLite download page.
NNNNNNN encodes the version with two digits per component: 3.51.3 is 3510300.
2. Replace the vendored files
Extract and overwrite, verbatim, with the files from the zip:
sqlite3/sqlite3.csqlite3/sqlite3.h
Do 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.
3. Update sqlite3/README.md
- The amalgamation line: filename, version, and release date, e.g.
"sqlite3.c" and "sqlite3.h" files from sqlite-amalgamation-3510300.zip (SQLite 3.51.3 2026-03-13) - The copyright year, if the year has rolled over.
4. Update the copyright year
Bump the year in sqlite3/CMakeLists.txt if it changed (it tracks the same 2012-<year> range).
5. Update the Meson wrap (separate concern)
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.
6. Build, test, and record
- Build and run the tests on both CMake and Meson (see [[sqlitecpp-build-cmake]] and [[sqlitecpp-build-meson]]).
- Add the CHANGELOG entry per [[sqlitecpp-workflow]]:
- 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]].