<commit_before><!DOCTYPE html>
<html class="font">

	<head>
		<html lang="en">

		<link rel="icon" type="image/x-icon" href="../images/favicon.ico">
		<link rel="stylesheet" type="text/css" href="../stylesheets/reset.css">
		<link rel="stylesheet" type="text/css" href="../stylesheets/stylesheet.css">
		<link rel="stylesheet" type="text/css" href="../stylesheets/font-awesome.css">

		<script src="https://google-code-prettify.googlecode.com/svn/loader/run_prettify.js?lang=css&skin=desert"></script>
		<script src="http://code.jquery.com/jquery-latest.js" type="text/javascript"></script>
		<script src="../scripts/masonry.min.js" type="text/javascript" ></script>
		<script src="../scripts/jquery.isotope.min.js" type="text/javascript"></script>
		<script src="../scripts/blog-scripts.js" type="text/javascript"></script>

		<title>DBC Technical Blog: Week 7</title>
	</head>

	<body>
		<header>
			<h1><a href="../index.html"><NAME></a></h1>
			<h3><a href="../index.html#about">ABOUT</a></h3>
			<h3><a href="../index.html#blog">BLOG</a></h3>
			<h3><a href="#contact">CONTACT</a></h3>
		</header>

		<article id="top">
			<h1 class="center"><a href="../index.html#blog">Technical Blog</a>: Week 7</h1>
			<h2 class="center">SQL vs. NoSQL<h2>
			<h3 class="center"><i>August 31, 2014</i></h3>
			<hr class="shorthr">
			<br>
			<p>This blog post will be short, but sweet. There seem to be two main types of database architecture out there: <b>SQL</b>, which stands for <b>S</b>tructured <b>Q</b>uery <b>L</b>anguage, and NOSQL, which stands for <b>N</b>ot <b>O</b>nly <b>SQL</b>. </p>
			<br>
			<hr class="shorthr">
		</article>

		<div class="arrow_up center"><a href="#top"><i class="fa fa-angle-up fa-5x"></i></a></div>

		<div id="contact">
			<ul class="social">
				<li><a href="mailto:<EMAIL>">
					<i class="fa fa-envelope-square fa-3x"></i></a></li>
				<li><a href="https://www.linkedin.com/pub/daniel-schlessinger/34/9a2/a96/" target="_blank">
					<i class="fa fa-linkedin-square fa-3x"></i></a></li>
				<li><a href="https://github.com/dschlessinger/" target="_blank">
					<i class="fa fa-github-square fa-3x"></i></a></li>
				<li><a href="https://plus.google.com/+DanielSchlessinger/" target="_blank">
					<i class="fa fa-google-plus-square fa-3x"></i></a></li>
				<li><a href="https://www.facebook.com/schlessinger.daniel/" target="_blank">
					<i class="fa fa-facebook-square fa-3x"></i></a></li>
				<li><a href="https://twitter.com/dschless/" target="_blank">
					<i class="fa fa-twitter-square fa-3x"></i></a></li>
				<li><a href="https://instagram.com/djdschless/" target="_blank">
					<i class="fa fa-instagram-square fa-3x"></i></a></li>
			</ul>
		</div>

		<div id="copyright"><p>Copyright ©2014 <NAME></p></div>
	<body>

<html/><commit_msg>updates<commit_after><!DOCTYPE html>
<html class="font">

	<head>
		<html lang="en">

		<link rel="icon" type="image/x-icon" href="../images/favicon.ico">
		<link rel="stylesheet" type="text/css" href="../stylesheets/reset.css">
		<link rel="stylesheet" type="text/css" href="../stylesheets/stylesheet.css">
		<link rel="stylesheet" type="text/css" href="../stylesheets/font-awesome.css">

		<script src="https://google-code-prettify.googlecode.com/svn/loader/run_prettify.js?lang=css&skin=desert"></script>
		<script src="http://code.jquery.com/jquery-latest.js" type="text/javascript"></script>
		<script src="../scripts/masonry.min.js" type="text/javascript" ></script>
		<script src="../scripts/jquery.isotope.min.js" type="text/javascript"></script>
		<script src="../scripts/blog-scripts.js" type="text/javascript"></script>

		<title>DBC Technical Blog: Week 7</title>
	</head>

	<body>
		<header>
			<h1><a href="../index.html"><NAME></a></h1>
			<h3><a href="../index.html#about">ABOUT</a></h3>
			<h3><a href="../index.html#blog">BLOG</a></h3>
			<h3><a href="#contact">CONTACT</a></h3>
		</header>

		<article id="top">
			<h1 class="center"><a href="../index.html#blog">Technical Blog</a>: Week 7</h1>
			<h2 class="center">SQL vs. NoSQL<h2>
			<h3 class="center"><i>August 31, 2014</i></h3>
			<hr class="shorthr">
			<br>
			<p>This blog post will be short, but sweet. There seem to be two main types of database architecture out there: <b>SQL</b>, which stands for <b>S</b>tructured <b>Q</b>uery <b>L</b>anguage, and NOSQL, which stands for <b>N</b>ot <b>O</b>nly <b>SQL</b>.</p>

			<p>SQL has been used for decades - it was invented in the <a href="http://en.wikipedia.org/wiki/SQL#History">early 1970s</a> and is still used in nearly all database architecture. It is rigid but reliable, and everyone has used it so long that for the most part, all the kinks are worked out.</p>
			<p>But just because it works doesn't mean it is the <em>best</em>. For example, querying massive databases can get to be very slow, and SQL isn't very <b>D.R.Y.</b> There are better ways to store data. Take, for example, a <b>JSON</b> - <b>J</b>ava<b>S</b>cript <b>O</b>bject <b>N</b>otation - which is sort of like a hash of a hash (<a href="http://json.org/example">h/t JSON Example</a>):</p>
			<div class="code">
<pre class="prettyprint">
{"menu": {
  "id": "file",
  "value": "File",
  "popup": {
    "menuitem": [
      {"value": "New", "onclick": "CreateNewDoc()"},
      {"value": "Open", "onclick": "OpenDoc()"},
      {"value": "Close", "onclick": "CloseDoc()"}
    ]
  }
}}
</pre>
			</div>

			<p>The content above really doesn't matter, but what does matter is that it's a very different from a table. SQL is relational, and NOSQL is non-relational - NOSQL data is often stored in key-value pairs like above. Therefore, SQL can only pull information that is arranged in tabular form, but NOSQL can pull information stored in many different forms, some like the JSON example above. NOSQL also works with <b>wide column stores</b> and <b>graph databases</b>. This flexibility cuts down on repeated information by catering to the specific needs of the program, which results in increased speed. SQL's speed, on the other hand, is limited by the code architecture. You could have the fastest servers in the world, but you'd still have to query all those tables.</p>

			<p>It seems like more and more websites are finding NOSQL more fitting to their needs than SQL. I'm very excited to work with it in the future.</p>
			<br>
			<hr class="shorthr">
		</article>

		<div class="arrow_up center"><a href="#top"><i class="fa fa-angle-up fa-5x"></i></a></div>

		<div id="contact">
			<ul class="social">
				<li><a href="mailto:<EMAIL>">
					<i class="fa fa-envelope-square fa-3x"></i></a></li>
				<li><a href="https://www.linkedin.com/pub/daniel-schlessinger/34/9a2/a96/" target="_blank">
					<i class="fa fa-linkedin-square fa-3x"></i></a></li>
				<li><a href="https://github.com/dschlessinger/" target="_blank">
					<i class="fa fa-github-square fa-3x"></i></a></li>
				<li><a href="https://plus.google.com/+DanielSchlessinger/" target="_blank">
					<i class="fa fa-google-plus-square fa-3x"></i></a></li>
				<li><a href="https://www.facebook.com/schlessinger.daniel/" target="_blank">
					<i class="fa fa-facebook-square fa-3x"></i></a></li>
				<li><a href="https://twitter.com/dschless/" target="_blank">
					<i class="fa fa-twitter-square fa-3x"></i></a></li>
				<li><a href="https://instagram.com/djdschless/" target="_blank">
					<i class="fa fa-instagram-square fa-3x"></i></a></li>
			</ul>
		</div>

		<div id="copyright"><p>Copyright ©2014 <NAME></p></div>
	<body>

<html/>
{'fraction_non_alphanumeric': 0.21432389096739712, 'fraction_numerical': 0.01122394441475147, 'mean_word_length': 4.050607287449393, 'pattern_counts': {'":': 11, '<': 303, '<?xml version=': 0, '>': 303, 'https://': 14, 'lorem ipsum': 0, 'www.': 4, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1532089', 'n_tokens_mistral': 2939, 'n_tokens_neox': 2648, 'n_words': 639}