---
title: "PostGraphile v4 Released: A GraphQL API for Your Database"
publication: "Postgres Weekly"
issue: 277
published_at: "2018-10-10"
canonical_url: "https://postgresweekly.com/issues/277"
---

The latest Postgres news, articles, tools, and projects.       

#277 — October 10, 2018 

[Read on the Web](https://postgresweekly.com/issues/277)   

Postgres Weekly  

[PostGraphile v4 Released: A GraphQL API for Your Database](https://medium.com/@Benjie/postgraphile-v4-released-9dcb117d3e69) — Execute one command (or mount one Node.js middleware) and get a high-performance GraphQL API for your database. 

Benjie Gillam   

[The Versatile INSERT](https://pgdash.io/blog/postgres-insert.html) — A look at ‘some of the more interesting things’ you can do with `INSERT` in Postgres, beyond just adding a single row to a table, of course. 

RapidLoop   [![\](https://copm.s3.amazonaws.com/0308b4aa.png)](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyP) 

[Real-Time Postgres Performance Monitoring](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyP) — Collect out-of-the-box and custom PostgreSQL metrics and correlate them with data from your distributed infrastructure, applications, and logs. Gain real-time performance insights and set intelligent alerts with Datadog. Start a free trial. 

Datadog sponsor   

[Dynamic Monitoring of Postgres Instances using `pg_top`](https://severalnines.com/blog/dynamic-monitoring-postgresql-instances-using-pgtop) — [pg_top](https://github.com/markwkm/pg_top) is an open source tool for monitoring Postgres processes (a la Unix `top`). 

Brian Fehrle   

[Select Star SQL: An Interactive SQL Tutorial](https://selectstarsql.com/) — Want to get a bit better at SQL? This interactive online guide will give you some practical experience and is oriented, intriguingly, around querying a dataset of death row inmates. 

Zi Chong Kao   

[Working with Unions in Postgres](https://www.citusdata.com/blog/2018/09/27/fun-with-sql-unions-in-postgres/) — A primer with examples on using the `UNION` and `UNION ALL` operators when you need to unify results from multiple tables or queries. 

Gary Sahota   

[An Example of Moving a Tablespace](https://momjian.us/main/blogs/pgblog/2018.html#October_3_2018) — Tablespaces let you define where various database objects are stored on the underlying file system - but what if you want to move one? 

Bruce Momjian   

[Detailed Logging for Enterprise-Grade Postgres](https://www.percona.com/blog/2018/10/08/detailed-logging-for-enterprise-grade-postresql/) — A look at some of the config parameters you can tweak to get more detailed logs. 

Fernando Laudares Camargos   

[How to Manage Prometheus High-Availability with Postgres and TimescaleDB](https://blog.timescale.com/prometheus-ha-postgresql-8de68d19b6f5) — [Prometheus](https://prometheus.io/) is a popular open source monitoring system. 

Niksa Jakovljevic   

[An Express.js, Sequelize, and Postgres Association Tutorial](https://www.djamware.com/post/5bb1f05280aca74669894417/node-express-sequelize-and-postgresql-association-example) — If you want to work with Postgres from a Node.js webapp, this could be a handy primer. 

Didin Jamaludin   

[Improving Sort Performance](https://www.cybertec-postgresql.com/en/postgresql-improving-sort-performance/) — Shows how Postgres sorts can be tuned. 

Hans-Jürgen Schönig   

[Comparing EDB Postgres Platform to Self-Supported PostgreSQL](https://www.enterprisedb.com/compare-postgres-databases) — Watch the video. 

EnterpriseDB sponsor   

[pspg: An Alternative Pager for Postgres's psql Client](https://github.com/okbob/pspg) — Replaces `less` and brings in support for tabular data. 

Pavel Stehule   

[tic-tac-toe.sql: Tic Tac Toe Implemented in SQL](https://bitbucket.org/snippets/mariusz-krynski/bedBGK/tic-tac-toesql) 

Mariusz Krynski  

🗓 Events  

[2Q PGConf 2018](http://www.2qpgconf.com/) — **December 4-5 (Chicago)** A conference dedicated to exchanging PostgreSQL knowledge.   

[PGCONF.ASIA 2018](https://www.pgconf.asia/EN/2018/) — **Decemeber 10-12 (Tokyo, Japan)** PGConf.ASIA 2018 is an international conference for PostgreSQL. Come and join this one of the largest PostgreSQL conference held in Asia.    

[FOSDEM PGDay 2019](https://2019.fosdempgday.org/) — **February 1, 2019 (Brussels, Belgium)** An extension to the regular PostgreSQL activities at FOSDEM.         

Curated by [Cooperpress](https://cooperpress.com/) and [Craig Kerstiens](https://twitter.com/craigkerstiens) 

[Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom