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