title: database schema for blog platform like blogspot in relational database
body: <p>I always wondered How can design database for blog platform like blogspot.
  for example for posts what is good design for medium size blog platform:</p>
  
  <ol>
  <li>put all posts from all blogs in one table and use something like blog_id column for them.</li>
  <li>every time new blog request come create whole tables that needed in same database, and name tables like post_blogId (post_1, post_2).</li>
  <li>create separate database for each blog</li>
  </ol>
  
  <p>I think number two is better but question is a platform that has 500,000-1,000,000 blogs must have 500,000-1000,000 tables for posts and also for comments..!! does it efficient??</p>
  
  <p>what about choice number 4??:
  use solution 2 but for something like each 500(what this number should be??) blog create separate database.</p>
  
  <p>I really have no idea which one would work efficient :(.</p>