Please take part in the PostgreSQL ecosystem survey - Mailing list pgsql-advocacy

We are announcing the start of PostgreSQL ecosystem survey.  By filling out the following survey form, please let us
knowwhat software you need in order to adopt PostgreSQL in wider range.  The form comprises three questions:
software/usage/industrycategory, a specific software, and a free comment on the interoperability issue of the software.
Your request will encourage us to improve the interoperability of PostgreSQL to make more software available with
PostgreSQL.

Survey form
https://docs.google.com/forms/d/1Ueq4Z9MYJLv-gCp_UrPXENdSH6jXtqR0zz5F1W3Qqvo/viewform

You can see the survey result in real time in the spreadsheets below.

Survey response sheets
https://docs.google.com/spreadsheets/d/1sxd--agLVrFbn7M3YCqFTR812MrBExiyAM_4qVf9trk/pubhtml

We really appreciate your cooperation.  Thanks.

Community discussion
http://www.postgresql.org/message-id/471DBBEFA9CD4C26B83E7FAEDCB7482B@tunaPC



BACKGROUND
============================================================

Thanks to the long and hard effort by the community, PostgreSQL has been evolving to be a really great software
comparableto existing strong commercial products.  According to the following article, open source databases are
gainingmore popularity enough to influence the database market. 

Open source threatens to eat the database market
http://www.infoworld.com/article/2916057/open-source-software/open-source-threatens-to-eat-the-database-market.html

[Excerpt]
"Though the proprietary RDBMS market grew at a sluggish 5.4 percent in 2014, the open source database market grew 31
percentto hit $562 million." 
"As Gartner highlights in a recent research report, open source databases now consume 25 percent of relational database
usage."

On the other hand, there is a gulf between the two top popular databases -- Oracle and MySQL -- and PostgreSQL.  They
arenearly five times more popular than PostgreSQL. 

DB-Engines Ranking
http://db-engines.com/en/ranking

Yes, I understand this ranking doesn't necessarily reflect the actual use, but I also don't think the ranking is far
fromthe real popularity. 


PROBLEM: INSUFFICIENT AND/OR UNKNOWN INTEROPERABILITY
============================================================

What will be necessary for more users to use PostgreSQL?  One challenge is interoperability, or ecosystem in other
words,which is to increase the number of software which supports PostgreSQL.  To take advantage of the trend of shift
fromcommercial products to open source, PostgreSQL needs to interoperate with many software that are used together with
thecommercial databases. 

The easily understandable target is Oracle, because it is anticipated that more users of Oracle will seek another
databaseto avoid the expensive Oracle Standard Edition 2 and increasing maintenance costs.  In addition, PostgreSQL has
affinityfor Oracle. 

However, there is a problem.  The number of software is very small that the users can know to interoperate with
PostgreSQL. That is, when the users want to migrate from commercial databases to PostgreSQL, they can't get information
onwhether they can continue to use their assets with PostgreSQL.  Many applications might be interoperable through
standardinterfaces like JDBC/ODBC, but the case is unknown.  For example: 

* Only 24 open source projects are listed as interoperable.
  Open Source Projects Using PostgreSQL
  https://wiki.postgresql.org/wiki/OpenSource_Projects_Using_PostgreSQL

* About 120 products are listed in the "Software Catalog" (excluding the ones like PostgreSQL extensions).  But the
numberwould drop down to about 100 if the members of the same product family are counted as one. 
  http://www.postgresql.org/download/products/5-reporting-tools/

* Even EnterpriseDB has only 12 certified application vendors.
  http://www.enterprisedb.com/partner-programs/enterprisedb-certified-application-vendors

* PostgreSQL Enterprise Consortium lists only about30 related products (Japanese only).
  https://www.pgecons.org/postgresql-info/business_sw/

* MySQL touts more than 2,000 ISV/OEM/VARs.
  http://www.mysql.com/oem/

Besides, in practice, more development efforts will probably be necessary to make PostgreSQL more interoperable with
manysoftware products.  For example, one customer asked me whether Arcserve can be used to back up PostgreSQL
databases,but unfortunately I had to answer no. 


ACTION: VISUALIZE AND IMPROVE INTEROPERABILITY
============================================================

At the steering committee of PostgreSQL Enterprise Consortium (PGECons), I proposed starting the following activity.
PGEConsis a Japanese non-profit organization to promote PostgreSQL for enterprise use.  The members include NTT, SRA
OSS,Inc. (Tatsuo Ishii runs), NEC, Hitachi, HP, Fujitsu (my company), etc.  The committee concluded that we need to
workin cooperation with the PostgreSQL community. 

* Attract and ask product/service vendors to support/use PostgreSQL.  Provide technical assistance to those vendors as
anorganization so that they can support PostgreSQL smoothly.  If the vendors aren't proactive, we verify the
interoperabilitywith their software by executing it. 

* Make a directory of software/services that can be used with PostgreSQL on the community web site (wiki.postgresql.org
orwww.postgresql.org).  Software/services vendors and PostgreSQL developers/users can edit this directory.  This list
notonly has the names of software and its vendors, but also other information such as the level of interoperability
(certifiedby the vendor, or verified by the community/users) and remarks about configuration, tuning, and whatever
usefulfor users.  

PostgreSQL Enterprise Consortium (PGECons)
https://www.pgecons.org/en


Regards
Takayuki Tsunakawa