ksriki / basic-pen-api

Postgres-Express-Node REST Api

basic-pen-api

Postgres-Express-Node REST Api

Author

Srikant Kumar Kalaputapu

Sources

Tutorial Followed: REST API

Tech/Frameworks used

• Express.js
• Node.js
• REST API
• PostgreSQL
• Sequelize/Sequelize CLI

Dependencies

• Babel 7
  • babel-preset-env, babel-core, babel-cli
  • used to transpile code for ES6 to ES5 to work on any browser
  • .babelrc sets env
• Express.js
  • basic web framework for Node.js
• body-parser
  • body-parser
  • Node.js middleware to parse request bodies - useful for HTTP POST
  • used to be packaged with Express, now seperate
  • data in req.body
• morgan
  • morgan
  • logger middleware
• nodemon
  • nodemon
  • automatic refreshing of server based on real-time changes
• Sequelize/Sequelize CLI
  • sequelize, sequelize-cli: promise-based Node.js ORM (map code objects to database models)
  • pg: making the database connection
  • pg-hstore: for serializing and deserializing JSON into the Postgres hstore key/value pair format
  • .sequelizerc settings file to determine bootstrapped folder locations

Sequelize-cli

1. Setup .sequelizerc file
2. run sequelize init