Postgres GraphQL Data Service

Objective of building this is to deploy-and-forget.

Setup

• Download Zip/Clone
• run command npm i/install
• Configure database connection in .env file as per instruction in the Configuration section
• run command npm start

Configuration

Change the configuration to connect database in .env file

Key	Value	Comments
PORT	80	Port can be changed
PG_DB_HOST	127.0.0.1	Database host can be changed
PG_DB_PORT	5432	Database port can be changed
PG_DB_USER	postgres	Database Username can be changed
PG_DB_PASS	postgres123	Database Password can be changed
PG_DB_NAME	postgres	Database Name can be changed

Queries

1. tables
2. columns
3. foreignkeys
4. select
5. distinct
6. avg
7. count
8. max
9. min
10. sum

Mutation

1. insert
2. update
3. delete
4. simple - database transaction

Issues Fixed

1. SQL Injection