====== Meeting Minutes: March 6, 2020 ======
=== Attendance: ===
Kevin, Andrew, Jonathan

=== Current Updates: ===
  * 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

=== Past Updates: ===
  * 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? 
 
=== Future Tasks: ===
  * Research more on node-postgres library
  * Start trying to implement everything