Re: Is my MySQL Gaining ?

A documentation system like the one over at http://php.net, would be 
fantastic for Postgresql. There could be lookups based on SQL commands, 
Functions, and Sitewide Searches. This alone would go a long way to 
expose PHP to "the masses".

In terms of using MySQL or Postgresql, lets all face it, most data 
storage work could be easily and efficiently handled by text files, 
since there needs to be just infrequent inserts and updates, and mostly 
reads. The majority of interfaces exposed on the web follow this 
paradigm, and include:
* Content management
* Catalogs
* Shopping cart stuff
* User management

Yes, our powerful and easy to use PG can do all of that too, but SQLite, 
Sleepycat DBM files and MySQL can do it as well. There are going to be 
even more migrations for Oracle to MySQL than from Oracle to PG, because 
so many of those Oracle installations were overkill in the first place. 
Our place is in that hoary back end that runs the world, the un-sexy 
part of any organization that no one outside of the Development team, or 
System Administrators know about.

Getting mindshare is a different problem. That requires PG to have a 
full time effective press person. This press person would need to be in 
touch with the press constantly to tell them things like:
* PG is a great back for windows clients using ODBC/MS Access/Excel
* PG is a "real" database comparable to Oracle
* PG costs nothing
* Free support is fabulous, and paid support is available
* Development is constant

In the end, I believe that PG needs to move into an organizational 
structure so that its considerable assets can be fully realized, its 
wonderful developers may be fully compensated, and commercial users (our 
bread and butter), can have an official place to help sponsor features 
of the system and so on. All this is more than a website. Someone posted 
pictures of the PG booth at a show recently. It was nice, but there was 
this one sad guy shrouded in darkness -- I felt depressed, because 
that's how PG advocacy felt.

Warm regards, 
Ericson Smith
DBA/Developer
+-----------------------+----------------------------+
| http://www.did-it.com | "When I'm paid, I always   |
| eric@did-it.com       | follow the job through.    |
| 516-255-0500          | You know that." -Angel Eyes|
+-----------------------+----------------------------+ 



Karsten Hilbert wrote:

>>I'm in a similar situation. My app is currently PG-only (although I 
>>_might_ be able to get it work with Firebird eventually). Currently I have 
>>to sell Linux to prospective clients in addition to my app. A native 
>>Windows version would make my life a bit easier.
>>    
>>
>Same here.
>
>Our "clients" use legacy medical office software that 99% runs
>on Windows. We offer add-ons (tailored mini-versions of our
>main application :-) and thus get OSS (Python, PostgreSQL,
>wxWindows, sometimes Linux itself) into their offices and onto
>their networks. Most of the time the main difficulty is to figure
>out how to offer PostgreSQL in their environment (yes, we know
>about CygWin).
>
>("clients" because we don't do business as in selling stuff)
>
>Karsten Hilbert, MD
>
>www.gnumed.org
>  
>