Which Is Better for Programmers: SQL vs. NoSQL? #sql #nosql #bigdata #mongodb #cassandra

Which Is Better for Programmers: SQL vs. NoSQL? #sql #nosql #bigdata #mongodb #cassandra:

nosql:

Jeff Cogswell compares some short code samples in an attempt to answer the much bigger question:

But what about the programmers, who write the client code that access the databases? Where do the disagreements leave them? From a programming perspective, is SQL really that horrible and outdated? Or is the new NoSQL really that awful to work with? Perhaps they both have strengths and good points.

I confess that reading the above made me curious about what the article would conclude. Unfortunately, by the time I’ve read the first comparison (JavaScript in NodeJS using SQL vs Mongo) I realized my expectations were too high. For a few reasons:

  1. it would have been impossible to compare the APIs of all relevant NoSQL databases with a relational database;
  2. it would have been very difficult to choose a generic, representative enough use case;
  3. the results would have always been heavily influenced by the quality of drivers and libraries used.

Last but not least, many of the merits of the NoSQL databases are related to operational complexity and not programming complexity. As someone that did a fare amount of coding and close to zero operations, I would probably feel OK accepting a bit of programming complexity for simplified operations. But that might be just a biased opinion.

Original title and link: Which Is Better for Programmers: SQL vs. NoSQL? (NoSQL database©myNoSQL)

via Tumblr http://socialcloudtech.tumblr.com/post/27411767712

6 Comments

  1. I am extremely impressed with your writing skills as well as with the layout on your weblog.

    Is this a paid theme or did you customize it yourself?
    Either way keep up the nice quality writing, it
    is rare to see a nice blog like this one
    today.

  2. Hey! I know this is kind of off topic but I was wondering which blog platform
    are you using for this site? I’m getting tired of WordPress because I’ve had issues with
    hackers and I’m looking at options for another platform. I would be great if you could point me in the direction of a good platform.

  3. After I originally left a comment I seem to have clicked on
    the -Notify me when new comments are added- checkbox and now whenever a comment is added I get 4 emails
    with the same comment. Perhaps there is a means you are able to remove me from that service?
    Cheers!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s