I am creating a website, and this is the database I have designed. I have created this design in such a way that it scales well in the long term. The following features are supported by my database:
- Users can create stories.
- Users can bookmark (save) their favorite stories.
- Users can select a list of stories to create storybooks.
- Users can delete stories.
- Users can edit stories.
- Users can favorite their preferred theme rooms.
- Users can like and dislike other users’ stories.
I haven’t decided the database for my design but I am considering MongoDB and PostgreSQL at the moment. Which database will be most fit for my design?
I have posted my database design in the image. I was wondering if the design is sufficient and scalable. If there are any improvements, please let me know.