From: | Richard Welty <rwelty(at)averillpark(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Are you frustrated with PostgreSQL |
Date: | 2003-07-15 12:42:27 |
Message-ID: | E19cP8V-0003YE-76@skipper.averillpark.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 15 Jul 2003 13:23:30 +0100 Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> wrote:
>
> On 14/07/2003 23:16 Terence Chang wrote:
> > [snip]
> > I have the following questions. Please reply me offline, so the
> mailling
> > list won't get flood. Thanks!
> > 1. What is your favorite GUI tool for PostgreSQL?
> Most of th time, I find psql to be perfectly adequate for the job. If I
> need to look at long and/or wide result sets I'll use pgaccess.
psql mostly. i've played with dbvisualizer, found it useful, then found
that for one particular combination of versions (postgresql & dbvis) it
wouldn't show me all tables. i have used Access/ODBC occasionally, but i
try no to use M$ products where i can avoid it. pgmanager looks promising,
but i've only been playing with it for a day or two.
> > 2. In your organization, do you have someone who works as full time
> > PostgreSQL DBA?
> Me organised? Being an independent software developer, I tend to wear
> all
> the hats.
ditto.
> > 3. What is the biggest challenge you have with PostgreSQL?
> Administration
> > or
> > Programming?
> All fairly straight forward IME.
i'd have to say learning the performance stuff. i have just started
reading the performance list and have found it most instructive.
i've learned a lot there in a few short days that isn't in any of the
PostgreSQL books that i have. i would think that a really hardcore
PostgreSQL DBA book along the lines of Loney's Oracle DBA handbooks would
be most useful.
> > 4. Overall, do you like PostgreSQL? Would you recommend it over MySQL?
> 100% of the time.
agreed. MySQL is satisfactory for a narrow set of uses, but has some
significant limitations. and what with the LGPL-GPL licensing change for
MySQL 4.1.x, i am tending to recommend that my clients running MySQL
consider their transistion strategies to some other product.
> > 5. How often do your PostgreSQL run into problem or crash? Are most of
> > the
> > problem caused by PostgreSQL itself?
> I've never had a problem
none here, either. it just works.
richard
--
Richard Welty rwelty(at)averillpark(dot)net
Averill Park Networking 518-573-7592
Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Welty | 2003-07-15 12:51:12 | Re: Are you frustrated with PostgreSQL |
Previous Message | Paul Thomas | 2003-07-15 12:23:30 | Re: Are you frustrated with PostgreSQL |