{"id":5085,"date":"2012-07-16T14:34:34","date_gmt":"2012-07-16T19:34:34","guid":{"rendered":"http:\/\/bucktownbell.com\/?p=5085"},"modified":"2012-07-16T15:29:36","modified_gmt":"2012-07-16T20:29:36","slug":"sql-vs-nosql-which-is-better","status":"publish","type":"post","link":"http:\/\/bucktownbell.com\/?p=5085","title":{"rendered":"SQL vs. NoSQL: Which Is Better?"},"content":{"rendered":"<blockquote><p>So what can we conclude? Well, with the drivers here I focused primarily on ease-of-use. There are other factors that need to be considered, as well. Do they support connection pooling, for example? Do they cache? What about pulling in large amounts of data? (Hint: Most of the better drivers for most of the popular languages support cursors, so you don\u2019t have to pull all the data in at once.) Those are factors you\u2019ll need to investigate as you choose a driver for the language and database you\u2019re using. But in general, virtually all the popular languages today, including Java, PHP, Python, PERL, and even C++, have nice libraries that make database programming far easier than it used to be.<\/p><\/blockquote>\n<p>via <a href=\"http:\/\/slashdot.org\/topic\/bi\/sql-vs-nosql-which-is-better\/\">SQL vs. NoSQL: Which Is Better?<\/a>.<\/p>\n<blockquote><p>MongoDB does great with large complex structures that are typically read in individually, while the large relational databases do well when I\u2019m processing huge amounts of data. And no, my clients\u2019 data needs are nowhere near as big as Google, so we don\u2019t encounter any performance and scalability problems.<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>So what can we conclude? Well, with the drivers here I focused primarily on ease-of-use. There are other factors that need to be considered, as well. Do they support connection pooling, for example? Do they cache? What about pulling in &hellip; <a href=\"http:\/\/bucktownbell.com\/?p=5085\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[286],"tags":[156,722,651],"class_list":["post-5085","post","type-post","status-publish","format-standard","hentry","category-storage","tag-databases","tag-nosql","tag-sql"],"_links":{"self":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts\/5085","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5085"}],"version-history":[{"count":2,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts\/5085\/revisions"}],"predecessor-version":[{"id":5087,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts\/5085\/revisions\/5087"}],"wp:attachment":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5085"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5085"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5085"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}