GSoC/GCI Archive
Google Code-in 2011 FreeBSD

Implement FreeBSD community portal (FCP2) - SQL tables

completed by: Nagato Yuki

mentors: Wojciech A. Koszek, Jakub Klama

Description of a task

This is a research task. It may or may not be deployed in production systems. No effort has been made to coordinate this task with the FreeBSD Core Team.

The WWW portal will fetch the basic user information from other social/community sites (explained in FCP1 tasks) and will have to store them in SQL database.

Your task is to design SQL tables so that storing basic user information is possible on the portal's side. In other words: we'd like to be able to use create user's profile with name/surname fetched from LinkedIn. By basic user information we understand whatever user information is exported from Facebook/LinkedIn, for example. You must check by yourself (or by coordinating it with FCP1 participant) which information is that. Example of basic user information include: name, surname, age, country of residence, interests etc..

We require as little confidential data as possible. It is more likely to get users accept potential 'freebsd_gcin' app if they require only basic credentials.

After fetching the information, we perform INSERTions to the SQL database.

1 database and 1 table created in it are fine.

Technology choice is up to you, but Python/PHP is preferred (Facebook API is in Python/PHP at least). No framework is required to accomplish the task; however, frameworks aren't prohibited. In case of not using any framework, please follow the MVC design principles.