sqlite

The SQLite command-line shell for OpenCharly images — for creating and querying self-contained SQLite databases.

The sqlite candy installs the sqlite package, which ships the sqlite3 CLI at /usr/bin/sqlite3. The binary runs SQL against an in-memory or on-disk SQLite database.

Compose the layer by pinning this repo in a box's candy: list:

my-box:
  candy:
    base: fedora
    candy:
      - '@github.com/opencharly/layer-sqlite:v2026.239.1638'

Then, inside the built image (or on a dev host):

sqlite3 --version
sqlite3 :memory: "CREATE TABLE t(x INTEGER); INSERT INTO t VALUES(42); SELECT x FROM t;"

The candy's plan: asserts the binary exists, the package is recorded, the version is a 3.x string, and a real in-memory query returns the stored row — a non-functional binary fails the check.

• charly.yml — the sqlite: candy entity (the distro.{arch,fedora}: package sections and the check: probes) and the embedded sqlite-skill: skill entity.
• .github/workflows/tag-on-merge.yml — CalVer tag + CHANGELOG/ on merge.
• README.md — this user overview.

• Owning skill: /charly-infrastructure:sqlite
• Companion CLI bundle: /charly-coder:dev-tools
• opencharly/charly — the charly CLI and image builder
• opencharly/opencharly — the umbrella