The Postgres over REST service provides a simple web api to query Postgres data warehouses. This project includes the following:
- A node server that provides the REST api to query your Postgres instance. Refer to its README file in the local-server folder for directions on how to start the node server.
- A script to start a Postgres docker container and upload test data. The docker-pg-server folder includes a README file with additional directions.
This service does not attempt to provide authentication or authorization functionality. Please use a security product such as Cognito to front this api and provide such services.
Using ChartFactor Studio, you can use the Postgres/Redshift provider and URL http://127.0.0.1:3000 to visualize your data files.