Implement FreeBSD community portal (FCP2) - SQL tables FreeBSD
Status: Closed Time to complete: 240 hrs Mentors: Wojciech A. Koszek, Jakub Klama Tags: Python, community, portal, FreeBSD, PHP, Ruby

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.

Uploaded Work
File name/URL File size Date submitted n/a December 04 2011 20:37 UTC
Nagato Yuki on December 4 2011 19:15 UTC Task Claimed

I would like to work on this task.

Wojciech A. Koszek on December 4 2011 19:23 UTC Task Assigned

This task has been assigned to Nagato Yuki. You have 240 hours to complete this task, good luck!

Nagato Yuki on December 4 2011 20:38 UTC Ready for review

The work on this task is ready to be reviewed.

Jakub Klama on December 5 2011 00:26 UTC Task Closed

Congratulations, this task has been completed successfully.