Database design in blogging systems
- by Peter
As a learning exercise I'm trying to put myself a blogging system.
The goal is to code something that will let me create multiple blogs, like blogger.com or wordpress.com, but much simplified.
I would like to ask you, what do you think is best database design for this type of script.
Is it better to have one big table, containing posts from all blogs of all users (like friendfeed) or would it be better to create separate table for each blog's posts?
Big thanks in advance for your help,
Peter.