/pgmq-js

Primary LanguageTypeScriptMIT LicenseMIT

pgmq-js

Postgres Message Queue (PGMQ) JavaScript Client Library, supports Transaction, supports Route routing to implement the Exchange functionality of the MQ queue.

GitHub tag License ci codecov

以下所有命令行操作都在 git-bash 窗口中执行

Install global deps for development

npm i -g c8 lerna madge rollup tsx zx

Packages

Package Version
pgmq-js main-svg
@mwcp/pgmq cli-svg

Installation

npm i @waiting/pgmq-js
// or for midway.js
npm i @mwcp/pgmq

Prepare

Start a Postgres instance with the PGMQ extension installed:

docker run -d --name postgres -e POSTGRES_PASSWORD=postgres -p 5432:5432 quay.io/tembo/pg16-pgmq:latest

Create the pgmq extension

psql -h $POSTGRES_HOST -p $POSTGRES_PORT -U$POSTGRES_USER -d $POSTGRES_DB -bq \
  -f packages/pgmq-js/database/default/ddl/extension.sql \
  -f packages/pgmq-js/database/default/ddl/tb_queue_meta.sql \
  -f packages/pgmq-js/database/default/ddl/tb_route.sql 

Supported API

License

MIT

Languages