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

Postgres Weekly Issue 42 - January 15, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/42)**Postgres Weekly****Issue 42**
January 15, 2014[Nordic PostgreSQL Day 2014: Stockholm, March 20](http://2014.nordicpgday.org/?utm_source=postgresweekly&utm_medium=email)There seems to be no shortage of Postgres events as popularity continues to grow, and the Nordic PG Day seems to be another great example of such.[Rapid Schema Development with PostgreSQL [video\]](http://vimeo.com/album/2683752/video/83756644?utm_source=postgresweekly&utm_medium=email)All Your Base Conf is a great general database conference. In 2013, Andrew Godwin was there to represent Postgres. He highlighted it as not just a great relational database but how you can go move beyond using it as just a relational database._All Your Base Conf 2013_[Everyday Postgres: Specifying All Your INSERT Columns](http://www.chesnok.com/daily/2014/01/14/everyday-postgres-specifying-all-your-insert-columns/?utm_source=postgresweekly&utm_medium=email)Postgres has a lot of conveniences when it comes to working with it each day, such as not specifying all your targets on an insert. At the same time this can come to bite you later on as Selena discusses here._Selena Deckelmann_[How to Recover or Reset A Lost PostgreSQL Password](http://astonj.com/tech/how-to-recover-or-reset-a-lost-postgresql-password/?utm_source=postgresweekly&utm_medium=email)Hopefully it doesn’t frequently happen, but a lost password on a Postgres database can absolutely occur. When it does there is a solution, given you have appropriate access to the box._AstonJ_[5 Degrees of Pokémon Bacon](http://www.phishie.com/wordpress/2014/01/5-degrees-of-pokemon-bacon/?utm_source=postgresweekly&utm_medium=email)Common Table Expressions or CTEs are an awesomely useful feature in Postgres; when used as recursive CTEs they can become immensely powerful. Here’s a bit more of an unorthodox example using them with Pokémon._Brian Dunavant_[Que: A Ruby Job Queue That Uses PostgreSQL's Advisory Locks for Speed and Reliability](https://github.com/chanks/que?utm_source=postgresweekly&utm_medium=email)While advisory locks have some caveats, here’s a Ruby job queue that promises improved speed and reliability for queuing jobs over commonly popular libraries._Chris Hanks_From our sponsor[Heroku Postgres - Fully managed Postgres on EC2](https://postgres.heroku.com/?utm_source=postgresweekly=email=emailbanner?utm_source=postgresweekly&utm_medium=email)There's a lot to worry about when building your application; ensuring your database is secured, backed up, available shouldn't have to be part of that. Let Heroku Postgres focus on keeping your database running so you can take advantage of all the awesome features within Postgres.

_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._[![\](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)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|*)