What should be the choice.. MongoDB or Sql Server?
-
I am going to start a big construction project with MVC. I am confused about Db choice. Although worked with SQL server from past 5 years. but now thinking to use MongoDB. Is it a good move? :sigh:
Depends on what you're planning to store in it, how you want to retrieve the information, what skillsets your build team have etc etc etc. I'd need far more information about the project to even make an educated guess about which technologies would be appropriate for the it (the project). Oh, and I would charge money to do that. I would suggest that the very need to ask if it is a good move would suggest that it is probably not a good move in these circumstances :laugh:
-
I am going to start a big construction project with MVC. I am confused about Db choice. Although worked with SQL server from past 5 years. but now thinking to use MongoDB. Is it a good move? :sigh:
Schatak wrote:
I am going to start a big construction project with MVC. I am confused about Db choice.
I would recommend postponing the choice.
Schatak wrote:
Although worked with SQL server from past 5 years. but now thinking to use MongoDB.
They are not the same, and one would perform poor in the area where the other excells. SQL Server would be preferred for relational data, especially if you are on a Microsoft stack. I cannot determine whether or not MongoDB supports SQL92. It would be nice to know, since;
- You could postpone the choice of which database-class to use by programming against the IDbConnection interface.
- Inject any database-driver in there
- And if you keep your SQL compatible with SQL92, then any database supporting the standard could be used.
SQL92 is not as rich as the Sql dialect of the server, but it does offer the advantage to swap out the database entirely, simply by changing the configuration. ..but in general, you take risks in small and simple projects; it would be very not fun if you had to make a lot of changes in a very large project after some months of work, and breaking it in the process.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
-
Schatak wrote:
I am going to start a big construction project with MVC. I am confused about Db choice.
I would recommend postponing the choice.
Schatak wrote:
Although worked with SQL server from past 5 years. but now thinking to use MongoDB.
They are not the same, and one would perform poor in the area where the other excells. SQL Server would be preferred for relational data, especially if you are on a Microsoft stack. I cannot determine whether or not MongoDB supports SQL92. It would be nice to know, since;
- You could postpone the choice of which database-class to use by programming against the IDbConnection interface.
- Inject any database-driver in there
- And if you keep your SQL compatible with SQL92, then any database supporting the standard could be used.
SQL92 is not as rich as the Sql dialect of the server, but it does offer the advantage to swap out the database entirely, simply by changing the configuration. ..but in general, you take risks in small and simple projects; it would be very not fun if you had to make a lot of changes in a very large project after some months of work, and breaking it in the process.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
Eddy Vluggen wrote:
I cannot determine whether or not MongoDB supports SQL92
There's a reason it's called NoSQL. NoSQL Explained[^] by Mongo themselves.
Wrong is evil and must be defeated. - Jeff Ello
-
I am going to start a big construction project with MVC. I am confused about Db choice. Although worked with SQL server from past 5 years. but now thinking to use MongoDB. Is it a good move? :sigh:
I would use what I know best.
Wrong is evil and must be defeated. - Jeff Ello
-
Eddy Vluggen wrote:
I cannot determine whether or not MongoDB supports SQL92
There's a reason it's called NoSQL. NoSQL Explained[^] by Mongo themselves.
Wrong is evil and must be defeated. - Jeff Ello
Yes, I opened multiple search results in multiple tabs, and the first contained claims to be SQL92 compatible; but they were ODBC-based commercial solutions. Believe that it was wikipedia that stated there was no support for joins :)
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
-
Depends on what you're planning to store in it, how you want to retrieve the information, what skillsets your build team have etc etc etc. I'd need far more information about the project to even make an educated guess about which technologies would be appropriate for the it (the project). Oh, and I would charge money to do that. I would suggest that the very need to ask if it is a good move would suggest that it is probably not a good move in these circumstances :laugh:
Yeah, the project gonna be big for sure, data would be like more documents, images , videos . And performance of product is the key, they need fast retivals of docs, images and all. Things like that. So i heard about MongoDB does the things pretty well, but not sure if it gonna be good for large projects or something. What are your charges ;P ;P Paypal/CC? :-\
-
I would use what I know best.
Wrong is evil and must be defeated. - Jeff Ello
-
I am going to start a big construction project with MVC. I am confused about Db choice. Although worked with SQL server from past 5 years. but now thinking to use MongoDB. Is it a good move? :sigh:
Schatak wrote:
Although worked with SQL server from past 5 years. but now thinking to use MongoDB.
Based on what you posted - bad idea. Only thing that mongodb might be really good at, starting from zero, is storing and retrieving streaming video. And if if you need that then use mongo for that and use the SQL server for everything else.
-
Yeah, the project gonna be big for sure, data would be like more documents, images , videos . And performance of product is the key, they need fast retivals of docs, images and all. Things like that. So i heard about MongoDB does the things pretty well, but not sure if it gonna be good for large projects or something. What are your charges ;P ;P Paypal/CC? :-\
Schatak wrote:
big for sure, data would be like more documents, images , videos . And performance of product is the key, they need fast retivals of docs, images and all.
People often say that but it the same as saying "I want a fast car". You need to quantify that with real numbers. What is an "image"? What is a "video"? What is a "document"? How exactly is it retrieved? What exactly does fast mean? What exactly is doing the retrieving? For example are you backing up youtube? Are you retrieving a cat scan for an surgery team in an operating room? Are you retrieving a field image on an iphone in a farm in the middle of Idaho? Or the middle of the Sudan? And drill down on the details too. If they say "video" is it an hd capture from a hollywood film crew or is it really just a image capture (single frame every 5 seconds) from a security camera above a door? If they say 10,000 users does that mean they have 10,000 right now? Does it mean there will be 10,000 logged in every second viewing a cat scan? Or does it mean their most optimistic sales goal is to have 10,000 total users in 10 years time and at most 2 users at a time will be looking at a photograph? And best I can say is if they claim 10,000 at the same time right now then question exactly how they came up with that number.
-
I am going to start a big construction project with MVC. I am confused about Db choice. Although worked with SQL server from past 5 years. but now thinking to use MongoDB. Is it a good move? :sigh:
Define BIG Construction.... How much data is involved (written to and read from)? Mainly simple tables with simple types of bugger and heavier types? You like to encode/decode JSON all the time? Which requirements are wanted?
In Word you can only store 2 bytes. That is why I use Writer.