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
https://www.a2hosting.com/kb/developer-corner/postgresql/remote-postgresql-connections
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:
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/04 21:58.