PostgreSQL 8.4 Proves Feature-Rich
The free database system PostgreSQL is available in version 8.4 with numerous new features and enhancements.
The PostgreSQL Group counts 293 enhancements for its 8.4 release over its predecessor. Among the most important is Parallel Restore, with up to eight times faster backup file restoration, which can apply to 8.2 and 8.3 backups as well. As far as database security, column-level permissions can now be set along with the table itself.
The sorting methods (character collations) can be set by database apart from at installation, a welcome feature for multilingual environments. A few new monitoring features will also be helpful for large enterprise environments.
The query language was enhanced through advanced features of the SQL 2003 ANSI standard, such as aggregate operations through windowing. Common table expressions allowing named subqueries and recursive joins also reduce queries to far fewer than previously required.
An overview of the PostgreSQL 8.4 feature enhancements is available as a list or a matrix comparing it to the previous five releases.
PostgreSQL is ready for download under a BSD license. Apart from the source code, there are binary packages for 32-bit and 64-bit Intel CPUs, with specific distro packages also in the offering.
Issue 216/2018
Buy this issue as a PDF
News
-
Redis Labs Modules Forked
New Commons Clause license rider causes Debian and Fedora developers to fork Redis Labs modules.
-
Microsoft Offers its Patent Portfolio
The company ends its long war; vows to protect Linux.
-
Red Hat Reports $823 Revenue for Second Quarter 2019
Strong performance for cloud and container products leads to a 14% increase over last year.
-
Debian, Ubuntu, and Other Distros are Leaving Users Vulnerable
A security researcher says Linux vendors wait too long to patch the kernel.
-
NextCloud 14 Arrives
The new version adds two new security features for users.
-
Linus Torvalds Takes a Break, Apologizes
The creator of Linux is admitting his abusive behavior on LKML and plans to change.
-
A New Business Model for Open Source Projects
Storj offers a new program that enables open source projects to monetize from storage.
-
Linux Mint Debian Edition 3 Released
It’s Linux Mint without any Ubuntu base packages.
-
Zorin OS 12.4 Released
It’s an extremely popular distribution among Windows and macOS users.
-
Debian Celebrates Its Birthday
The great community Linux distro turns 25 years old.