Thread: Re: [HACKERS] How can we expand PostgreSQL ecosystem?
On 07.03.2016 10:06, Tatsuo Ishii wrote: >> * Only 24 open source projects are listed as interoperable. >> Open Source Projects Using PostgreSQL >> https://wiki.postgresql.org/wiki/OpenSource_Projects_Using_PostgreSQL > > It's pity that some very popular OSS projects do not care about > PostgreSQL. WordPress is one of such OSS projects. Long time ago > someone came up with "PostgreSQL plugin" but it didn't catch up > WordPress releases and now cannot be used with the latest version of > WordPress. In my understanding WordPress fixes security issues only > with the latest version; as a result, we cannot use safe version of > WordPress if we want to use PostgreSQL for its database engine. But it is possible to add PostgreSQL support to many OSS projects, even if the are written just for MySQL. I did some work in greater projects to add an layer which adds support for SQLite. Most differences can be resolved dynamically. Also as a maintainer of FreeBSD there is another point i often notice: the user/maintainer is unaware of support of PostgreSQL. I've added a (optional) flag for PostgreSQL support to many software, so the user is able to used it. PostgreSQL is gaining attention, but that are some massive stoppers. I did start multiple times a project to translate the very fine manual into german, because many german developer just have problems with english. This is true for other languages too, so currently i'm trying to implement a translation plattform and not a translation itself. Another stopper is lack of comparison. Users want to make sure that everything works still fine on PostgreSQL and want to see what cool features they will gain on top. Or which problems they could solve. There was a website which compares MS SQL VS PostgreSQL and this was a great help for me. Greetings, Torsten
> From: pgsql-advocacy-owner@postgresql.org > [mailto:pgsql-advocacy-owner@postgresql.org] On Behalf Of Torsten > But it is possible to add PostgreSQL support to many OSS projects, even > if the are written just for MySQL. I did some work in greater projects to > add an layer which adds support for SQLite. Most differences can be resolved > dynamically. > > Also as a maintainer of FreeBSD there is another point i often notice: > the user/maintainer is unaware of support of PostgreSQL. I've added a > (optional) flag for PostgreSQL support to many software, so the user is > able to used it. Great. I'm glad to know such an activity. I'm also inclined to add support for PostgreSQL to popular software which bringsnew users to PostgreSQL. In that process, I anticipate that psqlODBC and PgJDBC will need to implement currently unsupportedstandard APIs (and possibly, the server too). I want to contribute to that, too. > Another stopper is lack of comparison. Users want to make sure that > everything works still fine on PostgreSQL and want to see what cool features > they will gain on top. Or which problems they could solve. > There was a website which compares MS SQL VS PostgreSQL and this was a great > help for me. So you suggested that some kind of comparison information will be necessary to help/convince software vendors, don't you? I'll keep that in mind. BTW, PGECons has been making documentation for migrating from other databases to PostgreSQL (the artifact is in Japaneseonly). Some informative pages are there: Comparison of relational database management systems https://www.google.co.jp/search?site=&source=hp&q=Comparison+of+relational+database+management+systems&oq=Comparison+of+relational+database+management+systems&gs_l=hp.3..0i19.4994636.4994636.0.4994948.5.5.0.0.0.0.334.928.0j3j1j1.5.0....0...1.1.64.hp..0.1.137.0.ESUA9_66uEQ Comparison of different SQL implementations http://troels.arvin.dk/db/rdbms/ Regards Takayuki Tsunakawa