Kevin, Andrew, Jonathan, Jianna

• Database accounts created for all members

  • ssh [email protected] -p 11144

  • Change default password: salty8814pilot
  • Re-login through ssh command above

  • psql -d control_tower -U control_tower_ro -c “SELECT * FROM apple ORDER BY time_received DESC LIMIT 10”

• Worked on Mid-Semester Progress Report
• Continued working on understanding backend API and client
• Found tutorial implementing API & Client together

• Tutorials
  • Node-PostGres
  • Node PostGres Tutorial
  • RESTful API with Node.js & Postgres-SQL
  • Building RESTful API
  • SSH Tunneling

• 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

• Begin creating RESTful API
• Complete Mid-Semester Progress Report

Contributing authors:

Created by kliu on 2020/03/10 02:27.