jw-postgres-admin

A basic PostgreSQL client middleware for node with express.

Install

Methods

| Method | Parameters | Description | | -------- | ---------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | <main> | presetCredentials (optional) : { host:string port:string user:string password:string } | the preset connection information which will be passed into client as configuration programmatically when connecting to a PostgreSQL database. See connecting with node-postgres. |

Usage

import express from "express";
import postgresAdmin from "jw-postgres-admin";

const app = express();
const port = process.env.PORT || 3000;

app.use("/postgres-admin", postgresAdmin());

app.listen(port);

Using postgres admin client

The react client is located on whatever path the middleware is set. For example from above - it is located at http://localhost:3000/postgres-admin. It uses the database connection information as an authentication, and will prompt for any required information which is not provided in the preset credentials until a successful connection is made.