PGXN, the PostgreSQL Extension network, is a central distribution system for open-source PostgreSQL extension libraries. It consists of four basic parts:
- PGXN Manager
- An upload and distribution infrastructure for extension developers.
- PGXN API
- A centralized index and API of distribution metadata.
- PGXN Search
- This site, for searching extensions and perusing their documentation.
- PGXN Client
- A command-line client for downloading, testing, and installing extensions.
The network currently consists of:
- 191 Extensions
- 170 Distributions
- 680 Releases
- 208 Users
- 469 Tags
- 5 Mirrors
One of the primary distinguishing features of PostgreSQL—and perhaps the number one reason to use it instead of another DBMS—is its extensibility and the large number of database extensions already available: PostGIS, ISN, hstore, pgTAP, BioPostgres, PL/R, PL/Proxy, Golconde, pgmemcache, and more. Especially with the formal support for extensions coming in 9.1.0, PostgreSQL today is not merely a database, it’s an application development platform. However, many of these extensions are virtually unknown even among experienced users because they are hard to find.
PGXN solves the “hard to find” issue by providing centralized listings and searchable documentation for PostgreSQL extensions. Here you can easily search through extensions, browse their documentation, and download and install those that fill your needs. The site is structured to maximize the ability to find appropriate extensions and their documentation through search engines. Our hope is that the high visibility of PostgreSQL’s extensibility and the array of available extensions will drive PostgreSQL adoption by new users and application developers, expanding our community and ensuring another 10 years of the PostgreSQL Project.
Who’s Responsible for This?
Thanks to our terrific donors, I am. I’m David Wheeler, inveterate Perl and PostgreSQL hacker. I love the extensibility of PostgreSQL and have long been a fan of CPAN, the Perl community’s distributed collection of Perl software and documentation. But PostgreSQL’s extensibility is not well-known, and it’s difficult to find the extensions that do exist. PGXN is my attempt to solve that problem.