All Questions
710
questions
257
votes
10
answers
69k
views
What did MongoDB not being ACID compliant before v4 really mean?
I am not a database expert and have no formal computer science background, so bear with me. I want to know the kinds of real world negative things that can happen if you use an old MongoDB version ...
146
votes
8
answers
33k
views
Use cases for NoSQL [closed]
NoSQL has been getting a lot of attention in our industry recently. I'm really interested in what peoples thoughts are on the best use-cases for its use over relational database storage. What should ...
142
votes
7
answers
198k
views
Foreign keys in mongo?
How do I design a scheme such this in MongoDB? I think there are no foreign keys!
141
votes
21
answers
22k
views
Good reasons NOT to use a relational database?
Can you please point to alternative data storage tools and give good reasons to use them instead of good-old relational databases? In my opinion, most applications rarely use the full power of SQL--it ...
137
votes
3
answers
133k
views
SQL (MySQL) vs NoSQL (CouchDB) [closed]
I am in the middle of designing a highly-scalable application which must store a lot of data. Just for example it will store lots about users and then things like a lot of their messages, comments etc....
96
votes
5
answers
75k
views
SQL versus noSQL (speed)
When people are comparing SQL and noSQL, and concluding the upsides and downsides of each one, what I never hear anyone talking about is the speed.
Isn't performing SQL queries generally faster than ...
73
votes
7
answers
24k
views
When shouldn't you use a relational database? [closed]
Apart from the google/bigtable scenario, when shouldn't you use a relational database? Why not, and what should you use? (did you learn 'the hard way'?)
55
votes
8
answers
12k
views
The Next-gen Databases [closed]
I'm learning traditional Relational Databases (with PostgreSQL) and doing some research I've come across some new types of databases. CouchDB, Drizzle, and Scalaris to name a few, what is going to be ...
54
votes
4
answers
46k
views
Join operation with NOSQL
I have gone through some articles regarding Bigtable and NOSQL. It is very interesting that they avoid JOIN operations.
As a basic example, let's take Employee and Department table and assume the ...
54
votes
3
answers
22k
views
Any detailed and specific reasons for Why MongoDB is much faster than SQL DBs?
Ok, there are questions about Why Is MongoDB So Fast
I appreciate those answers, however, they are quite general. Yes, I know:
MongoDB is document-based, then why being document-based can lead to
...
49
votes
6
answers
18k
views
Reasons for and against moving from SQL server to MongoDB [closed]
I know this is a big question and it's not a yes or no answer but we develop web apps and are looking into using MongoDB for our persistence solution. Combining MongoDB with NoRM for object storage.
...
37
votes
4
answers
22k
views
Database EAV Pros/Cons and Alternatives [closed]
I have been looking for a database solution to allow user defined fields and values (allowing an unlimited number). At first glance, EAV seemed like the right fit, but after some reading I am not ...
35
votes
3
answers
16k
views
Are there any REAL advantages to NoSQL over RDBMS for structured data on one machine?
So I've been trying hard to figure out if NoSQL is really bringing that much value outside of auto-sharding and handling UNSTRUCTURED data.
Assuming I can fit my STRUCTURED data on a single machine ...
31
votes
6
answers
16k
views
MongoDB and PostgreSQL thoughts
I've got an app fully working with PostgreSQL. After reading about MongoDB, I was interested to see how the app would work with it. After a few weeks, I migrated the whole system to MongoDB.
I like a ...
28
votes
8
answers
44k
views
Database for super-fast querying [closed]
We have a 300 Gb+ data array we'd like to query as fast as possible. Traditional SQL databases (specifically, SQL Server) cannot handle this volume as effectively as we need (like, perform a select ...