OpenParable
Skip to content
← Back to skills

Sqlitecpp Update Sqlite

Development
sqlitecpp-update-sqlite

Sqlitecpp 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.

View on GitHub ↗
QUICK START

How to use this skill

Bring this guide into your coding agent with a prompt tailored to the tool you use.

  1. Open your project in Codex.
  2. Copy and paste the prompt below.
  3. Review files and risks before approving any action.
Prompt to paste
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.c
  • sqlite3/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]].