Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2008
    Posts
    117

    Relationship process with websites.

    Hi,
    There are many social networking websites like facebook, orkut, twitter. These websites handling many users at a time. All the queries are processed faster. Which database do they use for building it?
    Also they handles for login,user creation,scarps, photos etc. all these must be stored in a database.
    How they create relatioships with each table? Will they only link each and every table with ID.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by bharanidharanit View Post
    Which database do they use for building it?
    mostly mysql
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2008
    Posts
    117
    With all those applications, it has a photo application. How are they saving images? Are they saving in a directory or in a database? Which is the best option

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by bharanidharanit View Post
    Are they saving in a directory or in a database?
    filesystem

    Quote Originally Posted by bharanidharanit View Post
    Which is the best option
    filesystem
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Nov 2008
    Posts
    117
    Quote Originally Posted by r937 View Post
    filesystem

    filesystem
    do you mean filesystem as directory?

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by bharanidharanit View Post
    do you mean filesystem as directory?
    directory, folder, hard drive... yeah call it whatever you like, it's outside of the database
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Jan 2010
    Location
    San Francisco, CA
    Posts
    6
    You could certainly keep track of the files in the filesystem with the database, but you'd store all the photos and other media OUTSIDE the DB.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •