Я создаю веб-приложение, подобное Pinterest, где пользователи могут создавать доски, сохранять изображения (булавки) и упорядочивать их с помощью тегов. Each pin has metadata such as title, description, image URL, author, and possibly many comments and likes.
The data model includes relationships between users, boards, and pins, but the structure of metadata and tags may evolve over time. I'm deciding between PostgreSQL and MongoDB for storing this data.
PostgreSQL would provide strong relational integrity and powerful querying for joins between users, boards, and pins. However, MongoDB might offer more flexibility for storing variable metadata and nested documents (comments, tags, etc.).
For a Pinterest-like workload (many reads, tagging, search, user interactions), which database is generally a better choice and why? Существуют ли соображения масштабируемости или проектирования схемы, которые делают один вариант более подходящим, чем другой?
