@jsreport/jsreport-postgres-store NPM

@jsreport/jsreport-postgres-store

jsreport template store extension allowing to persist data in PostgreSQL database

Installation

npm install @jsreport/jsreport-postgres-store

Then alter jsreport configuration

{
	"store": {
		"provider": "postgres"
	},
	"extensions": {
		"postgres-store": {
			"host": "localhost",
			"port": 5433,
			"database": "jsreport",
			"user": "postgres",
			"password": "password",
			// optionaly enable ssl
			"ssl": true,
			// optionally customize ssl
			// https://node-postgres.com/features/ssl
			"ssl": { ... }
		}
	}
}

After jsreport initializes you should see tables like jsreport.TemplateType and other in jsreport database.

Schema changes

If you do changes to the database schema by enabling additional extensions you need to drop the affected tables and let jsreport to reinitialize them.