Re:NoSQL v. SQL is the worst holy war ever.
by gte910h on Wednesday March 03, 2010 @11:30AM
(#1164429)
I disagree. Lots of applications only require dumb bit buckets. There is no real sophistication or structure to the data. Anything more is over engineering for a large majority of products which data storage is not particularly useful or meaningful.
Re:NoSQL v. SQL is the worst holy war ever.
by bphogan on Wednesday March 03, 2010 @12:40PM
(#1164613)
I worked on a system a couple of years ago where we ran calculations nightly and then we write the results of this calculation to a row in a table for caching purposes. This row was then fetched by another job to generate a PDF. We used SQL for this because Reporting Services could build a pdf from a row in a table.
It's not a good solution. This type of data doesn't need to be searchable. It's using a database server as a caching mechanism. That seems wrong. Seems like memcached, mongo, couch, or anything else would have been better.
Heck, people have been using memcached for a long time, and yet all of a sudden people don't see a use for NoSQL setups?
Are we sure we're not just doing the same old "Defend what you know" dance?
I don't want to argue against the legitimate use of NoSQL solutions. I just don't think there are enough use-cases to justify the hype. For example, an article was posted here last week about using NoSQL solution to store e-commerce orders.