Meeting Minutes: March 9, 2020

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

• Kenny recommends API routing for dashboard
  • Found YouTube tutorial to create REST API
  • HTTP Protocol: GET /apple, /bumblebee, /guava, /cranberry
• Discussed with Kenny on Discord
  • SCEL database not set up to accept remote connections
    • Recommended: SSH Tunneling
• 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
    • Relevant Links:
      • https://node-postgres.com/
      • http://zetcode.com/javascript/nodepostgres/
      • https://blog.logrocket.com/setting-up-a-restful-api-with-node-js-and-postgresql-d96d6fc892d8/
• Potential Method:
  • Using SQL statement “SELECT * FROM apple ORDER BY time_received DESC LIMIT 10;” to pull data from database
  • Use calls and functions to gather necessary data from JSON file
    • E.g. Gather average of 100 temperature data points from apple
    • E.g. Gather most recent 100 temperature data points from apple to graph
  • With those selected data points, display on the HTML
• Questions to think about:
  • How will we refresh/update JSON file?
    • Call SQL statement every time? Auto-refresh?
  • How to save database data after SQL statement into a JSON file?
  • How to connect and do commands on the database?

• Research more on node-postgres library
• Start trying to implement everything