The goal of this project is to increase the awareness of a blogging website with a regional theme, by attracting users from Facebook (and possibly in the future - other social networks).
Users of the website publish blogs in one (or many) of 7 RSS feeds (which are the possible blog subjects). The goal of this project is to create a profile box and application page for current users, that displays their recent content from all of these feeds. And also produces notification of new content in their Facebook mini-feed.
The application would be run from a third party server; so users with a blogging website account, would need to provide that information to the application. If they don't have one, we would need to go to the website to create an account.
The application would read and parse RSS feeds from the website and store them in a MySQL database, so that the feeds could be displayed in a correct time line order - even though they come from multiple feeds.
The feed URLs have a basic structure, based on username and blog subject.
The database will have tables for: