iii / worker
$worker

iii-database

v1.0.4

Talk to PostgreSQL, MySQL, and SQLite from iii — query, execute, transactions, prepared statements, and change feeds.

  • macOS: arm64 · x64
  • Linux: arm64 · armv7 · x64
  • Windows: arm64 · x64 · x86

functions

5

iii-database::prepareStatement

function

Prepare a parameterized statement once.

request
  • dbstringrequired
  • sqlstringrequired
  • ttl_secondsinteger· uint64min 0
response
  • handleunknownrequired

iii-database::execute

function

Run a write statement (INSERT/UPDATE/DELETE/DDL).

request
  • dbstringrequired
  • paramsunknown[]
  • returningstring[]
  • sqlstringrequired
response
  • affected_rowsinteger· uint64requiredmin 0
  • last_insert_idstring
  • returned_rowsobject[]required
    empty object

iii-database::runStatement

function

Run a previously-prepared handle.

request
  • handle_idstringrequired
  • paramsunknown[]
response
  • columnsunknown[]required
  • row_countinteger· uintrequiredmin 0
  • rowsobject[]required
    empty object

iii-database::query

function

Run a read-only SQL query and return the result rows.

request
  • dbstringrequired
  • paramsunknown[]
  • sqlstringrequired
  • timeout_msinteger· uint64min 0
response
  • columnsunknown[]required
  • row_countinteger· uintrequiredmin 0
  • rowsobject[]required
    empty object

iii-database::transaction

function

Run a sequence of statements atomically.

request
  • dbstringrequired
  • isolationstring
  • statementsunknown[]required
response
  • committedbooleanrequired
  • errorunknown
  • failed_indexinteger· uintmin 0
  • resultsunknown[]

triggers

2

iii-database::row-change

trigger

Postgres logical replication. Stubbed in v1.0 pending tokio-postgres replication API.

invocation
valueunknown
return
valueunknown

iii-database::query-poll

trigger

Polls a SQL query at a fixed interval and dispatches new rows since the last cursor.

invocation
valueunknown
return
valueunknown