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