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

Postgres Weekly 146   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 146 — March 2, 2016     

[Hands On Postgres Sharding](http://www.craigkerstiens.com/2016/02/28/Hands-on-postgres-sharding/?utm_source=postgresweekly&utm_medium=email)A more practical, in-depth followup to an earlier [post about sharding](http://www.craigkerstiens.com/2012/11/30/sharding-your-database/) that walks you through getting set up and running with Citus Data’s pg_shard. Craig Kerstiens [Generating URL-Safe Short IDs in Postgres](https://blog.andyet.com/2016/02/23/generating-shortids-in-postgres/?utm_source=postgresweekly&utm_medium=email)Using serial or integer IDs as a primary key isn’t always the best choice due to data leakage and scaling issues, so unique IDs may be preferred. Here’s an alternative to UUIDs that’s a bit cleaner visually. Nathan Fritz [PGConf Silicon Valley PostgreSQL Conference (Nov 14-16)](http://www.pgconfsv.com/?utm_source=postgresweekly&utm_medium=email)PGConf Silicon Valley is happening again this year. Last year there were [some excellent talks](http://www.pgconfsv.com/2015/videos) and this year should be no different. PGConf Silicon Valley#news [5 Questions for Finding the Right Postgres Services Partner](http://www.enterprisedb.com/postgres-plus-edb-blog/matt-cicciari/5-questions-finding-right-services-partner?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016Mar5QsBlog)Rolling out and managing a database can bring new challenges for an organization. Outside help can optimize results to achieve a maximum return on investment. Learn five key questions to ask about evaluating and selecting service providers to support new Postgres deployments. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/28278220.png)](http://www.enterprisedb.com/postgres-plus-edb-blog/matt-cicciari/5-questions-finding-right-services-partner?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016Mar5QsBlog) [PostgreSQL Indexes: First Principles](http://eftimov.net/postgresql-indexes-first-principles?utm_source=postgresweekly&utm_medium=email)Indexes are key to improving performance of queries against your database. This great intro gives you a nice overview, and a little hands on, of the principles behind them. Ilija Eftimov [JSONB and PostgreSQL: Work Faster By Ditching Migrations](http://rob.conery.io/2016/02/27/jsonb-and-postgresql/?utm_source=postgresweekly&utm_medium=email)Having a clearly defined schema is always optimal, but sometimes a schema isn’t initially so obvious to define. JSONB can give you a lot of flexibility when you need to iterate quickly. Rob Conery [Datazenit 1.0: A Web-based Database Administration Tool](https://datazenit.com/blog/2016/03/1/datazenit-official-release/?utm_source=postgresweekly&utm_medium=email)If psql isn’t quite your flavor when it comes to a client interface for Postgres, Datazenit might work for you. It’s a clean web-based client for interacting with your database and the 1.0 release packs a number of nice features. Datazenit [A Plain Text List of Great Talks At PGCon](http://www.pgcon.org/2016/ugly-list-of-great-talks.txt?utm_source=postgresweekly&utm_medium=email)[PGCon](https://www.pgcon.org/2016/) is just around the corner and the list of talks is in. While not the prettiest visual presentation the content of the talks themselves looks to be top notch. PGCon [Django 1.9's Improvements for Postgres](https://blog.heroku.com/archives/2016/2/24/django_1_9_s_improvements_for_postgres?utm_source=postgresweekly&utm_medium=email)A big update to the beloved Python web framework was released recently: Django 1.9. It includes a few Postgres related improvements. Heroku [pgclimb: Export Data From PostgreSQL Into Different Data Formats](https://github.com/lukasmartinelli/pgclimb?utm_source=postgresweekly&utm_medium=email)A handy utility to make it easy to export data from PostgreSQL into your desired format (including JSON, JSON Lines, CSV, XLSX, and XML). Lukas Martinelli#code [Chain works with Visa/Nasdaq to digitize money & you'll never guess which RDBMS we use](https://jobs.lever.co/chain/1a22df50-4600-4ea2-80ce-89853bad056c)Come work with us as we rethink the tech stack for financial services. We need folks who are experts in database systems and are eager to make a big impact. Chain.​com#job [Postgres Skills are in demand](http://www.indeed.com/prime?sid=xp_cooperpress&kw=postgres)Indeed Prime is an elite new program from Indeed.com that presents in-demand tech talent like you to top employers. Indeed Prime opens the door to exciting career opportunities with one simple application. [Join today.](http://www.indeed.com/prime?sid=xp_cooperpress=postgres) Indeed.​com#job    

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