Thread: What are your using it for?
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
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. > > --Rick Cook > rcook@bix.com >
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!
> 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.
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