Skip to content

sql-storage-adapter v0.7.11

Choose a tag to compare

@github-actions github-actions released this 16 Oct 23:06
· 265 commits to master since this release
2086684

Added

  • Row-change events: withChangeEvents(adapter) adds onChange(listener, { tables }), which reports each INSERT, UPDATE, DELETE and TRUNCATE made through the adapter (run, batch, get, all, exec, transaction, withConnection) once it commits, with the table, the operation and, from run and batch, the count. A rolled-back transaction reports nothing.
  • PostgreSQL notifications between sessions: PostgresAdapter.listen(channel, handler) and notify(channel, payload). The listening connection is taken again when the server ends it.
  • changeNotificationSql(table, channel) on the dialects: on PostgreSQL a statement-level trigger that sends {"schema", "table", "operation"} on the channel for each write to the table from any session; null on SQLite.