Talk to PostgreSQL, MySQL, and SQLite from iii — query, execute, transactions, prepared statements, and change feeds.
iiiverifiedexact versions are immutable; binary and bundle artifacts are digest-pinned.
Open an interactive transaction; returns a handle to use with transactionQuery/transactionExecute/commitTransaction/rollbackTransaction.
Logical database name. Optional — omitting it targets the sole configured database, or `primary` when several are configured.
JSON wire envelope returned by `beginTransaction`.
Commit and finalize an interactive transaction.
Run a write statement (INSERT/UPDATE/DELETE/DDL).
Logical database name. Optional — omitting it targets the sole configured database, or `primary` when several are configured.
Run an ordered batch of SQL statements atomically (bare strings or {sql, params} objects); rolls back on first failure.
Logical database name. Optional — omitting it targets the sole configured database, or `primary` when several are configured.
Optional: `read_committed` | `repeatable_read` | `serializable`.
Statements to run in order inside one transaction. Each entry is either a bare SQL string or `{ "sql": "...", "params": [...] }` — use `params` for dynamic values instead of inlining them into the SQL.
List all configured databases with connection details (driver, credential-redacted URL, pool settings, TLS mode). Config only — no health checks or live pool statistics.
"postgres" | "mysql" | "sqlite".
Logical key (e.g. "primary").
Pool settings echoed back from config (no live stats).
TLS settings. `ca_cert` is reported as a presence boolean only — never the path, which would leak filesystem layout.
Connection URL with credentials redacted.
Internal: reload connection pools from the authoritative configuration when it changes.
Configuration id that changed (advisory; the handler re-fetches the value). Schema-only: kept to publish a typed request schema; the handler ignores it.
Prepare a parameterized statement once.
Logical database name. Optional — omitting it targets the sole configured database, or `primary` when several are configured.
Run a read-only SQL query and return the result rows.
Logical database name. Optional — omitting it targets the sole configured database, or `primary` when several are configured.
Rollback and finalize an interactive transaction.
Run a previously-prepared handle.
Run a sequence of statements atomically.
Logical database name. Optional — omitting it targets the sole configured database, or `primary` when several are configured.
Run a write statement inside an interactive transaction. BEGIN/COMMIT/ROLLBACK are rejected; use commit/rollbackTransaction.
Run a read-only SQL query inside an interactive transaction.
Serve the database worker's injected console UI assets (content function for its console:script / console:style triggers).
The asset path from the trigger config (e.g. `state/page.js`).
The asset source, verbatim.
MIME type the console should serve the asset with.
Postgres logical replication. Stubbed in v1.0 pending tokio-postgres replication API.
