Meeting Minutes: March 6, 2020

Kevin, Andrew, Jonathan

• Created new issue for Kenny to create database accounts for dashboard team members
• Kenny recommends API routing for dashboard
  • Found YouTube tutorial to create REST API
    • https://academind.com/learn/node-js/building-a-restful-api-with/planning-first-steps/
  • HTTP Protocol: GET /apple, /bumblebee, /guava, /cranberry

• Discussed with Kenny on Discord
  • SCEL database not set up to accept remote connections
    • Recommended: SSH Tunneling
    • https://www.a2hosting.com/kb/developer-corner/postgresql/remote-postgresql-connections
• 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
  • Save data into a JSON file
  • 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 graph
• 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