Sqlitecpp Troubleshooting
Testing & Qualitysqlitecpp-troubleshootingSqlitecpp Troubleshooting is an Agent Skill for testing & quality published in the SRombauts/SQLiteCpp repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.
Diagnose SQLiteCpp build, linker, compiler, and sqlite3 integration issues.
QUICK START
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.
Prompt to paste
Inspect the Agent Skill at https://github.com/SRombauts/SQLiteCpp/blob/HEAD/.claude/skills/sqlitecpp-troubleshooting/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/sqlitecpp-troubleshooting, 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.
SQLiteCpp Troubleshooting
Common compiler errors
- MSVC:
error C2065orC2039usually means a missing include or wrong symbol. - GCC/Clang:
use of undeclared identifierorno member namedindicates missing includes or API mismatch.
Common linker errors
LNK2019 unresolved external symbol "SQLite::Database::exec":- Missing SQLiteCpp library or missing source file in build.
Missing sqlite3 on Linux
- Errors like
undefined reference to sqlite3_xxx:- Install
libsqlite3-dev, or enable internal sqlite3. - CMake option:
-DSQLITECPP_INTERNAL_SQLITE=ON.
- Install
Column metadata error
undefined reference to sqlite3_column_origin_name:- Your sqlite3 library lacks
SQLITE_ENABLE_COLUMN_METADATA. - Options:
- Rebuild sqlite3 with that flag.
- Disable
SQLITE_ENABLE_COLUMN_METADATA. - Use internal sqlite3 (
SQLITECPP_INTERNAL_SQLITE=ON).
- Your sqlite3 library lacks
Destructors and assertions
- Do not throw in destructors; use
SQLITECPP_ASSERT()instead.