ServerScope

star schema
app screenshots

Inspiration

We came up with the idea from experience with server stability issues, and by trying to think of a project that would really take advantage of a well-handled database.

What it does

ServerScope gathers connection information from users, and stores it in a TiDB cluster. We store all kinds of data so that we can make personalized server recommendations whenever the user needs them. We use location and time based weighting to ensure our recommendations are accurate to wherever and whenever the user is judging from.

How we built it

We built ServerScope in Python using mySQL to connect to a TiDB cluster. We used github for version control.

Challenges we ran into

Gathering the connection information turned out to be a bit more tricky than we anticipated. We wanted to run ServerScope out of a webpage, but we learned that CORE web restrictions would prevent that sort of thing. Rather than trying to find a workaround, we decided to build it as a client instead. We also used up all the request units on one of our TiDB clusters, which was not anticipated. Luckily, TiDB was generous enough to provide us with five of them, so it wasn't a major issue.

Accomplishments that we're proud of

We're proud to have built something that people might actually use! This was also something of a family project, so I was proud of how well we were able to work together.

What we learned

We learned a lot about web protocols, SQL databases, and graphical interfaces. We also learned how to effectively divide our efforts and work as a team.

What's next for ServerScope

We want to integrate more data from the actual video game to make it a more practical tool for people who use it. We are potentially looking at releasing it to the community, as a sort of test run.