Full Stack Developer at Infynno Solutions·
Needs advice
on
PostgreSQLPostgreSQL
and
MongoDBMongoDB

I want to store the data retrieved from multiple APIs and perform some analytics on it. The data stored in DB will never/hardly change. First, I thought it would be better to retrieve the data and create table columns for them, but some data might have different columns than others. So I thought about storing the JSON response from API directly to the table and use it. So which database will be the better choice, PostgreSQL or MongoDB.

READ LESS
7 upvotes·84.3K views
Replies (6)
Recommends
MongoDB

MongoDB should be better for unstructured/less structured data.

READ MORE
1 upvote·72.7K views
Sr. Backend Engineer at Grappus·
Recommends
MongoDB

Hey Krunal, your requirement sounds pretty clear and specific to what you want to do with that data. My recommendation to you, would be to use MongoDB. Since schema-less IO is faster in MongoDB, your general speed of reading / writing from and to the database would be quick. Additionally, the aggregate framework is very powerful with large data so that is also something that you can use in computing your analytics.

READ MORE
8 upvotes·76.6K views
View all (6)
Avatar of BigPackie