js-postgres

An augmented Postgresql database wrapper.

Installation

Run npm i @randlabs/js-postgres inside your project's root directory.

Quick usage

import * as Database from "@randlabs/js-postgres";

// Initialize database manager
let manager = new Database.Manager({
	host: "127.0.0.1",
	port: 5432,
	user: "my-user",
	password: "my-password",
	database: "my-database",
	usePool: true,
	maxConnections: 100
});

// Get a connection
const client = await manager.getClient();

// Execute a query within a try/catch block in order to return the connection to the pool after using it
try {
	// For documentation about queries, see node-postgres documentation at https://node-postgres.com/
	const result = await client.query(
		"SELECT value FROM config WHERE key = $1",
		[ key ]
	);
	...
	client.release();
}
catch (err) {
	client.release(err);
	throw err; //re-throw
}

// Or use our wrapper to handle errors automatically
const result = await manager.withClient((client: Database.Client, customParam: any): Promise<any> => {
	const result = await client.query(
		"SELECT value FROM config WHERE key = $1",
		[ customParam.key ]
	);
	return result;
}, {
	key: "test-key"
});

// Also we provide a transaction wrapper
const result = await manager.withClient((client: Database.Client): Promise<any> => {
	// withTx will start a transaction and commit/rollback it, depending if an error is thrown or not
	await client.withTx((c: Database.Client) => {
		await c.query("INSERT INTO ....");
	});
});

License

Apache 2.0