---
title: "Postgres + GraphQL = PostGraphQL"
publication: "Postgres Weekly"
issue: 185
published_at: "2016-12-07"
canonical_url: "https://postgresweekly.com/issues/185"
---

Postgres Weekly 185   . 

[Read this on the Web](http://postgresweekly.com/issues/185) 

[Postgres Weekly](http://postgresweekly.com) Issue 185 — December 7, 2016     

[PostGraphQL: PostgreSQL Meets GraphQL](https://www.compose.com/articles/postgraphql-postgresql-meets-graphql/?utm_source=postgresweekly&utm_medium=email)[GraphQL](https://facebook.github.io/react/blog/2015/05/01/graphql-introduction.html) is a data query language originally built at Facebook. PostGraphQL is a library that maps Postgres schemas to GraphQL ones that can then be queried against. Compose [Amazon Adds Postgres Compatibility to Aurora](https://aws.amazon.com/blogs/aws/amazon-aurora-update-postgresql-compatibility/?utm_source=postgresweekly&utm_medium=email)[Aurora](https://aws.amazon.com/rds/aurora/) began life as a MySQL-compatible high performance cloud database - now in private preview there is compatability for Postgres as well. Amazon#news [A PostgreSQL Primer for Busy People](https://zaiste.net/2015/09/postgresql_primer_for_busy_people/?utm_source=postgresweekly&utm_medium=email)A lightweight cookbook of common queries most people end up using with Postgres. Zaiste#tools [PostgreSQL Performance Tuning by 2ndQuadrant](https://2ndquadrant.com/en/services/postgresql-performance-tuning/)Tune your database to maximize your ROI. You’ve made significant investments in your hardware; now be sure your database fully utilizes it for your workloads. Learn about why Performance Tuning is so important and how we ensure your database is fully optimized. 2ndQuadrant#sponsored[![\](https://copm.s3.amazonaws.com/03789c4c.png)](https://2ndquadrant.com/en/services/postgresql-performance-tuning/) [PostgreSQL 9.6 Now Generally Available on Heroku](https://blog.heroku.com/postgresql-96-general-availability?utm_source=postgresweekly&utm_medium=email) Heroku#news [Amazon Aurora and Amazon RDS for PostgreSQL Are Now HIPAA-Eligible Services](https://aws.amazon.com/about-aws/whats-new/2016/11/amazon-aurora-and-amazon-rds-for-postgresql-are-now-hipaa-eligible-services/?utm_source=postgresweekly&utm_medium=email)Great news if you’re in the US healthcare industry. Amazon Web Services#news [ToroDB Stampede: MongoDB-to-Postgres Tool for Analysis](https://www.8kdata.com/blog/announcing-torodb-stampede-1-0-beta/?utm_source=postgresweekly&utm_medium=email)MongoDB collections are transformed, in real time, to a relational structure in PostgreSQL from where you can run native SQL queries or use popular business intelligence tools. 8KData#tools [Getting Started with Node, Express and Postgres Using Sequelize](https://scotch.io/tutorials/getting-started-with-node-express-and-postgres-using-sequelize?utm_source=postgresweekly&utm_medium=email) James Muturi#tutorial [How to Create JSON Responses From Postgres Instead of Ruby](http://blog.redpanthers.co/create-json-response-using-postgresql-instead-rails/?utm_source=postgresweekly&utm_medium=email)One for Rails developers. Postgres can produce JSON more efficiently directly than process it through Ruby. RedPanthers#tutorial [Zero Downtime Migrations with ActiveRecord and PostgreSQL](https://tech.lendinghome.com/zero-downtime-migrations-with-activerecord-and-postgresql-b3aca53ffbe6?utm_source=postgresweekly&utm_medium=email)Migrations in Postgres are often less disruptive than other databases, still there are steps you can follow to have truly zero downtime migrations. Sean Huber#tutorial [How Citus Enables Scalable PostgreSQL on AWS (video)](https://www.youtube.com/watch?v=bl_YYzYRHSI&utm_source=postgresweekly&utm_medium=email)This talk at re:Invent walks through both how Citus Cloud runs its operations on top of AWS as well as how Citus lets you scale storage, compute, and processing linearly. Amazon Web Services#video [Prest: Serve a RESTful API from any PostgreSQL Database](https://github.com/nuveo/prest?utm_source=postgresweekly&utm_medium=email) Nuveo#code [Don't Love Your Job? You Should - Try Hired and Find the Right Fit.](http://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q4-16-postgresweekly)Hired puts the power back in your hands, by having companies apply to you, not the other way around. With Hired you only talk to companies you're interested in. Hired#sponsored    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/185) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK