go-authcrunch: Skill for Codex

SQLite Messaging

plugins/messaging/sqlite implements messaging.Provider with kind sqlite. Success from Send means durable local queue acceptance. This plugin does not send email, run a worker, or guarantee final delivery.

Provisioning and integration

Use parser.NewSQLiteMessagingConfigFromDirectives([]string): required name and absolute path, optional timeout (default 1s; 1ms through 30s). Each setting occurs once with one value. Parsing has no filesystem effects. New(ctx, config) snapshots settings and opens storage. Read the SQLite file contract for private local POSIX files, errors, commit uncertainty and caller-owned Close. The database is plaintext, including notification bodies and confirmation codes.

Bind an open queue using messaging.Config.AddProvider(name, outbox), then call Validate before publishing. Bindings are runtime-only, survive Validate, and are excluded from JSON/XML/YAML. Duplicate names and reserved built-in kinds fail. messaging.Config.Validate reparses nonempty raw declarations as the authority; when raw declarations are absent it preserves and validates typed native email and file providers instead. Duplicate names across built-in kinds and runtime injections fail; unsuccessful validation retains the previous published lists. Outbox.CheckReady(ctx) checks the opened queue through a bounded empty read transaction without consuming messages or altering leases. Configuration-only Validate remains pure; workflow/root hosts use readiness before publication. The factory remains email/file-only: hosts must reconstruct injections on reload. AsMap returns only name/kind. Configured names select logical queues; the file's capacity is shared across those queues. Drain producers/workers before Close.

Registration's LocalUserRegistryProvider.Notify selects generic providers through ExtractProvider, retaining the built-in email/file paths. Rendering stays with registry. Its current body is quoted-printable HTML; a delivery adapter must preserve that encoding contract or explicitly decode/re-encode it. The outbox preserves body bytes and supplies no sender or MIME headers. A host worker owns sender configuration and its independent transport credentials. Never persist SendInput.Credentials in queue records; non-nil credentials are rejected.