Ask HN: NoSQL or SQL database for a social media app?
I'm building a social media mobile app (and potentially available for web).
As any social media app, there are a lots of relation data queries involve. For example, user follow authors, author create posts, post belong to topics.
Would it be much better to use SQL over NoSQL database in this case? Or maybe a mix of both?
Considering ease of development, the performance, and number of request trips. Such as checking if: - The current user is following an author (in a post page or author's profile page) - The current user has liked or bookmarked a post (in a post page)
Also, there are a number of querying recommendations for posts and authors for a user behind the sense.
Please share your advice if you have experienced in both NoSQL and SQL databases with similar project. Any database recommendation in particular?
Many thanks!