Skip to main content

sqlitecpp-update-sqlite

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.

ソース情報

リポジトリ
SRombauts/SQLiteCpp
ソースの最終更新活動
2026年7月24日 13:45
検出された SKILL.md の言語
英語
スター
2,789
フォーク
575

インストール方法

デフォルトでは、最初にソースを確認する Prompt が選択されています。直接コマンドに切り替えるか、ローカルコピーをダウンロードすることもできます。

ソースファイルを確認

インストールを決める前に、SKILL.md と SkillsMP に表示されている付属ファイルをお読みください。

SKILL.md を表示中

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.
# 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](https://www.sqlite.org/download.html). `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]]). - Update `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]].
GitHubで見る