Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
ust:meeting_minutes_mar._9 [2020/03/10 02:27] kliu created |
ust:meeting_minutes_mar._9 [2021/09/19 21:59] (current) |
||
---|---|---|---|
Line 10: | Line 10: | ||
* <code>psql -d control_tower -U control_tower_ro -c “SELECT * FROM apple ORDER BY time_received DESC LIMIT 10”</code> | * <code>psql -d control_tower -U control_tower_ro -c “SELECT * FROM apple ORDER BY time_received DESC LIMIT 10”</code> | ||
* Worked on Mid-Semester Progress Report | * Worked on Mid-Semester Progress Report | ||
+ | * Continued working on understanding backend API and client | ||
+ | * Found [[https://github.com/auth0-blog/auth0-restful-dashboard|tutorial]] implementing API & Client together | ||
=== Past Updates: === | === Past Updates: === | ||
- | * Created new issue for Kenny to create database accounts for dashboard team members | + | * Tutorials |
+ | * [[https://node-postgres.com/|Node-PostGres]] | ||
+ | * [[http://zetcode.com/javascript/nodepostgres//|Node PostGres Tutorial]] | ||
+ | * [[https://blog.logrocket.com/setting-up-a-restful-api-with-node-js-and-postgresql-d96d6fc892d8/|RESTful API with Node.js & Postgres-SQL]] | ||
+ | * [[https://academind.com/learn/node-js/building-a-restful-api-with/planning-first-steps/|Building RESTful API]] | ||
+ | * [[https://www.a2hosting.com/kb/developer-corner/postgresql/remote-postgresql-connections|SSH Tunneling]] | ||
* Kenny recommends API routing for dashboard | * Kenny recommends API routing for dashboard | ||
- | * Found YouTube tutorial to [[https://academind.com/learn/node-js/building-a-restful-api-with/planning-first-steps/|create REST API]] | ||
* HTTP Protocol: GET /apple, /bumblebee, /guava, /cranberry | * HTTP Protocol: GET /apple, /bumblebee, /guava, /cranberry | ||
- | * Discussed with Kenny on Discord | + | * SCEL database not set up to accept remote connections; SSH Tunneling available |
- | * SCEL database not set up to accept remote connections | + | |
- | * Recommended: [[https://www.a2hosting.com/kb/developer-corner/postgresql/remote-postgresql-connections|SSH Tunneling]] | + | |
* Researching ways to connect Node.js with PostgreSQL | * 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 | * Researching node-postgres, a package that contains node.js modules and functions for interfacing with a PostgreSQL database | ||
- | * Relevant Links: | + | * Approach: |
- | * https://node-postgres.com/ | + | * Create RESTful API to get results from SCEL gateway |
- | * http://zetcode.com/javascript/nodepostgres/ | + | * Link API database results with dashboard client components |
- | * 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 | + | |
- | * 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 HTML | + | |
- | * 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: === | === Future Tasks: === | ||
- | * Research more on node-postgres library | + | * Begin creating RESTful API |
- | * Start trying to implement everything | + | * Complete Mid-Semester Progress Report |