This is a Rails application that uses MySQL, Sequel, and AngularJS to calculate and display:

1. Number of page views per URL, grouped by day, for the past 5 days

2. Top 5 referrers for the top 10 URLs, grouped by day, for the past 5 days

To run this application, you will need Rails and MySQL installed.

$ bundle install
$ rake db:reset
$ rails server

Visit http://localhost:3000/top_urls to see the page views per URL, grouped by day, for the past 5 days.

Visit http://localhost:3000/top_referrers to see the top 5 referrers for the top 10 URLs, grouped by day, for the past 5 days.

• I chose to add a 'date_created_at' column in order to more effectively use indexing when filtering by dates. You can't apply a function like date() to a datetime within a where clause and still use a datetime index.
• I used the AngularJS $HTTP service to get the JSON at http://localhost:3000/get_top_urls so I could use the ng-repeat directive to display the data at http://localhost:3000/top_urls.

• Optimize queries for large datasets
  • Work on reducing the number of SQL queries made and let the database do more of the filtering.
• Decrease page loading time
  • While the SQL query for Top URLs takes less than a second, generating the JSON is taking much longer.
• Add more CSS styling