CS329E Presentation

Transcript

1. Group8books.me
2. Group members
3. Juan Gomez -Mechanical Engineering ‘18 -22 Commits -8 Issues -3 Unit Test
4. Zach Quinlan -Computer Science ‘19 -32 Commits -6 Issues
5. Daniel Smarda -Mechanical Engineering ‘18 -17 Commits -10 Issues
6. Cameron Walsh -Math & French ‘19 -41 Commits -3 Issues
7. Robert Rodriguez -Physics ‘18 -11 Commits -6 Issues
8. Design
10. Database Models
11. Tools
12. Front End Development • HTML/CSS for design • Bootstrap for uniformity, advanced features • JavaScript for functionality (sorting, searching)
13. Back End Development • Flask (Python) ◦ Advantages: fast prototyping ◦ Disadvantage: Scalability for future, long-term management ◦ In future, could use template extending for more advanced aesthetics ◦ Bug: CSS static files not updating ▪ Fixed with open-source code from another user posted to Github
14. Database Management • PostgreSQL ◦ Advantages: Stricter data integrity requirements, previous knowledge, SQLAlchemy compatibility ◦ Disadvantage: Still beta on GCP ◦ Challenge: Correctly establishing proxy
15. Hosting
16. Google Cloud Platform • Proper rights/authorization • Initial Deployment • SQL Instance • Positives ◦ Ease to launch apps ◦ Compatibility • Negatives ◦ Long deployment time ◦ Tough to correct errors ◦ Little online help
17. Critiques
18. Self Critique • What did we do well? ◦ Fully functional, easy to navigate, memorable URL • What did we learn? ◦ Full stack web development, GCP, Flask, SQLAlchemy
19. Self Critique • What can we do better? ◦ Update aesthetics, speed up the sorting • What puzzles us? ◦ Running unit tests from our website, accessing the GCP database remotely
20. Group 1 Critique • What did they do well? ◦ Good aesthetics, table search function and sorting work very well, nice splash page and navigation • What did we learn from their website? ◦ Good website layout design
21. Group 1 Critique • What can they do better? ◦ Switch the author column with the Google ID column in the Books table, “none” values in tables link to a not found page • What puzzles us? ◦ Website URL and title don’t match
22. Demo http://group8books.me/