@keyv/postgres

@keyv/postgres

PostgreSQL storage adapter for Keyv

PostgreSQL storage adapter for Keyv.

Requires Postgres 9.5 or newer for ON CONFLICT support to allow performant upserts. Why?

Install

npm install --save keyv @keyv/postgres

Usage

const Keyv = require('keyv');

const keyv = new Keyv('postgresql://user:pass@localhost:5432/dbname');
keyv.on('error', handleConnectionError);

You can specify the table option.

e.g:

const keyv = new Keyv('postgresql://user:pass@localhost:5432/dbname', { table: 'cache' });

Testing

When testing you can use our docker-compose postgresql instance by having docker installed and running. This will start a postgres server, run the tests, and stop the server:

npm run test:db

To run each step manually do the following to start the server, and run the tests:

npm run test:postgres:start
npm run test
npm run test:postgres:stop

License

MIT © Jared Wray