====== Meeting Minutes: March 9, 2020 ======
=== Attendance: ===
Kevin, Andrew, Jonathan, Jianna

=== Current Updates: ===
  * Database accounts created for all members
     * <code>ssh username@server.scel-hawaii.org -p 11144</code>
     * Change default password: //salty8814pilot// 
     * Re-login through //ssh// command above
     * <code>psql -d control_tower -U control_tower_ro -c “SELECT * FROM apple ORDER BY time_received DESC LIMIT 10”</code>
  * Worked on Mid-Semester Progress Report 
  * Continued working on understanding backend API and client
  * Found [[https://github.com/auth0-blog/auth0-restful-dashboard|tutorial]] implementing API & Client together

=== Past Updates: ===
  * Tutorials
     * [[https://node-postgres.com/|Node-PostGres]]
     * [[http://zetcode.com/javascript/nodepostgres//|Node PostGres Tutorial]]
     * [[https://blog.logrocket.com/setting-up-a-restful-api-with-node-js-and-postgresql-d96d6fc892d8/|RESTful API with Node.js & Postgres-SQL]]
     * [[https://academind.com/learn/node-js/building-a-restful-api-with/planning-first-steps/|Building RESTful API]]
     * [[https://www.a2hosting.com/kb/developer-corner/postgresql/remote-postgresql-connections|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
 
=== Future Tasks: ===
  * Begin creating RESTful API
  * Complete Mid-Semester Progress Report