PostgreSQL 9.3 communicates well with others

The new version of the open source PostgreSQL database now comes with data wrappers that can both write and read data to other systems

For this year's annual update to PostgreSQL, the developers behind the open source database have added several new ways to communicate with other databases and data storage systems.

PostgeSQL's foreign data wrappers, which have been used since PostgreSQL 9.1 to read data from other systems, can now also be programmed to write data to non-PostgreSQL systems as well.

Such two-way data exchanges could help developers write programs that fuse multiple sources of data, both the structured data that PostgreSQL holds as well as semi-structured data stored on NoSQL systems.

For those who wish to bridge together two copies of the PostgreSQL itself, the development group has also released a federation driver that provides a speedier way to execute PostgreSQL-to-PostgreSQL data transactions.

Although perhaps not as well known as the MySQL open source database, PostgreSQL, also known as Postgres, has found work in many organizations, such as for Microsoft's Skype operations, Yahoo, Reddit, Facebook's Instagram, Sony and BASF. At least one company, EnterpriseDB, offers commercial support for the software.

Other features have been added to ease the developer's interactions with the database as well. The database's support for the JSON (JavaScript Simple Object Notation), a favored way to send and receive data to a Web application, has been expanded.

Developers can now create modules, called background workers, to help automate, stage and execute actions of applications using PostgreSQL. For instance, one worker that has already been created called Mongres reformats queries written for the MongoDB NoSQL data store so they can be understood by PostgreSQL.

Other new developer-friendly features for PostgreSQL 9.3 include automatically updatable views, lateral joins and a parallel copying routine, called pg_dump, to speed backups of large databases.

Improvements have also been made to further improve the reliability of the database. In a new feature called fast failover, PostgreSQL 9.3 can switch operations from the master database to the replica database in less than a second.

The database also can now run data page checksums to ensure data in the database has not been altered, which could provide evidence of failing hard disks.

Joab Jackson covers enterprise software and general technology breaking news for The IDG News Service. Follow Joab on Twitter at @Joab_Jackson. Joab's e-mail address is

Join the Good Gear Guide newsletter!

Error: Please check your email address.

Tags open sourceapplicationsdatabasessoftware

Our Back to Business guide highlights the best products for you to boost your productivity at home, on the road, at the office, or in the classroom.

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Joab Jackson

IDG News Service
Show Comments

Cool Tech

ASUS ROG Swift PG279Q – Reign beyond virtual world

Learn more >

Lexar® Professional 1000x microSDHC™/microSDXC™ UHS-II cards

Learn more >

D-Link PowerLine AV2 2000 Gigabit Network Kit

Learn more >

Crucial® BX200 SATA 2.5” 7mm (with 9.5mm adapter) Internal Solid State Drive

Learn more >

D-Link TAIPAN AC3200 Ultra Wi-Fi Modem Router (DSL-4320L)

Learn more >

Gadgets & Things

Lexar® Professional 1000x microSDHC™/microSDXC™ UHS-II cards

Learn more >

Lexar Professional 2000x SDHC™/SDXC™ UHS-II cards

Learn more >


Learn more >

Family Friendly

Lexar® Professional 1000x microSDHC™/microSDXC™ UHS-II cards

Learn more >

ASUS VivoPC VM62 - Incredibly Powerful, Unbelievably Small

Learn more >

Lexar Professional 2000x SDHC™/SDXC™ UHS-II cards

Learn more >

Stocking Stuffer

Lexar® Professional 1000x microSDHC™/microSDXC™ UHS-II cards

Learn more >

Lexar Professional 2000x SDHC™/SDXC™ UHS-II cards

Learn more >

Christmas Gift Guide

Click for more ›

Most Popular Reviews

Best Deals on Good Gear Guide

Latest News Articles


GGG Evaluation Team

Kathy Cassidy


First impression on unpacking the Q702 test unit was the solid feel and clean, minimalist styling.

Anthony Grifoni


For work use, Microsoft Word and Excel programs pre-installed on the device are adequate for preparing short documents.

Steph Mundell


The Fujitsu LifeBook UH574 allowed for great mobility without being obnoxiously heavy or clunky. Its twelve hours of battery life did not disappoint.

Andrew Mitsi


The screen was particularly good. It is bright and visible from most angles, however heat is an issue, particularly around the Windows button on the front, and on the back where the battery housing is located.

Simon Harriott


My first impression after unboxing the Q702 is that it is a nice looking unit. Styling is somewhat minimalist but very effective. The tablet part, once detached, has a nice weight, and no buttons or switches are located in awkward or intrusive positions.


Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?