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
Authors
Contributing authors:
kliu
Created by
kliu
on 2020/03/06 20:56.