DIGIT-ARC read-only archive · snapshot: July 23, 2026

DIGIT-ARC / Software / Programming

Algorithms for social networking sites?

8 posts · originally from https://geek.digit.in/community/threads/algorithms-for-social-networking-sites.172975/

gdebojyoti
gdebojyoti Original post #1
Apr 21, 2013 at 11:37 PM
I am developing a social networking site for my college and I need some algorithms for it.
For example - showing 'N' recent "posts" from "friends", displaying "posts" with "comments", showing list of online "friends", etc.

Is there any site/ blog which deals with this? It will be great if the site also contains articles on things like 'tips' and 'best practices'.
abhidev
abhidev #2
Apr 22, 2013 at 11:19 AM
You might wanna try coursera.org ....they have a course based on the algos for social networking sites
Desmond
Desmond #3
Apr 22, 2013 at 12:44 PM
Do you have some rough design about what it is that you exactly want?
Anorion
Anorion #4
Apr 22, 2013 at 1:09 PM
templates?

try webs.com
gdebojyoti
gdebojyoti #5
Apr 22, 2013 at 10:01 PM
Well, a couple of years ago, I had created a similar site. But it was just a personal project having a very few features. Tested it with a couple of friends. Things is that the algorithm for some of the parts was not very efficient, and it will use up CPU resources as the number of friends grow. In the end, it may become a nightmare!

Much of the design (the HTML part) of this new site has been done. I have also scripted features such as posting signing up, logging in, status updates, updating profiles, etc.

I am not looking for website templates. I just want to write queries for the more complex issues such that they the exert least pressure on the CPU. That's why I am looking for algos & hints which would prod me in the right direction.


abhidev said:
You might wanna try coursera.org ....they have a course based on the algos for social networking sites
Click to expand...

Tried it, but I didn't find any related course.
gdebojyoti
gdebojyoti #7
Apr 24, 2013 at 12:14 AM
Thanks. I'll have a look at it.
RBX
RBX #8
Apr 27, 2013 at 10:12 PM
You'll be at ease developing the algorithms if you focus on SQL, and implement the algorithms in from of stored procedures, for example (SQL Server).

Displaying n recent posts simply requires sorting based on timestamp, post and comments require the same concept as threads in a forum.