All Questions
15
questions
1
vote
2
answers
80
views
In MongoDB, if my queries do not involve any joins, can I assume that it will scale?
I have an APP that will be demanding in terms of pulling data. Each time a user logs in, data is pulled, each time a new page is visited data is pulled, etc.
Let's suppose that these queries will ...
0
votes
2
answers
342
views
What is the time complexity of fetching data from a table that is referenced in another table?
const image_schema = () => {
const common_fields = {
user_id: {
type: mongoose.Schema.Types.ObjectId,
ref: "user",
required: true,
},
file_name: {
...
-2
votes
1
answer
814
views
Multiple tables vs one table with more columns
My chosen database is MongoDB. But the question should be independent.
So for example, each row of record will have a flag that can take 1 of 2 possible values.
What is the pro and con of:
Having 1 ...
0
votes
0
answers
68
views
Best Practice in Firestore (or maybe NoSQL in general)
I really need some opinions from NoSQL experts, because I mainly was on the relational database train the last few years.
I am going to develop an app where users can track something on a daily basis ...
-1
votes
2
answers
55
views
Non-relational database design confusion
I am learning MongoDB and trying to get my head round the concept of not using a relational database schema.
For my application I want to be able to add new Users and Projects and assign Users to ...
0
votes
2
answers
192
views
Why are Relational databases said to be not good at scalability and what gives NOSQL databases the edge here?
Many articles claim that relational databases cannot be scaled and NOSQL is better at it but do not explain why. Scalability is often projected as an advantage of NOSQL. What is the problem with ...
1
vote
1
answer
347
views
For a key-value pair with simple values, is n't a relational database as good as a No-SQL database such as Redis?
Consider a key value pair in which both keys and values are strings. eg..
A key value pair that maps from long URL to short URL and vice-versa.
Long URL->Short URL.
A main advantage of no-SQL is ...
0
votes
2
answers
382
views
SQL a table for each metadata of other tables
Hi I have various time series each having a unique timeseries ID. Given an ID, the series look something like this (obviously with different dates and data respetively)
datetime data
1/1/1980 ...
4
votes
3
answers
5k
views
How can NoSQL databases achieve much better write throughput than some relational databases?
How is this possible? What is it about NoSQL that gives it a higher write throughput than some RDBMS? Does it boil down to scalability?
2
votes
2
answers
2k
views
Is Cassandra suitable as the main database for a social networking site?
There's been a lot of hype about NoSQL databases being used by big sites like Twitter and Facebook. However, as I've looked into this more carefully, it seems like most of the successful companies in ...
7
votes
3
answers
11k
views
Why are relational databases unsuitable for unstructured data?
I've been researching NoSQL databases, and a common theme that comes up is that relational databases are unsuitable for storing unstructured data. For example:
Unfortunately, the rigidly defined, ...
-1
votes
1
answer
2k
views
SQL or NoSQL for survey application tool [closed]
I am designing a survey tool which users can use to build their surveys or polls etc. So a basic survey tool needs to allow users to design a questions , upload files , login , register , share the ...
12
votes
5
answers
2k
views
Would relational databases scale as well (or better) than their NoSQL counterparts if we drop the relationships?
Disclaimer: This is a broad question, so it could be moved to a different source (if the admins find it appropriate).
All the cool kids seem to be dropping relational databases in favor of their ...
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 ...
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'?)