====== Meeting Minutes: March 2, 2020 ====== === Attendance: === Kevin, Andrew, Jonathan === 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 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 database? === Future Tasks: === * Research more on node-postgres library * Start trying to implement everything