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 222/2019
Buy this issue as a PDF
News
-
Black Hole Image Has an Open Source Connection
Two imaging libraries responsible for the image are fully open source.
-
Linux Mint Founder Calls for Better Developer Support
Usually cheerful Clement ‘Clem’ Lefebvre says he "hasn't enjoyed" this development cycle.
-
Software Freedom Conservancy Announces End to VMware Lawsuit
VMware agrees to remove the offending code in a future release.
-
Chef Goes All Open Source
The company behind the popular DevOps automation tool is releasing those proprietary add-ons built around the open source core.
-
SUSE Spins off from Parent Company
While IBM has acquired Red Hat, SUSE goes solo.
-
Gnome 3.32 Released
New release of the Gnu desktop comes with many improvements.
-
VMware Rolls Out Essential PKS
Virtualization vendor brings commercial support to upstream Kubernetes.
-
Linux 5.0 Is Here
Linus says don't get excited, but the new release contains some significant updates.
-
Kali Linux 2019.1 Released
The favorite Linux distro of Mr. Robot gets the first update of 2019.
-
Linux Foundation Releases a New Draft of OpenChain Spec
OpenChain provides a standard for open source compliance throughout the software supply chain.