---
title: "This Week's PostgreSQL News (#161)"
publication: "Postgres Weekly"
issue: 161
published_at: "2016-06-15"
canonical_url: "https://postgresweekly.com/issues/161"
---

Postgres Weekly 161   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 161 — June 15, 2016     

[MitM-ing Postgres](https://thusoy.com/2016/mitming-postgres?utm_source=postgresweekly&utm_medium=email)How you connect to your database can have big implications for how secure it actually is. This deep dive looks at two major providers Amazon RDS and Heroku Postgres and will have you thinking twice before you connect from a random coffee shop. Tarjei Husøy [Efficient Color Similarity Searching with Postgres](http://zejn.net/b/2016/06/10/postgresql-tutorial-color-similarity-search/?utm_source=postgresweekly&utm_medium=email)A novel example of what you can do with Postgres and computing similarity. A look at the distance operator and how indexes can speed things up, with an example of finding color values. Gašper Žejn#tutorial [PostgreSQL Exercises](https://pgexercises.com/?utm_source=postgresweekly&utm_medium=email)If you’re looking for a way to practice your SQL skills some PG Exercises offers some good example data and exercises to hone your skills. pgexercises.​com [DreamFactory 2.2 released, includes important API changes](http://blog.dreamfactory.com/dreamfactory-2-2-release?utm_source=postgres_weekly&utm_medium=newsletter&utm_campaign=2-2)Our API automation platform keeps getting better with new streamlined commercial packages. DreamFactory#sponsored[![\](https://copm.s3.amazonaws.com/7a225e98.png)](http://blog.dreamfactory.com/dreamfactory-2-2-release?utm_source=postgres_weekly&utm_medium=newsletter&utm_campaign=2-2) [Cleaning Up PostgreSQL Bloat](https://www.keithf4.com/cleaning-up-postgresql-bloat/?utm_source=postgresweekly&utm_medium=email)Checked out the [earlier article on checking for bloat](https://www.keithf4.com/checking-for-postgresql-bloat/)? This next article in the series digs deeper and takes a look at what you can actually do about it. Keith Fiske [Watching Your PostgreSQL Database](http://www.cybertec.at/2016/06/watching-your-postgresql-database/?utm_source=postgresweekly&utm_medium=email)A small but handy feature arrived in recent releases thanks to [@leinweber](http://www.twitter.com/leinweber) – the ability to watch queries. If you want to constantly run and see the output watching for changes this will make things easier. Hans-Juergen Schoenig [Copying Data from Postgres to Redshift](https://www.toothrot.net/2016/06/13/postgres-to-redshift-announce.html?utm_source=postgresweekly&utm_medium=email)Redshift offers some powerful options for data warehousing, but moving your data in can require some work. This tool makes it easier for you to go from standard Postgres into Redshift. Alexander Rakoczy#tutorial [Better Native Type Mappings for Postgres in ActiveRecord and Rails](https://medium.com/@frodsan/activerecord-better-native-types-mappings-for-postgresql-b5391d14ea68?utm_source=postgresweekly&utm_medium=email) Francesco Rodriguez#tutorial [Application Users vs. Row Level Security](http://blog.2ndquadrant.com/application-users-vs-row-level-security/?utm_source=postgresweekly&utm_medium=email)“RLS is fairly new feature and we’re not really dealing with many production deployments yet.” — Here’s a look at how to make it work with application-level users. Tomas Vondra [Testing PostgreSQL Scripts with RSpec and pg_tester](https://medium.com/@yammereng/testing-postgresql-scripts-with-rspec-and-pg-tester-c3c6c1679aec?utm_source=postgresweekly&utm_medium=email)A look at how Yammer use a pg_tester gem with RSpec to “provide a TDD-approach for writing maintainable scripts and automation involving PostgreSQL”. Neeran Gul [Moving to 9.5](http://bonesmoses.org/2016/06/10/pg-phriday-moving-to-9-5/?utm_source=postgresweekly&utm_medium=email)While Postgres 9.5 has been out for a while and there’s already a number of blog posts talking about the upcoming 9.6, if you haven’t upgraded to 9.5 there are some good reasons. Here’s a nice run down of 3 of the main features that make it worth an upgrade. Shaun M.​ Thomas [pgBucket: A New Concurrent Job Scheduler](http://manojadinesh.blogspot.com/2016/06/pgbucket-new-concurrent-job-scheduler.html?utm_source=postgresweekly&utm_medium=email)Using pgBucket you can schedule jobs easily and maintain them using CLI options. Dinesh Kumar#tools [Apply to 100 top tech companies with 1 application](http://www.indeed.com/prime?kw=postgresweekly&sid=xp_cooperpress_job)Indeed Prime connects top tech talent with top tech companies in the US. Companies compete to hire developers on Indeed Prime. 100% free for job seekers. Land a job and get $5k from Indeed Prime. Indeed Prime#job    

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