Thread: Postgres Success Stories
Greetings All,
Do you use PostgreSQL ?
Do you love it ?
Do you want the world to know ?
If you answered yes to these questions, we want to hear about it.
E-mail info@pgsql.com, and tell us all about your installation of
PostgreSQL, and the success you've had with it.
This information will be used as part of the "success stories"
section on our web page. It helps both your company and PostgreSQL
get the notice they both deserve.
Best Regards,
Jeff MacDonald
=========================================================================
Jeff MacDonald // Hub.org Networking Services // PostgreSQL INC
jeff@hub.org // sales@hub.org // sales@pgsql.com
http://hub.org/~jeff // http://hub.org // http://pgsql.com
=========================================================================
On Wed, 9 Jun 1999, Jeff MacDonald wrote: > Date: Wed, 9 Jun 1999 14:57:07 -0300 (ADT) > From: Jeff MacDonald <jeff@hub.org> > Reply-To: Jeff MacDonald <info@pgsql.com> > To: pgsql-announce@postgreSQL.org > Subject: [ANNOUNCE] Postgres Success Stories 1. We use successfully for years (with great support from mailing list) postgreSQL @ http://www.appartment.ru/ - Join real estate database, Moscow Russia and http://www.mian.ru/ - MIAN - Moscow Investment Real-estate Agency. Both sites are in Top10 list in Real-Estate section of Top100 Rambler's (most valuable Russian rating service) list. Also, I use postgreSQL @ Sternberg Astronomical Institute http://www.sai.msu.su I'm working now on new project (Scientific News Agency) and also hope to use postgreSQL. 2. Yes 3. Yes Regards, Oleg > > Greetings All, > > Do you use PostgreSQL ? > Do you love it ? > Do you want the world to know ? > > If you answered yes to these questions, we want to hear about it. > E-mail info@pgsql.com, and tell us all about your installation of > PostgreSQL, and the success you've had with it. > > This information will be used as part of the "success stories" > section on our web page. It helps both your company and PostgreSQL > get the notice they both deserve. > > Best Regards, > Jeff MacDonald > > ========================================================================= > Jeff MacDonald // Hub.org Networking Services // PostgreSQL INC > jeff@hub.org // sales@hub.org // sales@pgsql.com > http://hub.org/~jeff // http://hub.org // http://pgsql.com > ========================================================================= > > _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
> Greetings All, > > Do you use PostgreSQL ? I personally don't, but the site I put together at Argonne Lab consistently draws hundreds of users a day, despite its rudimentary interface and almost absent documentation. That's quite a number, considering how specialized the database is: http://wit.mcs.anl.gov/EMP/ This site has also been cloned dozens of times. It's a database with almost no schema that is mainly used for retrieval. it consists of a number of simple index tables; the relations are formed on the fly by queries. It may, however, be of interest to the more general audience because it uses extended data types. > Do you love it ? I sympathize. > Do you want the world to know ? Yes. First, because I owe most of my success to the original and current postgres developers, as well as to the members of the list. Also, because I am worried about the future of my work. The development of custom types and access methods is definitely not in the focus of the popular demand. In the meanwhile, the needs of science are not completely satisfied. We still need a true floating point type that can represent ranges of values, which is required to store the results of measurements in a reasonable way. My own type, http://wit.mcs.anl.gov/EMP/seg-type.html, http://wit.mcs.anl.gov/EMP/seg-type.tgz, is just a successful attempt, and it needs to be further developed and kept in sync with the postgres code, for which I do not have time anymore. I would really love someone to pick it up. I would even argue that such a type is important enough to be one of the core types in postgres. That would allow it to fill the scientific niche as well, where I guess it hasn't so far had any competition at all. --Gene
> From: Jeff MacDonald <jeff@hub.org>
> Reply-To: Jeff MacDonald <info@pgsql.com>
> To: pgsql-announce@postgresql.org
> Subject: [ANNOUNCE] Postgres Success Stories
>
> Greetings All,
>
> Do you use PostgreSQL ?
> Do you love it ?
> Do you want the world to know ?
Jeff - will this suffice? If it is too terse I can flesh it out abit. ;-)
Social Workers are notoriously verbose...thank God for the text data type!
North Richmond Community Mental Health Center
---------------------------------------------
is the Department of Psychiatry at the Sisters of Charity Medical Center,
located in Staten Island, New York. We are a large department spanning
two campuses (St. Vincent's Campus, formerly St. Vincent's Medical Center
- and - Bayley Seton Campus - Formerly Bayley Seton Hospital.)
We provide a full continuum of care for the mentally ill and chemically
addicted persons of Staten Island. This includes emergency psychiatry
(our Comprehensive Psychiatric Emergency Program [ CPEP ]), inpatient
psychiatry for adults and adolescents, outpatient services, residential
services (housing for our clients with full case management services as
well as vocational opportunities and training), ambulatory services
(`day program' services), chemical and alcohol detoxification services,
alcohol and addiction ambulatory programs, a mobile crisis unit and
numerous other services all available to the people of Staten Island.
The department of Residential Services currently has a PROGRESS database
which provides clinical charting capabilities and administrative
functionality. This database is being ported to PostgreSQL. We expect
to go live 01 July 1999.
The Psych Research dept had a FoxPro database that tracked every patient
ever served at our facility - this was online 1986 - 1999.
In the past year we have migrated the FoxPro database to PostgreSQL 6.3.2.
It has been online for 9 months and has been very reliable.
Deployment followed a 6 month process of evaluating other vendors. Sybase,
Oracle, mSQL and mySQL were all evaluated as was Empress. The conclusion
reached was that Oracle was the best commercial database available and
that PostgreSQL was clearly the finest open source database on the market.
In comparison shopping I was the primary person testing both Oracle and
Postgres and found that Postgres compared favourably to Oracle. The
psql interface is very similar to SQL*Plus in functionality and Postgres
offers a comparable number of built in functions. Although Oracle possesses
some nice features not available in Postgres (for example the nvl() function)
we opted to go with Postgres for three reasons.
1) Compliance with ANSI standards: Oracle seems to lag way behind here.
2) Tech support offered by the Postgres mailing lists is superior to
any tech support I've encountered, contracted or otherwise.
3) The Open Source aspect of Postgres. Although we have little cause
to tinker with internals my shop is committed to Open Source. In as
much as we are publicly funded we feel it is our mandate to keep
our code in the public domain and to use open source code whenever
possible.
At the same time our shop began migrating away from proprietary databases
we began the process of moving away from proprietary Unix. UnixWare is
being phased out in favour of Slackware Linux and FreeBSD. However, it has
been necessary to install PostgreSQL on UnixWare as an interim measure.
In historical terms UnixWare has been something of a white elephant and
consequently has a counter-intuitive feel to it. It was necessary to ask
for some technical support from Bruce Momjian, a postgres developer with
System V expertise, to get postgres installed on UnixWare. I'm pleased
to report that the support was forthcoming and invaluable. Submitting the
same query to PROGRESS and Postgres on the UnixWare machine is a nice way
to demonstrate another feature of Postgres - the backend is relatively
quick. At least by comparison with a proprietary database.
At this point NR CMHC has PostgreSQL running and running well on UnixWare,
FreeBSD and Linux. In mission critical mode.
Finally, our PROGRESS database offers a 4GL that is supposed to make writing
code easier for someone like myself: I am not a `REAL PROGRAMMER.' All of
my formal training has been in psychiatry and social work. However, as a
Unix-SQL-Perl ENTHUSIAST, I was assigned the task of running our network
and the agency databases a few years ago. Thanks to the efforts of Edmund
Mergl who wrote and maintains the marvelous DBD::Pg module that allows me to
use Perl (via Tim Bunce's DBI module) I have found a viable replacement for
the PROGRESS 4GL. Thus I've been able to step in, port existing PROGRESS
code and move our applications and data to what I feel is the best SQL
database available.
North Richmond CMHC is currently integrating all of our databases (we have
4 postgres and one PROGRESS) into an inter-unit repository of patient data.
This is an ambitious project, however, PostgreSQL is the tool that is making
it possible. We invite inquiries on the process of migration to the
best, most advanced (an example - support for arrays) open source database
available.
Thomas Good, MIS Coordinator, North Richmond CMHC
Member: Computer Professionals For Social Responsibility
tomg@ { admin | q8 } .nrnet.org
Phone: 718-354-5528
Fax: 718-354-5056
Tom,
This is excellent, in fact I wish more ppl would express their success
in so much detail. Thank you.
Cheers,
Jeff MacDonald
On Thu, 10 Jun 1999, Thomas Good wrote:
> > From: Jeff MacDonald <jeff@hub.org>
> > Reply-To: Jeff MacDonald <info@pgsql.com>
> > To: pgsql-announce@postgresql.org
> > Subject: [ANNOUNCE] Postgres Success Stories
> >
> > Greetings All,
> >
> > Do you use PostgreSQL ?
> > Do you love it ?
> > Do you want the world to know ?
>
> Jeff - will this suffice? If it is too terse I can flesh it out abit. ;-)
> Social Workers are notoriously verbose...thank God for the text data type!
>
>
> North Richmond Community Mental Health Center
> ---------------------------------------------
>
> is the Department of Psychiatry at the Sisters of Charity Medical Center,
> located in Staten Island, New York. We are a large department spanning
> two campuses (St. Vincent's Campus, formerly St. Vincent's Medical Center
> - and - Bayley Seton Campus - Formerly Bayley Seton Hospital.)
>
> We provide a full continuum of care for the mentally ill and chemically
> addicted persons of Staten Island. This includes emergency psychiatry
> (our Comprehensive Psychiatric Emergency Program [ CPEP ]), inpatient
> psychiatry for adults and adolescents, outpatient services, residential
> services (housing for our clients with full case management services as
> well as vocational opportunities and training), ambulatory services
> (`day program' services), chemical and alcohol detoxification services,
> alcohol and addiction ambulatory programs, a mobile crisis unit and
> numerous other services all available to the people of Staten Island.
>
> The department of Residential Services currently has a PROGRESS database
> which provides clinical charting capabilities and administrative
> functionality. This database is being ported to PostgreSQL. We expect
> to go live 01 July 1999.
>
> The Psych Research dept had a FoxPro database that tracked every patient
> ever served at our facility - this was online 1986 - 1999.
> In the past year we have migrated the FoxPro database to PostgreSQL 6.3.2.
> It has been online for 9 months and has been very reliable.
>
> Deployment followed a 6 month process of evaluating other vendors. Sybase,
> Oracle, mSQL and mySQL were all evaluated as was Empress. The conclusion
> reached was that Oracle was the best commercial database available and
> that PostgreSQL was clearly the finest open source database on the market.
> In comparison shopping I was the primary person testing both Oracle and
> Postgres and found that Postgres compared favourably to Oracle. The
> psql interface is very similar to SQL*Plus in functionality and Postgres
> offers a comparable number of built in functions. Although Oracle possesses
> some nice features not available in Postgres (for example the nvl() function)
> we opted to go with Postgres for three reasons.
>
> 1) Compliance with ANSI standards: Oracle seems to lag way behind here.
> 2) Tech support offered by the Postgres mailing lists is superior to
> any tech support I've encountered, contracted or otherwise.
> 3) The Open Source aspect of Postgres. Although we have little cause
> to tinker with internals my shop is committed to Open Source. In as
> much as we are publicly funded we feel it is our mandate to keep
> our code in the public domain and to use open source code whenever
> possible.
>
> At the same time our shop began migrating away from proprietary databases
> we began the process of moving away from proprietary Unix. UnixWare is
> being phased out in favour of Slackware Linux and FreeBSD. However, it has
> been necessary to install PostgreSQL on UnixWare as an interim measure.
> In historical terms UnixWare has been something of a white elephant and
> consequently has a counter-intuitive feel to it. It was necessary to ask
> for some technical support from Bruce Momjian, a postgres developer with
> System V expertise, to get postgres installed on UnixWare. I'm pleased
> to report that the support was forthcoming and invaluable. Submitting the
> same query to PROGRESS and Postgres on the UnixWare machine is a nice way
> to demonstrate another feature of Postgres - the backend is relatively
> quick. At least by comparison with a proprietary database.
>
> At this point NR CMHC has PostgreSQL running and running well on UnixWare,
> FreeBSD and Linux. In mission critical mode.
>
> Finally, our PROGRESS database offers a 4GL that is supposed to make writing
> code easier for someone like myself: I am not a `REAL PROGRAMMER.' All of
> my formal training has been in psychiatry and social work. However, as a
> Unix-SQL-Perl ENTHUSIAST, I was assigned the task of running our network
> and the agency databases a few years ago. Thanks to the efforts of Edmund
> Mergl who wrote and maintains the marvelous DBD::Pg module that allows me to
> use Perl (via Tim Bunce's DBI module) I have found a viable replacement for
> the PROGRESS 4GL. Thus I've been able to step in, port existing PROGRESS
> code and move our applications and data to what I feel is the best SQL
> database available.
>
> North Richmond CMHC is currently integrating all of our databases (we have
> 4 postgres and one PROGRESS) into an inter-unit repository of patient data.
> This is an ambitious project, however, PostgreSQL is the tool that is making
> it possible. We invite inquiries on the process of migration to the
> best, most advanced (an example - support for arrays) open source database
> available.
>
> Thomas Good, MIS Coordinator, North Richmond CMHC
> Member: Computer Professionals For Social Responsibility
> tomg@ { admin | q8 } .nrnet.org
> Phone: 718-354-5528
> Fax: 718-354-5056
>
=========================================================================
Jeff MacDonald // Hub.org Networking Services // PostgreSQL INC
jeff@hub.org // sales@hub.org // sales@pgsql.com
http://hub.org/~jeff // http://hub.org // http://pgsql.com
=========================================================================
Tom,
This is perfect, in fact it's what I'm looking for, thanks
jeff.
On Thu, 10 Jun 1999, Thomas Good wrote:
> > From: Jeff MacDonald <jeff@hub.org>
> > Reply-To: Jeff MacDonald <info@pgsql.com>
> > To: pgsql-announce@postgresql.org
> > Subject: [ANNOUNCE] Postgres Success Stories
> >
> > Greetings All,
> >
> > Do you use PostgreSQL ?
> > Do you love it ?
> > Do you want the world to know ?
>
> Jeff - will this suffice? If it is too terse I can flesh it out abit. ;-)
> Social Workers are notoriously verbose...thank God for the text data type!
>
>
> North Richmond Community Mental Health Center
> ---------------------------------------------
>
> is the Department of Psychiatry at the Sisters of Charity Medical Center,
> located in Staten Island, New York. We are a large department spanning
> two campuses (St. Vincent's Campus, formerly St. Vincent's Medical Center
> - and - Bayley Seton Campus - Formerly Bayley Seton Hospital.)
>
> We provide a full continuum of care for the mentally ill and chemically
> addicted persons of Staten Island. This includes emergency psychiatry
> (our Comprehensive Psychiatric Emergency Program [ CPEP ]), inpatient
> psychiatry for adults and adolescents, outpatient services, residential
> services (housing for our clients with full case management services as
> well as vocational opportunities and training), ambulatory services
> (`day program' services), chemical and alcohol detoxification services,
> alcohol and addiction ambulatory programs, a mobile crisis unit and
> numerous other services all available to the people of Staten Island.
>
> The department of Residential Services currently has a PROGRESS database
> which provides clinical charting capabilities and administrative
> functionality. This database is being ported to PostgreSQL. We expect
> to go live 01 July 1999.
>
> The Psych Research dept had a FoxPro database that tracked every patient
> ever served at our facility - this was online 1986 - 1999.
> In the past year we have migrated the FoxPro database to PostgreSQL 6.3.2.
> It has been online for 9 months and has been very reliable.
>
> Deployment followed a 6 month process of evaluating other vendors. Sybase,
> Oracle, mSQL and mySQL were all evaluated as was Empress. The conclusion
> reached was that Oracle was the best commercial database available and
> that PostgreSQL was clearly the finest open source database on the market.
> In comparison shopping I was the primary person testing both Oracle and
> Postgres and found that Postgres compared favourably to Oracle. The
> psql interface is very similar to SQL*Plus in functionality and Postgres
> offers a comparable number of built in functions. Although Oracle possesses
> some nice features not available in Postgres (for example the nvl() function)
> we opted to go with Postgres for three reasons.
>
> 1) Compliance with ANSI standards: Oracle seems to lag way behind here.
> 2) Tech support offered by the Postgres mailing lists is superior to
> any tech support I've encountered, contracted or otherwise.
> 3) The Open Source aspect of Postgres. Although we have little cause
> to tinker with internals my shop is committed to Open Source. In as
> much as we are publicly funded we feel it is our mandate to keep
> our code in the public domain and to use open source code whenever
> possible.
>
> At the same time our shop began migrating away from proprietary databases
> we began the process of moving away from proprietary Unix. UnixWare is
> being phased out in favour of Slackware Linux and FreeBSD. However, it has
> been necessary to install PostgreSQL on UnixWare as an interim measure.
> In historical terms UnixWare has been something of a white elephant and
> consequently has a counter-intuitive feel to it. It was necessary to ask
> for some technical support from Bruce Momjian, a postgres developer with
> System V expertise, to get postgres installed on UnixWare. I'm pleased
> to report that the support was forthcoming and invaluable. Submitting the
> same query to PROGRESS and Postgres on the UnixWare machine is a nice way
> to demonstrate another feature of Postgres - the backend is relatively
> quick. At least by comparison with a proprietary database.
>
> At this point NR CMHC has PostgreSQL running and running well on UnixWare,
> FreeBSD and Linux. In mission critical mode.
>
> Finally, our PROGRESS database offers a 4GL that is supposed to make writing
> code easier for someone like myself: I am not a `REAL PROGRAMMER.' All of
> my formal training has been in psychiatry and social work. However, as a
> Unix-SQL-Perl ENTHUSIAST, I was assigned the task of running our network
> and the agency databases a few years ago. Thanks to the efforts of Edmund
> Mergl who wrote and maintains the marvelous DBD::Pg module that allows me to
> use Perl (via Tim Bunce's DBI module) I have found a viable replacement for
> the PROGRESS 4GL. Thus I've been able to step in, port existing PROGRESS
> code and move our applications and data to what I feel is the best SQL
> database available.
>
> North Richmond CMHC is currently integrating all of our databases (we have
> 4 postgres and one PROGRESS) into an inter-unit repository of patient data.
> This is an ambitious project, however, PostgreSQL is the tool that is making
> it possible. We invite inquiries on the process of migration to the
> best, most advanced (an example - support for arrays) open source database
> available.
>
> Thomas Good, MIS Coordinator, North Richmond CMHC
> Member: Computer Professionals For Social Responsibility
> tomg@ { admin | q8 } .nrnet.org
> Phone: 718-354-5528
> Fax: 718-354-5056
>
>
=========================================================================
Jeff MacDonald // Hub.org Networking Services // PostgreSQL INC
jeff@hub.org // sales@hub.org // sales@pgsql.com
http://hub.org/~jeff // http://hub.org // http://pgsql.com
=========================================================================
On Thu, 10 Jun 1999, Jeff MacDonald wrote:
> Tom,
> This is perfect, in fact it's what I'm looking for, thanks
>
> jeff.
Cheers Jeff - Glad to be able to help! I'll have a look at the
web site a bit later.
Tom
> On Thu, 10 Jun 1999, Thomas Good wrote:
>
> > > From: Jeff MacDonald <jeff@hub.org>
> > > Reply-To: Jeff MacDonald <info@pgsql.com>
> > > To: pgsql-announce@postgresql.org
> > > Subject: [ANNOUNCE] Postgres Success Stories
> > >
> > > Greetings All,
> > >
> > > Do you use PostgreSQL ?
> > > Do you love it ?
> > > Do you want the world to know ?
> >
> > Jeff - will this suffice? If it is too terse I can flesh it out abit. ;-)
> > Social Workers are notoriously verbose...thank God for the text data type!
> >
> >
> > North Richmond Community Mental Health Center
> > ---------------------------------------------
[ snip ... ]
------- North Richmond Community Mental Health Center -------
Thomas Good MIS Coordinator, Senior DBA
Vital Signs: tomg@ { admin | q8 } .nrnet.org
Phone: 718-354-5528
Fax: 718-354-5056
/* Member: Computer Professionals For Social Responsibility */