deepstream.io-storage-postgres
Postgres Database connector for deepstream.io
This connector can be installed via the deepstream command line interface via
deepstream install storage postgres
and can be configured in the plugins storage
section of deepstreams config.yml. Supported options are
plugins: storage: name: postgres options: user: some-user database: some-database password: some-password host: localhost port: 5432 #postgres default post schema: ds #schema defaults to ds. Will be created if it doesn't exist table: defaultName: default # default table name defaults to default prefix: ds_ # table prefix defaults to empty string, so no prefix max: 10 #concurrent connections idleTimeoutMillis: 30000 #timeout after which connection will be cut writeInterval: 200 #amout of milliseconds during which writes will be useJsonb: false #store values as searchable binary JSON (slower) buffered notifications: CREATE_TABLE: false #Get notified when tables are created DESTROY_TABLE: false #Get notified when tables are dropped INSERT: false # Get notified when records are created UPDATE: false # Get notified when records are updated DELETE: false # Get notified when records are deleted
This connector can also be used as a standalone component from node.js to connect to postgres' notification mechanism. To do this, install the connector via
npm install deepstream.io-storage-postgres
and instantiate it directly
const PostgresConnector = ;const settings = user: processenvPG_USER database: processenvPG_DB password: processenvPG_PASSWORD host: processenvPG_HOST port: const connector = settings connector