---
title: "This Week's PostgreSQL News (#105)"
publication: "Postgres Weekly"
issue: 105
published_at: "2015-05-13"
canonical_url: "https://postgresweekly.com/issues/105"
---

Postgres Weekly 105   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 105 — May 13, 2015     

['Upsert' Lands in PostgreSQL 9.5 – A First Look](http://www.craigkerstiens.com/2015/04/11/upsert-lands-in-postgres-9.5/?utm_source=postgresweekly&utm_medium=email)Here’s a first look at ‘upsert’ (essentially a cute name for ‘create or update’), covering the basics of what it is as well as the syntax for using it. We’re a few months off from it being in a release, but at least now we know it’s coming. Craig Kerstiens [PostgreSQL Anti-Patterns: Unnecessary JSON](http://blog.2ndquadrant.com/postgresql-anti-patterns-unnecessary-jsonhstore-dynamic-columns/?utm_source=postgresweekly&utm_medium=email)JSONB and hstore are both awesome datatypes, but that doesn’t mean you should create a single table with one record and use Postgres as a JSON only store. This post guides you through some of the performance implications, and highlights when JSON is a good fit. Craig Ringer [Full Text Search in Milliseconds with PostgreSQL](https://blog.lateral.io/2015/05/full-text-search-in-milliseconds-with-postgresql/?utm_source=postgresweekly&utm_medium=email)Adding a basic, but performant full-text search to your application can be completely trivial with Postgres. Here’s a basic walkthrough along with some performance numbers. Max Novakovic [Telerik Developer Digest: A Bi-Weekly from Telerik Developer Network](http://digest.telerik.com/?utm_source=postgresweekly&utm_medium=email)As well as our own newsletters, we also publish them for other companies, such as Telerik. The Telerik Developer Digest includes the latest articles from the Telerik Developer Network and things from around the web that will interest Telerik users. [See today's issue here.](http://digest.telerik.com/issues/6) Telerik#sponsored [Slinky: Write Queries Through A Lightweight Web Interface](https://www.slinkydb.com/?utm_source=postgresweekly&utm_medium=email)If you’ve ever had anyone ask you to give you a report or extract, you’ve felt the pain of sharing data from a silo. Slinky aims to make this easier letting you write SQL, but then giving an easy mechanism for others to consume the results of that SQL. Slinky [PostgreSQL vs. MS SQL Server](http://www.pg-versus-ms.com/?utm_source=postgresweekly&utm_medium=email)A comparison of the two relational databases from the point of view of a data analyst. Matthew Byrne [Upsert Lands in Postgres 9.5](http://git.postgresql.org/gitweb/?p=postgresql.git&a=commit&h=168d5805e4c08bed7b95d351bf097cff7c07dd65&utm_source=postgresweekly&utm_medium=email)Upsert is here! Well… It will be available in Postgres 9.5, it’s now fully committed so there’s no question about if, it’s just when. Take a read through the commit here. postgresql.​org [DB Weekly: Our Weekly Database Technology Newsletter](http://dbweekly.com/issues/57?euid=*%7CUNIQID%7C*&utm_source=postgresweekly&utm_medium=email)DB Weekly covers general database trends, graph databases, NoSQL, tools, and more. [Issue 57](http://dbweekly.com/issues/57?euid=*|UNIQID|*) looked at RethinkDB, the Disque queue service, compression in MongoDB 3.0, and Microsoft's 'Azure Data Lake'. Cooper Press    

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