What are your using it for?

rcook@Bix.Com wrote:

I'm working a piece on open-source databases for LinuxWorld magazine and
I'd like to know what people are actually using postgresql for.

I'm using it for mission-critical intranet applications in our broadcast
radio station, backing the AOLserver webserver. I am also using it
(developing, right now) for a community website using the ACS/pg
software toolkit (acspg.benadida.com, www.arsdigita.com).

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

rcook@Bix.Com wrote:

I'm working a piece on open-source databases for LinuxWorld magazine and
I'd like to know what people are actually using postgresql for.

--Rick Cook
rcook@bix.com

I am using it as for self-educational purposes : general database theory,
normalisation, writing applications in several languages : Tcl/Tk for
front-ends, PL/pgSQL for triggers and datamodel analysis.

Jurgen Defurne
defurnj@glo.be

We have a large departmental database that contains lots of historical
information on students, alumni, faculty, and affiliated scholars that I'm
in the process of porting away from Access. Frontend is Perl/Tk and CGI.

ap

---------------------------------------------------------------------
Andrew J. Perrin - aperrin@demog.berkeley.edu - NT/Unix Admin/Support
Department of Demography - University of California at Berkeley
2232 Piedmont Avenue #2120 - Berkeley, California, 94720-2120 USA
http://demog.berkeley.edu/~aperrin --------------------------SEIU1199

On Tue, 18 Apr 2000 rcook@bix.com wrote:

I'm working a piece on open-source databases for LinuxWorld magazine and
I'd like to know what people are actually using postgresql for.

We are using it for financial applications. Both as store for trading data
(in one database we have well over 2-million data points for daily trading
data) and as back-end for our (private) web servers. These are both for our
own use and increasingly for our customers. We run Digital Unix, and postgres
runs on a 2-processor DS-20. For a small organisation Oracle is just too
expensive on high-end hardware and postgres is pretty good and improving all
the time. Show me another system where you can either fix bugs yourself or
get a fix off the mailing list in a few hours!

Adriaan

--
--------------------------------------+-------------------------------
Dr Adriaan Joubert | Phone: +357-2-750 652
APL Financial Services (Overseas) Ltd| Fax: +357-2-750 654
3 D. Vikella St | e-mail: a.joubert@albourne.com
1061 Nicosia, CYPRUS |
--------------------------------------+-------------------------------

At 10:20 PM 19-04-2000 +0300, Adriaan Joubert wrote:

DS-20. For a small organisation Oracle is just too expensive on high-end
hardware and postgres is pretty good and improving all the time. Show me
another system where you can either fix bugs yourself or get a fix off the
mailing list in a few hours! Adriaan

Show me closed source stuff where you get to hear the developers say openly
"This area doesn't work well and needs an overhaul", and thus save yourself
a lot of grief.

For most closed stuff I've had responses (from "technical support" people)
like
1) It installs and works beautifully.
2) "Here's a soft copy of the manual".
(If the software worked like the manual promised I wouldn't be talking to
you. Doh!
How about a HOWTO with a known to work config?).
3) There have been no reported performance problems with that.
(Well here's one now! Later I found at least someone else had encountered
that prob)

Well maybe it's me- I can follow the installation manual step by step, read
the readmes, do everything according to the book, and somehow things don't
work for me.

Anyone can help remove my Murphy Field Intensifier?

Cheerio,

Link.

Hi everyone,

Say I turn fsync off, and someone switches the whole machine off, or
something crashes badly.

How should I go about checking and if necessary repairing stuff?

How good are these methods? Has anyone had irrecoverable problems?

Assume I don't use OIDs to link stuff.

Cheerio,

Link.

On Tue, Apr 18, 2000 at 08:08:43PM -0400, rcook@Bix.Com wrote:

I'm working a piece on open-source databases for LinuxWorld magazine and
I'd like to know what people are actually using postgresql for.

--Rick Cook
rcook@bix.com

I've been using it for several years now to do my company's bookkeeping
using double-entry bookkeeping software that I wrote from scratch in C
using the libpq API. The user interface is a regular command line
implemented using libreadline, bison, and flex. Although the program is
GPL'd, I still haven't got around to releasing it as I keep re-writing it,
creating more bugs along the way. (Also, I'm not sure if there is much
interest in double-entry bookkeeping using PostgreSQL. Anybody interested
out there please correct me. Maybe it will prompt me to get a release out,
although the documentation is very out of date.)

Recently I've written two new applications programs (using large chunks of
the double-entry bookkeeping program as a base). The first is a
multi-lingual dictionary program and the second is a simple program that I
use to keep track of my paper files. Both have a full-screen (ncurses)
user interface with a command line at the bottom and a fixed section of the
screen at the top for browsing and data entry implemented using the forms
library. Here again, I'm using these programs on a daily basis, they are
GPL'd but haven't released either of them. (No documentation.)

So, anyway, none of these are big mission critical applications, but since
I find PostgreSQL extremely useful and I'm a big fan, I thought I'd reply.

--
Nathan L. Cutler < livingston @ iol.cz > telephone: +420-2-51611648
Livingston Professional Translations fax: +420-2-6514377
** When "pretty good" is not enough ** mobile: +420-602-259964