9 SEPTEMBER 2013: 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.
"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's well-known reliability and availability:
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:
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 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 PostgreSQL.org.
For explanations of the above features and others, please see the following resources:
HTML documentation and man pages are installed with PostgreSQL, but feel free to browse, search and comment on our extensive, interactive online documentation.
PostgreSQL uses the PostgreSQL License, a BSD-like "permissive" license. This OSI-certified license is widely appreciated as flexible and business-friendly, since it does not restrict the use of PostgreSQL with commercial and proprietary applications. Together with multi-company support and public ownership of the code, our license makes PostgreSQL very popular with vendors wanting to embed a database in their own products without fear of fees, vendor lock-in, or changes in licensing terms.
English-Language Press Inquiries
USA, Canada and General Inquiries
PostgreSQL Press Team
Phone: +1 (347) 674-7759
+353 (0)87 2241365
+61 43 44 00 000
"PostgreSQL 9.3 provides features that as an app developer I can use immediately: better JSON functionality, regular expression indexing, easily federating databases with the Postgres foreign data wrapper - much like the previous releases of Postgres, I have no idea how I completed projects without 9.3," said Jonathan S. Katz, CTO VenueBook
VenueBook is a cloud-based event management solution that helps manage the whole event cycle in one place. We provide software that enables venue managers to prepare and approve contracts, menus, and process payments all online. Unlike other systems on the market that just help you manage events, we also streamline the interaction and booking with the planner. Contact (English only): firstname.lastname@example.org, +1 646-543-8368CloudFlare
"CloudFlare is proud to number PostgreSQL 9.3 among our chest of tools to deliver acceleration and security to millions of websites. It provides the extensibility and customizability we need to be agile and scalable at the data layer. Writable foreign data wrappers in particular enable us to plug in and seamlessly test various backend alternatives, allowing us to address different needs quickly and prototype intelligently. 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."
"Coupling foreign data wrappers with the notion of material views and lateral joins for querying; and custom background workers for monitoring, yields PostgreSQL as a truly powerful harness that we intend to use and grow with. CloudFlare is thrilled to have this gem in our toolkit," said Lee Holloway, Co-founder and Lead Engineer at CloudFlare.
CloudFlare, Inc. makes sites twice as fast, protects them from attacks, ensures they are always online, and makes it simple to add web apps with a single click. CloudFlare supercharges websites regardless of size or platform with no need to add hardware, install software, or change a line of code. The CloudFlare community gets stronger as it grows; every new site makes the network smarter. Thanks to our awesome sauce technology, every month hundreds of millions of people experience a faster, safer, better Internet. CloudFlare was recognized by the World Economic Forum as a Technology Pioneer, named the Most Innovative Network and Internet Technology Company of the Year for 2011 and 2012 by the Wall Street Journal, and ranked among the world's 50 most innovative companies of 2012 by Fast Company. CloudFlare is based in San Francisco, California, USA. Contact (English only): email@example.com, +1 (650) 485-1399Gandi.net
"We are following replication and are very interested in the recent improvements to this feature. I'm especially excited to hear more about the fast failover coming in 9.3. We've been using postgresql for the Gandi IAAS/PAAS platform and recently internally, to build one of our live systems that stores/computes/outputs millions rows daily, very easily."
"Postgres has been my favorite choice for its well known stability/robustness/strong coherency/safety/ACID and SQL conformance. Now that it's getting modern, making good use of the OS, we are seeing huge performance improvements and more ease of administration for failsafe setup. It's just the best mission critical relational db available out there," said Pascal Bouchareine, Director of Research and Development at Gandi.
GANDI.net was one of the first domain name registrars approved by ICANN for .COM, .NET,.ORG, .BIZ, .INFO, .NAME, .BE, .FR, .EU domains in France. It now offers over 200 domain extensions and continues to add to this list on a regular basis. Gandi considers itself to be an ethical domain name registrar in an industry that has some 'grey' practices. It values the customers rights and privacy above all else and seeks todefend these wherever possible. Contact in English: Thomas Stocking, in French: Nicolas Lhuillery. Phone: +1 410.429.7402.
PostgreSQL enjoys the support of numerous companies, who sponsor developers, provide hosting resources, and give us financial support. See our sponsors page for some of these project supporters.
There is also a large community of companies offering PostgreSQL Support, from individual consultants to multinational companies.
Donations gladly accepted.