cs373-starhub

Transcript

1. Intergalactic DB
2. Meet The team Rachel Wong - API/Rackspace Admin Noelle Hall - Front End/Database Guillermo Terrazas - Full Stack Tipparat Umrod - Backend/Database Erin Pennington - Front End
3. About The Intergalactic db is a simple Star Wars database that makes it easier for the average Star Wars fan to look up information about characters, planets, and species in the Star Wars Universe.
4. API Characters Species Planets
5. UML diagram
6. Tools Backend: Python 3.4.0 Flask SQLAlchemy 1.0.6 postgresql 9.3.9 Frontend: Bootstrap jinja 2 jQuery Server: Rackspace nginx/1.4.6 gunicorn 19.3.0 Supervisor 3.0b2 Others: Apiary yUML Beautiful Soup
7. Let’s take a tour... intergalacticdb.me
8. League of Downing Critique • What did they do well? ◦ couldn’t stop watching their splash video ◦ UI was very attractive, especially the tables were pretty ◦ filter system on tables, filters as user types ◦ API was simple to use ◦ very nice custom logo • What did we learn from their website? ◦ how the players, champions, and items of League of Legends are connected ◦ usefulness of Apiary for conveying how to perform API request in different languages
9. League of Downing Critique • What can they do better? ◦ from each instance page, there’s links to other models, but those don’t show links back - e.g. players contain links to champions they play as, but champions don’t have links to players who use them ◦ Once the animation ended, the video continued without sound. ◦ mute button on splash video for those who don’t want audio ◦ on mobile, splash page logo overflows screen (too large) • What puzzles us about their website? ◦ API appears to be lacking documentation for retrieving lists of all champions, players, or items ◦ search is not entirely extensive - e.g. searching “passive” gives no results, searching “magic resist” doesn’t list items which enhance “Magic Resist” under the AND category (Null-Magic Mantle)
10. self critique • What did we do well? ◦ Web Design/ Splash page • What did we learn? ◦ the process of setting up a Rackspace server to host our site ◦ Pretty much every tool needed to develop this application • What can we do better? ◦ Mobile Responsiveness (horizontal scrolling on tables, nav bar) ◦ make image size on instance pages consistent without stretching ◦ show titles of pages in search results and improve the highlighting of search terms in context (showing highlights / contexts of multiple terms) • What puzzles us? ◦ Setting up postgresql database ◦ Rackspace/nginx/gunicorn configuration