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 107 — May 27, 2015
PostgreSQL 9.4.2, 9.3.7, 9.2.11, 9.1.16, and 9.0.20 Released
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.
postgresql.​org
Postgres Pushes Past MySQL in Developers' Hearts
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.
TechRepublic
The WITHIN GROUP and FILTER SQL clauses of PostgreSQL 9.4
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.
2nd Quadrant
Empowering Real-Time Big Data Using PostgreSQL
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.
Citus Data    #sponsored 
PLV8 now has JSONB support
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.
plv8   #code 
PostGIS 2.2 Leveraging Power of PostgreSQL 9.5
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.
Leo Hsu and Regina Obe
Think Twice, Join Once: Distinct On in PostgreSQL
Noel Herrick   #tutorial 
SQL MERGE Is Quite Distinct From UPSERT
Why is Postgres pursuing a non-standard variant of UPSERT rather than SQL’s MERGE? A developer explains why: they’re quite different things.
Peter Geoghegan   #opinion 
Skytools: PgQ Queues and applications
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.
Slideshare
Why Auto Increment Is A Terrible Idea
Clément Delafargue   #opinion 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.