Issue #187: PostgresApp 2.0, plus a 2016 PostgreSQL Roundup

2016 is almost over, so in this issue we're reflecting on the biggest stories and best tutorials of 2016 (plus one big bit of news from this week). If you've missed any issues this year, this is a great place to catch up.

Due to Christmas, our next issue will be in January. Happy holidays! :-)

PostgresApp 2.0 Released

Fresh out today, an all new UI for the popular, integrated way to easily get Postgres running on the Mac. It requires macOS 10.10 or later.

postgresapp.com

6 Reasons to Choose PostgreSQL 9.6

Postgres 9.6 was released earlier this year, and items about it dominated Postgres Weekly. This PDF of the major features in 9.6 was very popular, with Damien's roundup a close second.

Damien Clochard

Postgres 9.6 New Features with Examples (PDF)

A thorough 50 page (PDF) guide to the new features in Postgres 9.6.

Hewlett Packard Enterprise

A Set of Postgres Practices to Follow

22 rules of thumb picked up from years of working with it. A very popular article this year.

Denis Smirnov

5 Postgres SQL Tips Learnt in the Past Year

Jake Worth

PostgreSQL Remote DBA Services by 2ndQuadrant Professionals

Save Time and Money - Hire the best DBAs to care for your database. Remote DBA with remote monitoring allows us to act fast while also pre-empting potential failure. Be confident your database is always running and performing at its peak potential.

2ndQuadrant RDBA #sponsored

Why Uber Engineering Switched from Postgres to MySQL

Uber Engineering's rationale for switching away from Postgres was incredibly popular and inspired a lot of debate in the community. Markus Winand also had a lot to say on the matter and the story inspired the community to discuss ways to improve in future.

Evan Klitzke

These Are a Few of My Favorite (psql) Things

It’s not much of a secret I love psql, the command line based utility for interacting with Postgres. If you think you need a graphical editor, though, first try exploring all psql has to offer.

Lauren Ellsworth

Postgres 9.5: Three Little Things

There have been some great posts about Postgres 9.5’s main features but there are some smaller items that make a difference - here’s three you may have missed.

Greg Sabino Mullane

Four PostgreSQL Tips

Postgres is packed with so many useful features that it makes it hard to keep up with everything you may find beneficial. This list of four incredibly useful tips was very popular this year.

Jake Yesbeck

Making Charts with Postgres

This walkthrough shows you how starting with something simple and gradually building on it can help create a common type of time-series report with SQL.

Ben Garvey

Understanding Caching in Postgres - An In-Depth Guide

Madusudanan

Is There A Perf Difference Between Equal (=) and IN with 1 Value?

Stack Overflow

pgAdmin 4 v1.0/1.1 Released

The open source management and administration tool for Postgres was rewritten using Python and JavaScript.

PostgreSQL

Postage: A Fast Replacement for PGAdmin

Workflow Products

Find Your Perfect Fit in 2017 - Try Hired

Finding the right role can be daunting, but not on Hired. Get empowered to find the right role with multiple job offers and free personalized support.

Hired #job

Postgres Weekly is curated by Craig Kerstiens

See our archives

Change your email address

Stop getting this newsletter

Published by Cooperpress
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK