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 137 — December 30, 2015
FROM THE EDITOR

2015 was another great year for Postgres. We saw the release of Postgres 9.4 which included the famed JSONB. Logical decoding also laid a great foundation for improving Postgres' replication story.

We also saw an increase in tools and editors, including Postico, SQL Pro, and DB Beaver. And finally we have upsert committed in Postgres, though we'll have to wait for the 9.5 release to have our hands on it.

Craig Kerstiens,
Editor

My Top 10 Postgres Features and Tips for 2016
If you’re looking for some reading and studying up for the new year, here’s a collection of my favorite Postgres features and tricks. You won’t need all of them all of the time, but when you do need them they can be handy to have in your toolbox.
Craig Kerstiens
Postgres 9.5 - The Feature Rundown
The Postgres 9.5 release candidate is out, and while yes we’re all excited about upsert in Postgres it does contain much more than that. If you’re curious what you have to look forward to with the new release give this a read.
Craig Kerstiens
Scale Out Postgres for Real-Time Big Data Using CitusDB
CitusDB delivers real-time insights into your Big Data while reducing the cost and complexity of your database infrastructure and leverages your existing knowledge and applications. Supports structured or unstructured data and horizontally scales.
Citus Data    #sponsored 
A Christmas present: PostgreSQL 9.5 RC1
As we highlighted in this issue, Postgres 9.5 is getting close and has a lot of great features including upsert. If you want to get hands on with it, take a look at the release candidate, which is available now.
databasesoup.​com
Waiting for 9.6: Allow EXPLAIN (ANALYZE, VERBOSE) to Display Per-Worker Statistics
Parallel scans already landed for Postgres 9.6 and should give some great performance gains. Now you can also get the insights into what each worker is doing when a parallel scan runs with EXPLAIN.
Hubert depesz Lubaczewski
Is PostgreSQL Your Next JSON Database?
For those that haven’t been paying attention to JSON in Postgres and more recently JSONB in Postgres this post will catch you up on its history and how it now compares to other NoSQL solutions.
compose.​io
Multi-dimensional Clustering Using K-Means in Postgres SQL
K-means clustering can be an incredibly powerful way to look at your data, and you don’t have to boot up spark or load it into Python or R to run a k-means against your data. It can be done with SQL, albeit pretty gnarly SQL.
periscopedata.​com
DataGrip 1.0: A new IDE for Databases and SQL
Formerly 0xDBE, DataGrip is a new database-focused IDE from JetBrains (the creators of IntelliJ and WebStorm). It supports Oracle, SQL Server, DB2, Sybase, MySQL, Postgres, SQLite, Derby, HyperSQL and H2 out of the box.
JetBrains   #tools 
pgcenter: top-Like PostgreSQL Statistics Viewer.
Lesovsky Alexey   #code 
Postgres Skills are in demand.
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.
Indeed    #job 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.