Slashdot Mirror

← Back to Stories (view on slashdot.org)

PostgreSQL 9.5 Released

Posted by timothy on from the once-in-a-while dept.

iamvego writes: Later than the typical release cadence, PostgreSQL 9.5 has finally been released, and brings with it a slew of new features including UPSERT functionality, row-level security, and some big data features (CUBE/ROLLUP, join pushdown for foreign data wrappers, TABLESAMPLE, BRIN indexing and more). The previous release had brought about some new JSON functions and operators, but they only queried the data; 9.5 comes with new operators which now allow modification of JSON values, so it no longer has to be manipulated outside of the database. PostgreSQL's wiki has a more detailed overview of the new features.

3 of 104 comments (clear)

  1. Re: Love PostgreSQL by pak9rabid · · Score: 3, Insightful

    Because by default, MySQL does a bunch of stupid shit with your data?

  2. Re: Love PostgreSQL by Art3x · · Score: 4, Insightful

    Why not just use MySQL? It's free and PHP is built for it so you can run web applications on it.

    How is PHP built for MySQL? PHP isn't built for MySQL. PHP can use MySQL. In the same way, PHP can use PostgreSQL. And in the same way, you run web applications on it.

    I've been using PHP and PostgreSQL for dozens of web applications for over a decade.

  3. Skip Locked by djbckr · · Score: 3, Insightful

    I noticed one feature that will be extremely useful for managing queues is the SKIP LOCKED feature. I'm very pleased this made it into the release. I'll be testing performance on this.