I'm creating a new site which will have many objects, such as posts(text/photo/video), products, photo galleries, etc.
Currently my design is to put all of the objects into a
posts table, but I'm starting to wonder if that might be too restrictive.
I also have a
post_tag pivot table...
Would I be better off creating a
posts table, and a
products table, and a
videos table, etc? I know the
posts table could get large, but I think it would also be easier to maintain. OTOH I could break each object table into a separate database if the need ever arose, which (I think?) would help with scalability, which would also mean I'd probably need more pivot tables:
product_tag, etc. for each object table?
I'm curious: how does Tumblr do this for each of their post types...?
Any thoughts would be greatly appreciated!