|PostgreSQL 9.3 Released|
|Written by Kay Ewbank|
|Wednesday, 11 September 2013|
The latest version of the PostgreSQL open source relational database system has been released with improved JSON support, regular expression indexing, and writeable foreign data wrappers.
The changes to the Foreign Data Wrappers (FDW) mean you can exchange data with alternative back end data stores both for reading and writing. The wrappers let you integrate external data sources with internal data. FDW data sources look like any other database table to users. Earlier versions were read only.
Lateral Join support has also been added. This means that if you write a query where you specify columns in the FROM clause, you can then write a subquery that references those columns.
One interesting addition is a concept called User-Defined Background Workers. This lets you develop modules that register themselves as "background worker processes", so effectively operating as customized server processes. You could use this to monitor server activity, or to write your own task managers, request handlers, parallel processors or queuing tools. The idea is that you can then use PostgreSQL as a workload coordinator, and the release notes say that an example of this has already been released in the form of Mongres, a background worker that accepts MongoDB queries, interprets them and passes them on to PostgreSQL.
To be informed about new articles on I Programmer, install the I Programmer Toolbar, subscribe to the RSS feed, follow us on, Twitter, Facebook, Google+ or Linkedin, or sign up for our weekly newsletter.
or email your comment to: firstname.lastname@example.org
|Last Updated ( Friday, 04 October 2013 )|