what?
------
why?
------
you can use these files for beginning a social n/w type projects in PHP/MySQL development environment.
when i was doing social network project, i searched here & there for database design of a social network, but what i found in the internet were not useful. they provided a introductory sketch about social network database structure but but as i had a limited time frame for my project, those materials were not useful. i have analyzed most of the basic requirements for a social network database structure, and sharing this with you so that it would save some of your time to start out your project.
the database is not completely normalized yet but you can edit it as per your needs. don't waste to much time on what fields should i use for profile or for a status representation, these entity sets in the design will suffice in most of the cases. You can add entities for pictures, video, music sharing or anything you like. Just use the workbench design file.
Here are few books i'd recommend if you are willing to dive deep into MySQL and database designs
1. Beginning MySQL Database Design and Optimization: From Novice to Professional
or
2. High Performance MySQL: Optimization, Backups, and Replication
files included
-----------------
following files are included
sns.7.0-.mwb - MySql WorkBench Design
sns.7.0.png - exported PNG from MySql workbench
sns7.0.sql - exported SQL from MySql Workbench
sns.yml - Doctrine Generated schema in YAML
you can use the MySQL WorkBench Designer available Open Source at http://wb.mysql.com & begin with the mwb file,
change it for your need, export to sql & use it for your project.
Download MySQL Social Network Database Design – Sample
Update 11/14/2011:
Many readers have requested how the project ended up in look.
So, here goes the slide we presented to Tribhuvan University (with formal details cut out).
Thanks for reading this post.
TimiHami a Nepali Social Network
------
| sample database for a social network project – a mysql database schema Database Engine: InnoDB (edit the mwb file if you need to change it to MyISAM or any other.) the aspects of a social network i tried to cover in this database: - user profile - friends - friends list - status updates - thumbs up/down status (these can be easily ported to other entities) - bookmark saving - rss/atom feeds saving - notifications - chat - blog, site level not user level  - privacy |  |
------
you can use these files for beginning a social n/w type projects in PHP/MySQL development environment.
when i was doing social network project, i searched here & there for database design of a social network, but what i found in the internet were not useful. they provided a introductory sketch about social network database structure but but as i had a limited time frame for my project, those materials were not useful. i have analyzed most of the basic requirements for a social network database structure, and sharing this with you so that it would save some of your time to start out your project.
the database is not completely normalized yet but you can edit it as per your needs. don't waste to much time on what fields should i use for profile or for a status representation, these entity sets in the design will suffice in most of the cases. You can add entities for pictures, video, music sharing or anything you like. Just use the workbench design file. Here are few books i'd recommend if you are willing to dive deep into MySQL and database designs
1. Beginning MySQL Database Design and Optimization: From Novice to Professional
or
2. High Performance MySQL: Optimization, Backups, and Replication
files included
-----------------
following files are included
sns.7.0-.mwb - MySql WorkBench Design
sns.7.0.png - exported PNG from MySql workbench
sns7.0.sql - exported SQL from MySql Workbench
sns.yml - Doctrine Generated schema in YAML
you can use the MySQL WorkBench Designer available Open Source at http://wb.mysql.com & begin with the mwb file,
change it for your need, export to sql & use it for your project.
Download MySQL Social Network Database Design – Sample
Update 11/14/2011:
Many readers have requested how the project ended up in look.
So, here goes the slide we presented to Tribhuvan University (with formal details cut out).
Thanks for reading this post.
TimiHami a Nepali Social Network
Buy IG Followers,buy instagram followers cheap,buy instagram
ReplyDeletefollowers cheap,buy real instagram followers,buy facebook likes,buy instagram
followers and likes
if you are looking
Buy Instagram Followersfor the best SMM panel online? Want to buy Instagram followers? Check
out our website and learn more about how you can increase your followers today
We add new presentation designs bi-weekly! This month, we added a variety of widescreen
ReplyDeletePowerPoint templates focused on 2021, business concepts and abstract animated designs.
business presentation templates
ReplyDeleteFr. George Rutler was born in 1945 and raised an Episcopalian in New Jersey and New York. He served as an Episcopal priest for nine years and was the youngest Episcopal rector in the country when he headed the Church of the Good Shepherd in Rosemont, Pennsylvania.
father george rutler
This comment has been removed by the author.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteAre you looking for a good marketing method that is SMM Panel. Just try it and examine the result.
ReplyDeletewe can't think of a day without social media.
ReplyDeleteeveryone wants to be famous. As well as they need more followers.
If you need so try Trusted SMM Panel.
It's an ideal solution for businesses seeking effective social media growth in Nepal. SMM Panel Nepal stands out as a valuable resource, connecting businesses with the local audience efficiently. Streamline your digital efforts with this platform.
ReplyDeleteFor readers who are passionate about books and literature, reaper.scans is an engrossing online destination.The website offers informative reviews, author interviews, and thought-provoking analyses that go beyond simple book suggestions and enhance users' understanding of the written word.
ReplyDeleteThe best smm panel will depend on several variables, including cost, dependability, quality of service, and customer service. Nonetheless, several SMM panels stick out from the plethora of choices because of their extensive selection and intuitive user interfaces.
ReplyDelete