# Sqlitecpp Sqlite Flags

> SQLiteCpp and sqlite3 feature flags for CMake and Meson builds.

- Skill: `srombauts/sqlitecpp-sqlite-flags` (Agent Skill)
- Install (CLI): `npx skillmds@latest add srombauts/sqlitecpp-sqlite-flags`
- Raw SKILL.md: https://api.skillmd.com/api/skills/srombauts/sqlitecpp-sqlite-flags/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: srombauts (https://skillmd.com/u/srombauts)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/srombauts/sqlitecpp-sqlite-flags

---


# SQLiteCpp and SQLite Flags

## Core SQLiteCpp options (CMake)
- `SQLITECPP_INTERNAL_SQLITE` (ON): build bundled sqlite3.
- `SQLITECPP_USE_ASAN` (OFF): address sanitizer.
- `SQLITECPP_USE_GCOV` (OFF): coverage.
- `SQLITECPP_DISABLE_STD_FILESYSTEM` (OFF): disable std::filesystem.
- `SQLITECPP_DISABLE_EXPANDED_SQL` (OFF): disable sqlite3_expanded_sql.

## Core SQLiteCpp options (Meson)
- `SQLITECPP_DISABLE_STD_FILESYSTEM` (OFF): disable std::filesystem.
- `SQLITECPP_DISABLE_SQLITE3_EXPANDED_SQL` (OFF): disable sqlite3_expanded_sql.

## SQLite feature flags (CMake and Meson)
- `SQLITE_ENABLE_COLUMN_METADATA`: enable `getColumnOriginName()` (CMake default `ON`, Meson default `false`).
- `SQLITE_ENABLE_ASSERT_HANDLER` (OFF): enable custom assert handler.
- `SQLITE_HAS_CODEC` (OFF): enable codec API (SQLCipher).
- `SQLITE_USE_LEGACY_STRUCT` (OFF): legacy `sqlite3_value`.
- `SQLITE_OMIT_LOAD_EXTENSION` (OFF): disable load_extension.

## Internal sqlite3 feature flags (CMake)
- `SQLITE_ENABLE_RTREE` (OFF): enable RTree (internal sqlite3).
- `SQLITE_ENABLE_DBSTAT_VTAB` (OFF): enable DBSTAT (internal sqlite3).

## DLL build flags (Windows)
- `BUILD_SHARED_LIBS=ON` adds `SQLITECPP_COMPILE_DLL` and `SQLITECPP_DLL_EXPORT`.

## Usage notes
- Column metadata requires sqlite3 built with `SQLITE_ENABLE_COLUMN_METADATA`.
- External sqlite3 may not support load_extension on macOS.