Differences
This shows you the differences between two versions of the page.
ust:meeting_minutes_mar._9 [2020/03/10 02:28] kliu |
ust:meeting_minutes_mar._9 [2021/09/19 21:59] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Meeting Minutes: March 9, 2020 ====== | ||
- | === Attendance: === | ||
- | Kevin, Andrew, Jonathan, Jianna | ||
- | |||
- | === Current Updates: === | ||
- | * Database accounts created for all members | ||
- | * <code>ssh [email protected] -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 | ||
- | |||
- | === Past Updates: === | ||
- | * Kenny recommends API routing for dashboard | ||
- | * Found YouTube tutorial to [[https://academind.com/learn/node-js/building-a-restful-api-with/planning-first-steps/|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: [[https://www.a2hosting.com/kb/developer-corner/postgresql/remote-postgresql-connections|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? | ||
- | |||
- | === Future Tasks: === | ||
- | * Research more on node-postgres library | ||
- | * Start trying to implement everything | ||