CS373 Spring 2021: William Wang

What did you do this week?

This week, I worked on getting my group’s SQL database set up. I first had to create a server in AWS, then I worked with my group to define the schemas for each table. Once we knew exactly what data we needed, I scraped the relevant information from various APIs and inserted it into our database. Now, all the data is consistent and linked in the right ways for the frontend to consume.

What’s in your way?

We’re having a problem where our database access works for about a day when deployed on AWS, then starts failing to return any information. It’s really frustrating because we can’t seem to reproduce it locally (even with Docker), and it takes so long to see if our fixes actually worked. I’m going to try to print some logging messages and return them to the frontend so we can see what’s going on.

What will you do next week?

My first priority is to fix the above issue. I also need to try optimizing our SQL queries, as some of them take a rather long time to execute. I think it has to do with our lazy loading scheme; if I can cache or eagerly compute the results from table joins somehow, it should improve somewhat.

What did you think of the Interface Segregation Principle?