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.

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.

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.

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.

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.

A comparison of the two relational databases from the point of view of a data analyst.

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.

DB Weekly covers general database trends, graph databases, NoSQL, tools, and more. Issue 57 looked at RethinkDB, the Disque queue service, compression in MongoDB 3.0, and Microsoft's 'Azure Data Lake'.