peegee

Postgres + json queries + transaction support with promises

Installation

• Requires es6.

1. Create .env file

• Setup database connection variables.
• I recommend heroku free tier.

2. Create and seed database
migrate up

3. Run test
npm test

resources

• Sample API uses Biblical places
• node-pg
• pg-promise
• MoSQL - JSON to SQL
• Migrate
• Postgres Naming conventions
• Alternative
• How To Create, Remove, & Manage Tables in PostgreSQL on a Cloud Server
• Microservices
• Free Postgres cloud service