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 105 — May 13, 2015
'Upsert' Lands in PostgreSQL 9.5 – A First Look
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
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
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
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.
Telerik    #sponsored 
Slinky: Write Queries Through A Lightweight Web Interface
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
A comparison of the two relational databases from the point of view of a data analyst.
Matthew Byrne
Upsert Lands in Postgres 9.5
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
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'.
Cooper Press
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.