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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
