Tips on choosing the right database
I'm currently working on a social media project that involves features like comments, replies, following, followers, and posts. I'm in the process of choosing the right database for the project and wanted to reach out to seek valuable insights.
Considering the dynamic nature of social media interactions and the need for efficient data retrieval, I'm a bit torn between different database options. Do you guys have any recommendations or insights on which database might be a good fit for managing the complexities of user interactions?
I don't have that much experience in other databases. I'm only familiar with SQL.
6 Replies
Postgres
It's an answer 99% of the time
How is postgres with large amounts of data If I may ask?
I see, thanks for your input mate 😊 .
depending on scale any relational database would be appropriate
postgres is commonly recommended for that because it's free and has less silly gotchas than other options
Thanks for your insights 😊.