--- title: "PostgresApp 2.0, plus a 2016 PostgreSQL Roundup" publication: "Postgres Weekly" issue: 187 published_at: "2016-12-21" canonical_url: "https://postgresweekly.com/issues/187" --- Postgres Weekly 187 . [Read this on the Web](http://postgresweekly.com/issues/187) [Postgres Weekly](http://postgresweekly.com) Issue 187 — December 21, 2016 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](https://postgresapp.com/?utm_source=postgresweekly&utm_medium=email)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](http://blog.taadeem.net/english/2016/10/01/6_reasons_to_choose_PostgreSQL_9.6?utm_source=postgresweekly&utm_medium=email)Postgres 9.6 [was released](https://www.postgresql.org/about/news/1703/) earlier this year, and items about it dominated Postgres Weekly. [This PDF](http://momjian.us/main/writings/pgsql/features.pdf) of the [major features in 9.6](http://momjian.us/main/writings/pgsql/features.pdf) was very popular, with Damien's roundup a close second. Damien Clochard [Postgres 9.6 New Features with Examples (PDF)](http://community.hpe.com/hpeb/attachments/hpeb/JapanEnterpriseTopics/198/1/PostgreSQL%209.6%20New%20Features%20en%2020160606-1.pdf?utm_source=postgresweekly&utm_medium=email)A thorough 50 page (PDF) guide to the new features in Postgres 9.6. Hewlett Packard Enterprise [A Set of Postgres Practices to Follow](http://kukuruku.co/hub/programming/postgresql-set-of-practices?utm_source=postgresweekly&utm_medium=email)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](https://hashrocket.com/blog/posts/best-of-til-year-one-sql?utm_source=postgresweekly&utm_medium=email) Jake Worth [PostgreSQL Remote DBA Services by 2ndQuadrant Professionals](https://2ndquadrant.com/en/support/rdba/)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 — [![\](https://copm.s3.amazonaws.com/c4cc9d88.png)](https://2ndquadrant.com/en/support/rdba/) [Why Uber Engineering Switched from Postgres to MySQL](https://eng.uber.com/mysql-migration/?utm_source=postgresweekly&utm_medium=email)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](http://use-the-index-luke.com/blog/2016-07-29/on-ubers-choice-of-databases) and the story inspired [the community to discuss ways to improve](https://www.postgresql.org/message-id/5797D5A1.5030009%40agliodbs.com) in future. Evan Klitzke [These Are a Few of My Favorite (psql) Things](http://blog.thefourthparty.com/these-are-a-few-of-my-favorite-psql-things/?utm_source=postgresweekly&utm_medium=email)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](http://blog.endpoint.com/2016/01/postgres-95-three-little-things.html?utm_source=postgresweekly&utm_medium=email)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](http://jakeyesbeck.com/2016/02/21/four-postgresql-tips/?utm_source=postgresweekly&utm_medium=email)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](https://medium.com/@bengarvey/making-charts-with-postgres-5700f4c65cc8?utm_source=postgresweekly&utm_medium=email)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](https://madusudanan.com/blog/understanding-postgres-caching-in-depth/?utm_source=postgresweekly&utm_medium=email) Madusudanan [Is There A Perf Difference Between Equal (=) and IN with 1 Value?](http://stackoverflow.com/q/37828398/3951?utm_source=postgresweekly&utm_medium=email) Stack Overflow [pgAdmin 4 v1.0/1.1 Released](https://www.pgadmin.org/?utm_source=postgresweekly&utm_medium=email)The open source management and administration tool for Postgres was rewritten using Python and JavaScript. PostgreSQL [Postage: A Fast Replacement for PGAdmin](https://github.com/workflowproducts/postage?utm_source=postgresweekly&utm_medium=email) Workflow Products [Find Your Perfect Fit in 2017 - Try Hired](http://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q4-16-postgresweekly)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](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/187) [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