Since you've tried Mongo and Postgres, which one do you like more? Personally, I've never tried Mongo and have only used Postgres. Do you think I should give Mongo a go?
They both have their distinctive use cases if you have many relations in your database like foreign keys many to many keys etc then you are better off with postgres. But if that's not the case better off with mongo as it's querying capacity is insanely amazing with select limit aggregation pipeline and other features.
Since you've tried Mongo and Postgres, which one do you like more? Personally, I've never tried Mongo and have only used Postgres. Do you think I should give Mongo a go?
They both have their distinctive use cases if you have many relations in your database like foreign keys many to many keys etc then you are better off with postgres. But if that's not the case better off with mongo as it's querying capacity is insanely amazing with select limit aggregation pipeline and other features.
Thanks for your insight. I think I will stick with Postgres but I will make sure to try Mongo soon!
You might want to give HarperDB a go as well! It supports NoSQL and SQL including joins, so kind of a hybrid between the two.
Thanks for the suggestion. I will check HarperDB out!