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

By , IDG News Service |  Software

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.

Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+

Answers - Powered by ITworld

ITworld Answers helps you solve problems and share expertise. Ask a question or take a crack at answering the new questions below.

Ask a Question
randomness