菜单
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.
默认使用会先检查来源的 Prompt；你也可以切换为直接命令，或下载本地副本。
决定是否安装前，请先阅读 SKILL.md，以及 SkillsMP 当前展示的配套文件。
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
直接命令不会经过审查 Prompt；运行前请先检查来源。
npx skills add https://github.com/SRombauts/SQLiteCpp --skill sqlitecpp-update-sqlite命令会保持在同一行。复制前请横向滚动并检查完整内容。
想先保存到本地？可下载 SkillsMP 当前能够提供的文件。
SQLiteCpp change workflow checklists for API, tests, build files, and CHANGELOG updates. Use when adding a method or class, editing build files, or writing a CHANGELOG entry for a PR.
SQLiteCpp CI workflow patterns. Use for GitHub Actions, AppVeyor, Travis, matrices, or test steps.
Running shell commands on this Windows checkout via the PowerShell and Bash tools, and passing multi-line or quoted arguments (commit messages, PR bodies, file content) without corruption. Use when running git or gh with multi-line or quoted input, writing a commit message or PR body from the command line, reaching for a heredoc or here-string, or after a message or body comes out wrapped in stray characters such as a leading and trailing `@`.
基于 SOC 职业分类
正在显示 SKILL.md
| name | sqlitecpp-update-sqlite |
| description | 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. |
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]].