db-watch
v0.0.8
Published
Database replication, inlcuding Postgres triggers and monitoring with notify listeners
Downloads
13
Readme
db-watch
Various implementation of database replication, including creating Postgres triggers and monitoring with notify listeners.
Example
// Add to migrations
for (const query of setupQueries) await knex.raw(query)
// After CREATE TABLE users
await knex.raw(createNotifyRowFunction('users', 'updated', "'username', orig.username"))
await knex.raw(createNotifyTrigger('users', 'updated'))
// Maximum PostgreSQL NOTIFY payload is 8192 bytes.
await knex.raw(createNotifyRowFieldsFunction('event', 'updated', "'date', orig.date, 'guid', orig.guid))
await knex.raw(createNotifyTrigger('event', 'updated'))