new postgresql resource

mattmakai · mattmakai · commit f56cd1bdb8cb · 2016-02-26T12:55:27.000-08:00
diff --git a/all.html b/all.html
@@ -4650,6 +4650,11 @@ <h2>General PostgreSQL resources</h2>
   covers how to find slow queries, tune indexes and modify your queries
   to run faster.</p>
 </li>
+<li>
+<p><a href="https://blog.andyet.com/2016/02/04/postgres-9.5-document-store-hybrid/">Creating a Document-Store Hybrid in Postgres 9.5</a>
+  explains how to store and query JSON data, similar to how
+  <a href="/no-sql-datastore.html">NoSQL data stores</a> operate.</p>
+</li>
 </ul>
           <h1>MySQL</h1>
 <p>MySQL is an open source <a href="/databases.html">relational database</a> 
@@ -5355,7 +5360,7 @@ <h2>Why are servers necessary?</h2>
 actual users (as opposed to test users) are known as <em>production</em> servers.
 Production servers hold real data (again as opposed to test data) and must be 
 secure against unauthorized access.</p>
-<h2>"Bare metal" servers</h2>
+<h2>Bare metal servers</h2>
 <p>The term <em>bare metal</em> refers to purchasing the actual hardware and hooking 
 it up to the Internet either through a business-class internet service 
 provider (ISP) or 
@@ -5366,9 +5371,9 @@ <h2>"Bare metal" servers</h2>
 volume but if your site serves a lot of traffic it will alert an ISP's
 filters.</p>
 <p>The bare metal option offers the most control over the server configuration,
-usually has the highest performance for the price, but also is the most 
+usually has the highest performance for the price, but also is the most
 expensive upfront option and the highest ongoing maintenance. With bare
-metal servers the ongoing operating cost is the electricity the server(s) 
+metal servers the ongoing operating cost is the electricity the server(s)
 use as well as handling repairs when server components malfunction. You're
 taking on manual labor working with hardware as well as the rest of the
 software stack.</p>
diff --git a/feeds/all.atom.xml b/feeds/all.atom.xml
@@ -1,2 +1,2 @@
 <?xml version="1.0" encoding="utf-8"?>
-<feed xmlns="http://www.w3.org/2005/Atom"><title>Matt Makai</title><link href="http://www.fullstackpython.com/" rel="alternate"></link><link href="http://www.fullstackpython.com/feeds/all.atom.xml" rel="self"></link><id>http://www.fullstackpython.com/</id><updated>2016-02-25T08:52:06Z</updated></feed>
+<feed xmlns="http://www.w3.org/2005/Atom"><title>Matt Makai</title><link href="http://www.fullstackpython.com/" rel="alternate"></link><link href="http://www.fullstackpython.com/feeds/all.atom.xml" rel="self"></link><id>http://www.fullstackpython.com/</id><updated>2016-02-26T12:55:24Z</updated></feed>
diff --git a/postgresql.html b/postgresql.html
@@ -248,6 +248,11 @@ <h2>General PostgreSQL resources</h2>
   covers how to find slow queries, tune indexes and modify your queries
   to run faster.</p>
 </li>
+<li>
+<p><a href="https://blog.andyet.com/2016/02/04/postgres-9.5-document-store-hybrid/">Creating a Document-Store Hybrid in Postgres 9.5</a>
+  explains how to store and query JSON data, similar to how
+  <a href="/no-sql-datastore.html">NoSQL data stores</a> operate.</p>
+</li>
 </ul>
 <h3>Do you want to learn more about data or web apps?</h3>
 <div class="row">
diff --git a/servers.html b/servers.html
@@ -42,7 +42,7 @@ <h2>Why are servers necessary?</h2>
 actual users (as opposed to test users) are known as <em>production</em> servers.
 Production servers hold real data (again as opposed to test data) and must be 
 secure against unauthorized access.</p>
-<h2>"Bare metal" servers</h2>
+<h2>Bare metal servers</h2>
 <p>The term <em>bare metal</em> refers to purchasing the actual hardware and hooking 
 it up to the Internet either through a business-class internet service 
 provider (ISP) or 
@@ -53,9 +53,9 @@ <h2>"Bare metal" servers</h2>
 volume but if your site serves a lot of traffic it will alert an ISP's
 filters.</p>
 <p>The bare metal option offers the most control over the server configuration,
-usually has the highest performance for the price, but also is the most 
+usually has the highest performance for the price, but also is the most
 expensive upfront option and the highest ongoing maintenance. With bare
-metal servers the ongoing operating cost is the electricity the server(s) 
+metal servers the ongoing operating cost is the electricity the server(s)
 use as well as handling repairs when server components malfunction. You're
 taking on manual labor working with hardware as well as the rest of the
 software stack.</p>
diff --git a/source/content/pages/05-data/05-postgresql.markdown b/source/content/pages/05-data/05-postgresql.markdown
@@ -214,3 +214,7 @@ The post is an inside look at the evolution of Braintree's usage of the database
 * This article on [performance tuning PostgreSQL](http://www.geekytidbits.com/performance-tuning-postgres/)
   covers how to find slow queries, tune indexes and modify your queries
   to run faster.
+
+* [Creating a Document-Store Hybrid in Postgres 9.5](https://blog.andyet.com/2016/02/04/postgres-9.5-document-store-hybrid/)
+  explains how to store and query JSON data, similar to how
+  [NoSQL data stores](/no-sql-datastore.html) operate.
diff --git a/source/content/pages/07-web-app-deployment/02-servers.markdown b/source/content/pages/07-web-app-deployment/02-servers.markdown
@@ -22,7 +22,7 @@ Production servers hold real data (again as opposed to test data) and must be
 secure against unauthorized access.
 
 
-## "Bare metal" servers
+## Bare metal servers
 The term *bare metal* refers to purchasing the actual hardware and hooking 
 it up to the Internet either through a business-class internet service 
 provider (ISP) or 
@@ -34,9 +34,9 @@ volume but if your site serves a lot of traffic it will alert an ISP's
 filters.
 
 The bare metal option offers the most control over the server configuration,
-usually has the highest performance for the price, but also is the most 
+usually has the highest performance for the price, but also is the most
 expensive upfront option and the highest ongoing maintenance. With bare
-metal servers the ongoing operating cost is the electricity the server(s) 
+metal servers the ongoing operating cost is the electricity the server(s)
 use as well as handling repairs when server components malfunction. You're
 taking on manual labor working with hardware as well as the rest of the
 software stack.

Original file line number	Diff line number	Diff line change
`@@ -1,2 +1,2 @@`
`1`	`1`	`<?xml version="1.0" encoding="utf-8"?>`
`2`		`-<feed xmlns="http://www.w3.org/2005/Atom"><title>Matt Makai</title><link href="http://www.fullstackpython.com/" rel="alternate"></link><link href="http://www.fullstackpython.com/feeds/all.atom.xml" rel="self"></link><id>http://www.fullstackpython.com/</id><updated>2016-02-25T08:52:06Z</updated></feed>`
	`2`	`+<feed xmlns="http://www.w3.org/2005/Atom"><title>Matt Makai</title><link href="http://www.fullstackpython.com/" rel="alternate"></link><link href="http://www.fullstackpython.com/feeds/all.atom.xml" rel="self"></link><id>http://www.fullstackpython.com/</id><updated>2016-02-26T12:55:24Z</updated></feed>`