Meeting Minutes: March 4, 2020
Attendance:
Kevin, Andrew, Jonathan, Jianna
Current Updates:
- Discussed with Kenny on Discord
- SCEL database not set up to accept remote connections
- Recommended: SSH Tunneling
- Continued going over tutorials and discussed necessary steps for progression
- Met with Dr. Kuh via Skype to talk about progress
Past Updates:
- 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/04 21:58.