Progres

connect returns a promise of a completed job. It takes the connection string, and a "job" callback.

The job callback takes an argument with a ProgresClient object. It has this method:

• query takes an SQL sting and optional parameters, returning a promise of the result.

The job callback must return a promise. It may not use the ProgresClient object outside the promise chain, since the database connection is released automatically when the job's returned promise resolves.

Basic example:

progres.connect(conString, function (client) {

	return client
		.query(SQL);

}).done();

An example Express route:

var connectionString =
	'postgres://user:password@localhost/database';

var posts = sql.define({
	name: 'posts',
	columns: [
		"id",
		"slug",
		"content",
		"timePublished",
		"keywords"
	]
})

module.exports.allPosts = function (event, res) {

	progres
		.connect(connectionString, function (client) {

			return client
				.readAll(posts);

		}).then(function (posts) {

			res.end(JSON.stringify(posts));

		}).done(null, function (error) {

			res.send(500);
			console.error(
				'Error in allPosts:',
				error
			);
		});
}