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

Postgres Weekly Issue 67 - August 6, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/67)**Postgres Weekly****Issue 67**
August 6, 2014[PostgreSQL Anti-patterns: Read-Modify-Write Cycles](http://blog.2ndquadrant.com/postgresql-anti-patterns-read-modify-write-cycles/?utm_source=postgresweekly&utm_medium=email)A follow up to last week’s post [about loops](http://bonesmoses.org/2014/07/25/friends-dont-let-friends-use-loops/?utm_source=postgresweekly&utm_medium=email) in Postgres here’s yet another anti-pattern of reading a value, modifying it and writing it back out. While often safe certain race conditions can occur._Craig Ringer_[Get Lightning Fast Search Results in Django with Postgres](https://www.youtube.com/watch?v=Ns-2Z90aByk?utm_source=postgresweekly&utm_medium=email)There’s a ton of options for full text search in any application, and of course Postgres offers a solution here as well. Here’s a great talk on setting it up with Django and the results you can get._Saikiran Yerram_[Writable Common Table Expressions](http://hashrocket.com/blog/posts/writable-common-table-expressions?utm_source=postgresweekly&utm_medium=email)Common table expressions can allow you to [write complex queries](http://www.craigkerstiens.com/2013/11/18/best-postgres-feature-youre-not-using/) that are more readable, or can let you do recursion within your queries. You can also create writable ones allowing even further use cases.[Heroku Postgres - Fully managed Postgres on EC2](https://postgres.heroku.com/?utm_source=postgresweekly=email=emailbanner?utm_source=postgresweekly&utm_medium=email)Heroku Postgres is the worlds largest provider of Postgres as a Service, offering fully managed databases on top of EC2. Get started today for free and scale easily as your application needs to._HerokuSponsored_[![\](http://s3.amazonaws.com/nlga/uploads/item/image/10726/thumb125_125x125-build-more-blue.png)](https://postgres.heroku.com/?utm_source=postgresweekly=email=emailbanner?utm_source=postgresweekly&utm_medium=email)[Postgres Upsert (Update or Insert) in GER using Knex.js](http://maori.geek.nz/post/postgres_upsert_update_or_insert_in_ger_using_knex_js?utm_source=postgresweekly&utm_medium=email)Upsert (insert or update) didn’t natively make it into Postgres for 9.4. So you’re still left rolling you’re own if you find it necessary. Here’s an example using knex.js should you need it (be careful though as race conditions can occur)._Graham Jenson_[Using Postgres' Hstore datatype in Rails](https://alybadawy.com/post/using-postgres-hstore-datatype-with-ruby-on-rails?utm_source=postgresweekly&utm_medium=email)Hopefully you’ve heard about Hstore by now, and while binary JSON is on the way it’s still an incredibly useful datatype today. Here’s a great guide for getting hands on with it in Rails._Aly Badawy_[Installing PostgreSQL On EC2 Via Chef Solo and Testing with serverspec](http://hashnao.blogspot.co.uk/2014/08/installing-postgresql-on-ec2-via-chef.html?utm_source=postgresweekly&utm_medium=email)_hashnao_[Intro to Flask Part 13 - Heroku Postgres Setup (video)](https://www.youtube.com/watch?v=FD0p-opdyoE?utm_source=postgresweekly&utm_medium=email)Using Flask and want to get setup with a Postgres host? Here’s a video to walk you through getting up and running with Heroku Postgres and it’s feature set._Michael Herman_Curated by [Craig Kerstiens](http://craigkerstiens.com/) and published by [Cooper Press](https://cooperpress.com/).
Want to sponsor an issue? See our [media kit.](https://cooperpress.com/mediakit2014q2.pdf)

 © 2017 Cooper Press Ltd. [Email policy](https://cooperpress.com/spam.html) [Privacy policy](https://cooperpress.com/privacy.html)
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK[Update your email address](*|UPDATE_PROFILE|*)
or [unsubscribe here](*|UNSUB|*)