---
title: "This Week's PostgreSQL News (#123)"
publication: "Postgres Weekly"
issue: 123
published_at: "2015-09-16"
canonical_url: "https://postgresweekly.com/issues/123"
---

Postgres Weekly 123   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 123 — September 16, 2015     

[Postgres, pg_shard, and What We Learned From Our Failures](https://www.citusdata.com/blog/19-ozgun/265-postgresql-pgshard-and-what-we-learned-our-failures?utm_source=postgresweekly&utm_medium=email)A lot of companies and products want to extend Postgres to do more than it can out of the box. There’s a variety of ways of doing this, one being Postgres’ foreign data wrappers - if you use them for what they’re intended they’re great, but sometimes it may not work out so well.. Citus Data [Bye Bye MySQL and MongoDB. Guten Tag PostgreSQL](https://www.userlike.com/en/blog/2015/10/09/bye-by-mysql-and-mongodb-guten-tag-postgresql?utm_source=postgresweekly&utm_medium=email)For a long time MongoDB and MySQL had a leg up on Postgres, one for user experience and the other for well… replication. Postgres has come a long way since those days and now is seen as a replacement for both as shown here. Userlike#opinion [Heroku Data Links with Postgres and Redis](http://blog.codeship.com/heroku-data-links-postgres-redis/?utm_source=postgresweekly&utm_medium=email)Heroku has dramatically simplified the process of using Foreign Data Wrappers with PostgreSQL and Redis via its Data Links feature. Barry Jones [Postgres Skills are in Demand - Add to your skill set and get certified](http://www.enterprisedb.com/products-services-training/training&ls=CP)4000+ jobs are now posted each month listing Postgres skills – enhance your talents and get certified with expert training courses. The EDB certification program sets the global standard for Postgres professionals, and is definitive proof of your skills. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/54f7afc1.png)](http://www.enterprisedb.com/products-services-training/training&ls=CP) [Envelope: A Webapp Dev Platform on top of Postgres](http://envelope.xyz/?utm_source=postgresweekly&utm_medium=email)Envelope is a new approach to building RESTful applications. It provides an app server out of the box that sits in front of your database and provides a direct API for writing JS apps against it. Workflow Products [Breaking Down Data Silos with Foreign Data Wrappers](http://www.infoq.com/articles/breaking-down-data-silos-with-foreign-data-wrappers?utm_source=postgresweekly&utm_medium=email)These days data is everywhere, and aggregating it can be as hard as keeping a database up and running. Postgres’ foreign data wrappers are incredibly powerful here in allowing you to query from a Postgres database to any other data source as highlighted here. InfoQ [PostgreSQL Foreign Data Wrappers](https://www.kentik.com/postgresql-foreign-data-wrappers/?utm_source=postgresweekly&utm_medium=email)Postgres is ripe with exciting things lately: hstore, jsonb, extensions, foreign data wrappers. Foreign data wrappers particularly provide a lot of promise in connecting to other data sources. Here’s a rundown of how writing your own might go. Ian Pye [Syncing Cache with Postgres](https://medium.com/namely-labs/syncing-cache-with-postgres-7a4d78cec022?utm_source=postgresweekly&utm_medium=email) Gian Biondi#tutorial [psql2csv: Run A Query in psql and Output The Result As CSV](https://github.com/fphilipe/psql2csv?utm_source=postgresweekly&utm_medium=email)Postgres has a lot of powerful ability in the CLI, one such command is copy, making it easy to bulk load data in or out of Postgres. Here’s a great convenience wrapper to make this easier to dump a query directly to CSV locally. Philipe Fatioavid Cramer#tools [Join The Top 3% of Freelance PostgreSQL Developers Worldwide](http://www.toptal.com/developers?utm_source=postgresweekly&utm_medium=email&utm_content=postgres_weekly&utm_campaign=top_3)Toptal is an exclusive network of elite freelance software engineers. Apply today to work with top clients, set your own rates, and collaborate with other top PostgreSQL developers. Toptal#job    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/123) [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