Re: Are you frustrated with PostgreSQL

On 14 Jul 2003 at 15:16, Terence Chang wrote:

> Hi all:
>
> I am new to PostgreSQL DB, however I have years experience with Oracle
> 8i and MS SQL. I am in the process to promot PostgreSQL to my future
> client, due to the cost. I am just wondering if overall people feels
> frustrated with PostgreSQL or feels happey with it.

I've been working with databases for about 15 years, including
Sybase, Oracle, PostgreSQL, and MySQL. Yes, I'm happy with
PostgreSQL. No frustration at all.

> I know MySQL is simpiler and cheap. With my years experience with
> enterprise level DB like Oracle and MS SQL, I just don't feel right
> with MySQL. I love stored procedure. Sorry to MySQL lovers.

Stored procedures is one reason I moved http://www.FreshPorts.org/
from MySQL to PostgreSQL.

> I have the following questions. Please reply me offline, so the mailling
> list won't get flood. Thanks!

If we reply to the list, everyone who asks the same questions as you
will be able to find them in the archives.

> 1. What is your favorite GUI tool for PostgreSQL?

I usually use command line tools for PG work, but do use PGAdmin from
time to time.

> 2. In your organization, do you have someone who works as full time
> PostgreSQL DBA?

Yes.

> 3. What is the biggest challenge you have with PostgreSQL?
> Administration or Programming?'

Finding more time to spend working with it.

> 4. Overall, do you like PostgreSQL? Would you recommend it over MySQL?

Yes. Yes. Friends don't let friends use MySQL.

> 5. How often do your PostgreSQL run into problem or crash? Are most of
> the problem caused by PostgreSQL itself?

I have never seen a PostgreSQL crash. Most if not all of the
problems have been caused by myself.
--
Dan Langille : http://www.langille.org/