OpenParable
Skip to content
← Back to skills

Sqlitecpp Troubleshooting

Testing & Quality
sqlitecpp-troubleshooting

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

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-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 C2065 or C2039 usually means a missing include or wrong symbol.
  • GCC/Clang: use of undeclared identifier or no member named indicates 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.

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

Destructors and assertions

  • Do not throw in destructors; use SQLITECPP_ASSERT() instead.