All actively supported versions of Postgres just got a minor version release with some critical fixes for data corruption. If you haven’t already you should make sure to upgrade.
It might not be news to us as Postgres has long been a trusted database for our data, but due to its continuing growth in features and usability Postgres is starting to surpass MySQL as the preferred database by ‘the kids’ according to this editorial.
Sometimes complex orderings then calculations over data can be a bit complicated in SQL. Postgres 9.4 quietly brought a few new functions that make it more powerful and easier to iterate over groups of data for things like percentiles and more.
Citus Data provides open source and commercial solutions for scaling out PostgreSQL to empower real-time big data. View webinars on topics such as scaling out and fast analytics for big datasets. Read our new case study on solutions using PostgreSQL for real-time big data at MixRank.
PLV8, which lets you use the JavaScript V8 engine directly in Postgres, now has support for the JSONB datatype. This should allow you to take advantage of the latest JSON datatype along with full flexibility and power of JavaScript.
PostGIS, the best option for geospatial data, is under active development and a new version is coming. Feature freeze is planned for a few months from now and they’re expecting release this fall to be in line with Postgres 9.5. Take a look at some of the upcoming planned and committed features.
Following up from a post last week on the issues with Postgres as a queue, here’s an older talk about PgQ from Skype and how it works and met their needs.
