0
votes
0answers
15 views

Storing not very volatile information in database with cache or mongodb

For a new project I'm working on right now I was doubting on which database/storage system to use for specific information which does not change that often. We have for instance some ...
0
votes
0answers
36 views

When enable authenticating in MongoDB, how to use mongo_fdw?

I test mongo_fdw these days, It's ok when mongodb disable the auth authenticate, but if the mongo enable the auth authenticate, should we create a mapping user for the foreign table? what shoud we ...
0
votes
1answer
788 views

Best Approach to storing chat history?

I'm building a chat application (Yes, another one :P) and am really curious about the best way to store a chat's history(String username, String Message, Time, and possibly string channel depending on ...
6
votes
1answer
5k views

MongoDB performance vs. PostgreSQL with 5.5 million rows / documents

Can someone help me compare these queries and explain why the PostgreSQL query executes in just under 2000ms and the MongoDB aggregate query takes almost 9000ms and sometimes as high as 130K ms? ...
-1
votes
2answers
150 views

What database should I use to create a webmail service like gmail? [closed]

I planned to use python for my frontend with django framework. But for backend, I have no idea which database I should use. Since it involves plenty of reads and writes can someone point me in the ...
0
votes
1answer
69 views

mongodb on-premise: will it work?

We are planning to package MongoDB-PostgreSQL hybrid solution in our application that will be deployed on customer site on-premise. It will be packaged as a software virtual appliance. Our reason for ...
10
votes
1answer
3k views

Using MongoDB and PostgreSQL together

My current project is essentially a run of the mill document management system. That said, there are some wrinkles (surprise, surprise). While some of the wrinkles are fairly specific to the ...
2
votes
1answer
176 views

Which database to use? [closed]

Hey there. I am looking for a free to use for commercial website database that should have these design features, in the given order: Auto-Sharding (getting more free space by adding more server ...
0
votes
1answer
183 views

What database do most mobile start ups use? [closed]

mongodb? MySQL? PostgreSQL? If someone would add pluses and minus, let me know. Why I ask: I am a mobile startup. I need a database that supports spatial indexes. The spatial index must be able to ...