Meeting Minutes: March 11, 2020

Kevin, Andrew, Jonathan, Jianna

• Started creating RESTful API
  • Created respective API and client folders
  • Created template for queries.js and index.js
• Updated queries.js by adding GET functions for respective weather boxes

• Tutorials
  • Node-PostGres
  • Node PostGres Tutorial
  • RESTful API with Node.js & Postgres-SQL
  • Building RESTful API
  • SSH Tunneling
  • https://www.techiediaries.com/react-json-fetch-rest-api-bootstrap/ (Kenny's Recommendation)

• Kenny recommends API routing for dashboard
  • HTTP Protocol: GET /apple, /bumblebee, /guava, /cranberry
  • SCEL database not set up to accept remote connections; SSH Tunneling available
• Researching ways to connect Node.js with PostgreSQL
  • Researching node-postgres, a package that contains node.js modules and functions for interfacing with a PostgreSQL database
• Approach:
  • Create RESTful API to get results from SCEL gateway
  • Link API database results with dashboard client components

• Completed Mid-Semester Progress Report

• Work and finish RESTful API