What do you think of MongoDB?
-
Nathan Minier wrote:
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.
While I agree with most, here we differ very much; if it is relational data, then I will be expecting constraints at the database-level. You are allowed to duplicate the checks in your application ofc (I no care), but the database is responsible for the correctness of its contents, regardless how the programmer implemented the UI. Unless it is a local data-cache, your db is going to be serving multiple UI's. Without a decent db, one of those UI's will fuck the complete db, as Murphy's law predicts.
Nathan Minier wrote:
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.
Nah, depending on the nature of the data that might be done as well by NoSQL.
Nathan Minier wrote:
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.
The db is my DAL. I speak to it in a generilzed abstract query language.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
Eddy Vluggen wrote:
Unless it is a local data-cache, your db is going to be serving multiple UI's. Without a decent db, one of those UI's will f*** the complete db, as Murphy's law predicts.
Actually, we're completely agreeing here, which is what I tried to address in the next section you quoted; I suppose I could have been more clear about that. I just don't assume the technology that mucks with the data will be a UI :)
"Never attribute to malice that which can be explained by stupidity." - Hanlon's Razor
-
Eddy Vluggen wrote:
Unless it is a local data-cache, your db is going to be serving multiple UI's. Without a decent db, one of those UI's will f*** the complete db, as Murphy's law predicts.
Actually, we're completely agreeing here, which is what I tried to address in the next section you quoted; I suppose I could have been more clear about that. I just don't assume the technology that mucks with the data will be a UI :)
"Never attribute to malice that which can be explained by stupidity." - Hanlon's Razor
Nathan Minier wrote:
I just don't assume the technology that mucks with the data will be a UI :)
"Any kind of client" then :)
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.