Let's create web applications simply !

Alinous-Core for PostgreSQL Topics

Subscribe to Alinous-Core for PostgreSQL Topics: eMailAlertsEmail Alerts newslettersWeekly Newsletters
Get Alinous-Core for PostgreSQL Topics: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Alinous-Core for PostgreSQL Authors: Tomohiro Iizuka

Related Topics: Open Source Journal, CIO/CTO Update, The Social Media Guide, Alinous-Core for PostgreSQL Topics

Alinous-Core for PostgreSQL: News Feed Item

PostgreSQL 9.3 Released: Data Federation and Reliability

Latest version adds heterogeneous data federation, increases reliability, and includes new developer features.

NEW YORK, Sept. 9, 2013 /PRNewswire-iReach/ -- The PostgreSQL Global Development Group announces the release of PostgreSQL 9.3, the latest version of the world's leading open source relational database system.  This release expands PostgreSQL's reliability, availability, and ability to integrate with other databases.  Users are already finding that they can build applications using version 9.3 which would not have been possible before.

(Photo: http://photos.prnewswire.com/prnh/20130909/MN75237)

"PostgreSQL 9.3 provides features that as an app developer I can use immediately: better JSON functionality, regular expression indexing, and easily federating databases with the Postgres foreign data wrapper. I have no idea how I completed projects without 9.3," said Jonathan S. Katz, CTO of VenueBook.

Writable External Data

Version 9.3 makes PostgreSQL's Foreign Data Wrappers writable, enabling two-way data interchange between systems.  Today's complex IT environments involve multiple databases and semi-structured data sources, and PostgreSQL helps you integrate them into a coherent stack.  The project has also released postgres_fdw, a higher-performance, read/write PostgreSQL-to-PostgreSQL federation driver.

"Writable foreign data wrappers enable us to plug in and seamlessly test various backend alternatives, allowing us to address different needs quickly and prototype intelligently," explained Lee Holloway, Co-founder and Lead Engineer at CloudFlare. "It is exciting to conceive and toss up new data stores (including our in-house experimental ones written in Go) and then watch them read, write, and even transact each other."

Enhanced Reliability and Availability

"Postgres has been my favorite choice for its well known stability, robustness, strong coherency, safety, ACID, and SQL conformance," said Pascal Bouchareine, director of research and development at Gandi.net. "I'm especially excited to hear more about the fast failover coming in 9.3."

This new release includes features to further improve and extend PostgreSQL'swell-known reliability and availability:

* Data Page Checksums: help administrators quickly detect failing disks
  and bad hardware that corrupts data
* Fast Failover: enables sub-second switchoffs from master to replica,
  supporting "carrier-grade" availability
* Streaming-Only Remastering: easier, faster reconfiguration of
  cascading replicas after failover

Developer-friendly Features

As with every annual release, PostgreSQL 9.3 includes many features to make working with PostgreSQL easier, more flexible and more fun for application developers, administrators and architects.  These features include:

* Additional JSON constructor and extractor methods
* Automatically updatable VIEWs
* Parallel pg_dump to speed backups of large databases

Further, PostgreSQL 9.3's User-Defined Background Workers allow developers to write task managers, request handlers, parallel processors, queuing tools and other helper applications to enable PostgreSQL as a workload coordinator.  One example of this already released is Mongres, a background worker which accepts MongoDB queries, interprets them and passes them on to PostgreSQL.


PostgreSQL Press Team
[email protected]
+1 (347) 674-7759
San Francisco & New York


* Downloads:
* Press Kit:
* Release Notes:
* What's New in 9.3:

About PostgreSQL

PostgreSQL is the leading open source database system, with a global community of thousands of users and contributors and dozens of companies and organizations.  The PostgreSQL Project builds on over 25 years of engineering, starting at the University of California, Berkeley, and has an unmatched pace of development today. PostgreSQL's mature feature set not only matches top proprietary database systems, but exceeds them in advanced database features, extensibility, security and stability.  Learn more about PostgreSQL and participate in our community at: http://www.postgresql.org.

Media Contact: PostgreSQL Press Team, PostgreSQL Project, +1 (347) 674-7759, [email protected]

News distributed by PR Newswire iReach: https://ireach.prnewswire.com

SOURCE PostgreSQL Project

More Stories By PR Newswire

Copyright © 2007 PR Newswire. All rights reserved. Republication or redistribution of PRNewswire content is expressly prohibited without the prior written consent of PRNewswire. PRNewswire shall not be liable for any errors or delays in the content, or for any actions taken in reliance thereon.