在网站中为不同的页面设置单独的数据库是一种好的做法吗？

Question

I have a website xyz.com that is going to be launched in an online server. I have three pages x, y and z (suppose x is for image gallery, y is for video gallery, and z is for another gallery). I need to have a comment section for each of the pages, and user input is going to be stored in database. There need not be any relation between the comments in different pages, or in another words, comment from one page doesn't have to relate with the comments in another pages. I want to deal them separately.

Now my question is:

Should I use one database and create just three different tables for each pages or should I create three completely different database each of them having one table? Which one is good practice?

Answer 1

You do not need to create the different databases and why would you?

1. Create single database

2. Create 2 tables "galleries" and "comments"

   galleries (id|title|name|type|date etc....)
   

Gallery type can be "image" or "video" or etc...

1. when you load data for image(s) page do

   select * from galleries where type='image'
   

and when for video

select * from galleries where type='video'

so on...

For comments:

create table

comments (id|comment_text|gallery_type...)

where gallery_type is the foreign key

If your gallery types are lots you can always create a sperate table for gallery_types and give reference accordingly.