Kevin, Andrew, Jonathan

• 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?

• Research more on node-postgres library
• Start trying to implement everything

Contributing authors:

Created by jtu on 2020/03/03 02:48.