Click here to Skip to main content
14,304,152 members
   

Database

 
GeneralRe: What do you think of MongoDB? Pin
jschell19-Aug-18 8:02
memberjschell19-Aug-18 8:02 
GeneralRe: What do you think of MongoDB? Pin
jschell19-Aug-18 8:00
memberjschell19-Aug-18 8:00 
GeneralRe: What do you think of MongoDB? Pin
Eddy Vluggen19-Aug-18 13:04
mveEddy Vluggen19-Aug-18 13:04 
AnswerRe: What do you think of MongoDB? Pin
jschell19-Aug-18 7:56
memberjschell19-Aug-18 7:56 
GeneralRe: What do you think of MongoDB? Pin
jkirkerx19-Aug-18 9:40
professionaljkirkerx19-Aug-18 9:40 
AnswerRe: What do you think of MongoDB? Pin
Nathan Minier20-Aug-18 2:09
professionalNathan Minier20-Aug-18 2:09 
GeneralRe: What do you think of MongoDB? Pin
Eddy Vluggen20-Aug-18 3:07
mveEddy Vluggen20-Aug-18 3:07 
GeneralRe: What do you think of MongoDB? Pin
Nathan Minier20-Aug-18 3:37
professionalNathan Minier20-Aug-18 3:37 
These are arguments that I see a lot and largely consider to be straw men, based on the difference between the overall approach to using the different systems. Yes, NoSQL doesn't work like SQL; it's in the name.

Eddy Vluggen wrote:
A NoSQL db will not be optimized to run (complex) queries.


Largely a NoSQL DB will not require queries nearly as complex as a SQL server, due to the non-relational nature of the data, making JOINS fundamentally inappropriate. Because the data is bundled similarly to an in-memory object, you end up treating it as a collection selection process rather than a database query. This is one of the things that I like about it, as I don't need to start "thinking in SQL" when I need to hydrate objects. This is also a minus, because you don't have the flexibility to establish new relationships without a change at the application level; so for someone that works on things at both the application and database layers this makes ad hoc querying difficult at best.

Eddy Vluggen wrote:
There's little in terms of constraints to keep the data consistent or correct.

Since you will not be using an object from different languages, i.e. an object in a store will need to be derived from the same library or have an adapter to be read in the first place, pushing constraints into the database is not appropriate. Your applications (or shared class library) should be handling that. I would argue that relying on constraints for consistency in a SQL system is exceptionally bad practice as well; your application should have some understanding of what an acceptable value is.

The real difference to me is that SQL is great when you don't know what will be producing or consuming the data, or how they will be doing it. It is very powerful in that regard, and when you're a DBA and have no idea what crazy app dev will be using your data, all these controls are appropriate and necessary.

If, however, you're an app dev making a purpose-built system that you do not intend to expose data for across several platforms, NoSQL brings a hell of a lot to the table. For one: you don't need to play these SQL translation games, and your DAL doesn't need to be written in a completely different language.
"Never attribute to malice that which can be explained by stupidity."
- Hanlon's Razor

GeneralRe: What do you think of MongoDB? Pin
Eddy Vluggen20-Aug-18 3:46
mveEddy Vluggen20-Aug-18 3:46 
GeneralRe: What do you think of MongoDB? Pin
Nathan Minier20-Aug-18 3:52
professionalNathan Minier20-Aug-18 3:52 
GeneralRe: What do you think of MongoDB? Pin
Eddy Vluggen20-Aug-18 3:56
mveEddy Vluggen20-Aug-18 3:56 
Questionhow to create a sum query between multiple tables in Microsoft access Pin
Member 1028319111-Aug-18 8:50
memberMember 1028319111-Aug-18 8:50 
AnswerRe: how to create a sum query between multiple tables in Microsoft access Pin
Eddy Vluggen11-Aug-18 9:08
mveEddy Vluggen11-Aug-18 9:08 
GeneralRe: how to create a sum query between multiple tables in Microsoft access Pin
Member 1028319111-Aug-18 9:14
memberMember 1028319111-Aug-18 9:14 
GeneralRe: how to create a sum query between multiple tables in Microsoft access Pin
Eddy Vluggen11-Aug-18 9:20
mveEddy Vluggen11-Aug-18 9:20 
AnswerRe: how to create a sum query between multiple tables in Microsoft access Pin
Mycroft Holmes11-Aug-18 13:15
memberMycroft Holmes11-Aug-18 13:15 
AnswerRe: how to create a sum query between multiple tables in Microsoft access Pin
CHill6015-Aug-18 2:15
protectorCHill6015-Aug-18 2:15 
GeneralRe: how to create a sum query between multiple tables in Microsoft access Pin
Mycroft Holmes15-Aug-18 13:09
memberMycroft Holmes15-Aug-18 13:09 
GeneralRe: how to create a sum query between multiple tables in Microsoft access Pin
CHill6020-Aug-18 4:15
protectorCHill6020-Aug-18 4:15 
GeneralRe: how to create a sum query between multiple tables in Microsoft access Pin
Mycroft Holmes20-Aug-18 12:57
memberMycroft Holmes20-Aug-18 12:57 
QuestionStored Procedure execution from Entity Framework should return 0 or -1 if insert or update fails Pin
indian1437-Aug-18 14:27
memberindian1437-Aug-18 14:27 
AnswerRe: Stored Procedure execution from Entity Framework should return 0 or -1 if insert or update fails Pin
Mycroft Holmes7-Aug-18 14:37
memberMycroft Holmes7-Aug-18 14:37 
GeneralRe: Stored Procedure execution from Entity Framework should return 0 or -1 if insert or update fails Pin
indian1437-Aug-18 14:39
memberindian1437-Aug-18 14:39 
GeneralRe: Stored Procedure execution from Entity Framework should return 0 or -1 if insert or update fails Pin
Mycroft Holmes7-Aug-18 16:38
memberMycroft Holmes7-Aug-18 16:38 
GeneralRe: Stored Procedure execution from Entity Framework should return 0 or -1 if insert or update fails Pin
indian1438-Aug-18 6:38
memberindian1438-Aug-18 6:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.