pgcli is an awesome alternative Postgres command line interface with auto-completion and syntax highlighting (although I personally find psql awesome on its own).
Provides the ability to query data directly from files in Postgres’ custom dump format. Currently a prototype that’s not recommended for production use.
4000+ jobs are now posted each month listing Postgres skills – enhance your talents and get certified with Comprehensive PostgreSQL training. Join a live on-line training session next week with Bruce Momjian and get certified in PostgreSQL Administration.
Postgres’ wide array of features become even more fun when you bring them together. In this case, the popular JSON datatype gets coupled with pub-sub from directly in your database, or to Postgres listen-notify.
The latest in the long line of overviews on using JSON in Postgres. This one covers the basics of inserting data but also filtering and querying it as well.
Adding to the list of features which will be available in Postgres 9.5 comes pg_rewind. As the name suggests this will let you re-wind some of your WAL, which can be especially handy as highlighted in this post for anyone running an HA setup.
Postgres 9.5 development is well underway with new features landing each week. Here’s a look at further flushing out the useful-ness of the awesome GiST index type.
If you’ve used Django for any time you’re probably familiar with ‘South’. Now migrations are fully baked in here’s a guide for everything you need to know to handle them in a safe way for your app.
Want all your relational data backed by a safe data store in Postgres, while gaining some of the flexible non-blocking nature you often see with NoSQL data stores? Here’s an answer for when using Postgres with the Play framework.
Write high quality and maintainable code. Be trusted to act autonomously and influence process/workflows, product direction, and technology choices. Work in a project team with two-week iterations.
