Twitter Stats Page

Summary: I'm looking to have a site built with similar functionality to: [login to view URL] The goal is to pull data from Twitter via a Ruby on Rails app and stored in a MySQL DB for a select list of Twitter users. The project should use the Twitter API and OAuth for any data and authentication needs. What I need done: - Create a RoR app that allows me to hit a page with a CRON job to pull data from Twitter. - A user table will store the basic profile information and serve as the basis for the list of users to pull statistics from. - Basic profile information includes: * id * name * screen_name * location * description * profile_image_url * url * created_at * utc_offset * verified * followers_count * friends_count * list memberships count (number of lists the user is on) - When the CRON job page is hit, it should cycle through the user table and update the information from Twitter. Additionally, a separate table should add entries each time the task is run which includes: * id * current date/time * followers_count * friends_count * list memberships count - Finally, a final table should archive all the tweets of the each user in the user table. This should only pull the updated tweets and append them to the table. The following fields should be added to the table: * created_at * id * text * source * in_reply_to_user_id * in_reply_to_screen_name - Errors in the data pulls (rate caps, user removed their profile, etc, should not crash the app, rather send an email to the admin). - Display: The app should display a list of users similar to [login to view URL] in no particular order. The user's "screen_name" in the display table should link to an individual page which displays the 20 latest tweets in the DB. Please ask any questions you have prior to submitting your quote. We are looking to work with someone on this project and potential expansions moving forward. We will do our best to respond to all questions promptly and clarify the project on the posting as needed. Please also note how long you estimate for completion of the project after award. Thank you.