Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
Postgres Weekly
Issue 100 — April 8, 2015
A 5 Minute Video Introduction to pgcli
pgcli is an awesome alternative Postgres command line interface with auto-completion and syntax highlighting (although I personally find psql awesome on its own).
Amjith Ramanujam   #video 
dump_fdw: A Foreign Data Wrapper for Postgres Dump Files
Provides the ability to query data directly from files in Postgres’ custom dump format. Currently a prototype that’s not recommended for production use.
MeetMe   #code 
Postgres Skills are in Demand - Add to your skill set and get certified
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.
EnterpriseDB    #sponsored 
Postgres's Publish-Subscribe Features Made Better with JSON
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.
Nathan Fritz
HOWTO Use JSON Functionality in PostgreSQL
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.
Umair Shahid
pg_rewind in PostgreSQL 9.5
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.
Heikki Linnakangas
Waiting for 9.5 – Add Support for Index-Only Scans in GiST
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.
Hubert depesz Lubaczewski
Django 1.7 Database Migrations Done Right
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.
Markus Holtermann
Reactive Postgres with Play Framework & ScalikeJDBC
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.
James Ward
Full Stack Developer at AlphaSights (New York, NY)
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.
AlphaSights    #job 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.