Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
ust:meeting_minutes_mar._2 [2020/03/03 02:48] jtu created |
ust:meeting_minutes_mar._2 [2021/09/19 21:59] (current) |
||
|---|---|---|---|
| Line 9: | Line 9: | ||
| * https://node-postgres.com/ | * https://node-postgres.com/ | ||
| * http://zetcode.com/javascript/nodepostgres/ | * http://zetcode.com/javascript/nodepostgres/ | ||
| + | * https://blog.logrocket.com/setting-up-a-restful-api-with-node-js-and-postgresql-d96d6fc892d8/ | ||
| * Potential Method: | * Potential Method: | ||
| * Using SQL statement "SELECT * FROM apple ORDER BY time_received DESC LIMIT 10;" to pull data from database | * Using SQL statement "SELECT * FROM apple ORDER BY time_received DESC LIMIT 10;" to pull data from database | ||
| Line 19: | Line 20: | ||
| * How will we refresh/update JSON file? | * How will we refresh/update JSON file? | ||
| * Call SQL statement every time? Auto refresh? | * Call SQL statement every time? Auto refresh? | ||
| - | * How do we link everything together? | + | * How to save database data after SQL statement into a JSON file? |
| + | * How to connect and do commands on database? | ||
| === Future Tasks: === | === Future Tasks: === | ||
| - | * Research more on node-postgres library | + | * Research more on node-postgres library |
| - | * Start trying to implement everything | + | * Start trying to implement everything |