Click here to Skip to main content
14,331,729 members
   

Database

 
GeneralRe: What do you think of MongoDB? Pin
jkirkerx14-Aug-18 13:41
professionaljkirkerx14-Aug-18 13:41 
GeneralRe: What do you think of MongoDB? Pin
Eddy Vluggen14-Aug-18 23:08
mveEddy Vluggen14-Aug-18 23:08 
GeneralRe: What do you think of MongoDB? Pin
jkirkerx15-Aug-18 7:30
professionaljkirkerx15-Aug-18 7:30 
GeneralRe: What do you think of MongoDB? Pin
Eddy Vluggen15-Aug-18 9:38
mveEddy Vluggen15-Aug-18 9:38 
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 
If you do not know SQL and do not want to know SQL then it works.

In large business application domains it will not be adequate. But those often use disparate and not complementary technologies anyways.

NoSQL **DOES NOT** eliminate the need to manage the database. Never sure where people come up with this claim. Probably because they only use it for toy applications. ANY persisted data store will, over time, require maintenance. Things change over time and that means the data store(s) must be modified to fit those changes. And nothing fixes that.

Ignoring the need of future modifications only makes the need when it arises more difficult.

Getting the data model right is a problem unless you have experience in the business domain. Correcting the data model with NoSQL falls into the problem that I discussed above and certainly seems harder to me in NoSQL. But then I have been using SQL for a very long time so creating such solutions via SQL are going to be easier for me.

NoSQL has no advantage over normal business entities. Things like users, accounts, etc. Again that is more based on longer term business needs and because there are many, many tools that exist to use SQL and thus use such entities. For example to make money account might want to query the customers in the database - via SQL. Since NoSQL has no standards for API the usage of such tools for NoSQL is not as complete. But Mongodb has the advantage that it is the leader so such tools might support it.

Constraint violation is severe problem in NoSQL. It is a severe problem in SQL as well, unless you add the constraints in the first place. And doing that right can be complicated. There are no transactions either. Which means you need to deal with rollbacks if there is an end to end problem. Not an insurmountable problem unless you don't plan for it in the first place. But incorrect usage of transactions can lead to weird and very hard to deal with problems in SQL.

In one Mongodb application I considered that the only way to fix the constraint and transaction problem was to write a server that wrapped it and presented a standard API. It would manage transactions, rollbacks and constraint checking. Of course at that point what I would have had was in fact a relational database (so pointless to have NoSQL.)

I like SQL Stored procedures. Can't speak to any NoSQL solutions except Mongodb but their solution I do not considered a swap in replacement for stored procs. It is more just a way to moved normal business processing to the Mongodb server.
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 
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 

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.