Thread: GUI for Postgres Management? PostgreSQL vs MySQL.

Hello,

I am new to PostgreSQL.  I am wondering if there is currently a GUI management tool available to be used with PostgreSQL?  I am debating between MySQL and PostgreSQL. 

I like MySQL because of its GUI management tool and because (according to soom books) its tight integration with PHP.

On the other hand PostgreSQL has a PL/SQL "like" enhancement which I really like too.

I plan on installing on Linux for DB/Web application I am hoping to build.  Is there any performance advantages in using PostgreSQL over MYSQL?

Any help would be appreciated in helping me make up my mind.

Alex-

Hi Alex,

Josh Berkus has been putting together a guide to the known PostgreSQL
GUI tools:

http://techdocs.postgresql.org/guides/GUITools

Although still in development, it should still list most of the known
ones.

With your DB/Web application, do you have an idea of how many people
will be simultaneously trying to connect to it, and how many rows of
information the database will grow to?

There isn't very much speed difference between PostgreSQL and MySQL,
unless you're running a website that is mostly read only (SELECT
statements) with only a few simultaneous users.  MySQL better caches
results for that situation (read-only, with only a few users), whereas
we're pretty much as fast or faster for everything else.  Oh, and we
have a lot more features (transactions inbuilt, referential integrity,
etc).  The global .info domain name registry runs on PostgreSQL (and
.org will be from 1st Jan 2003 too).

Hope this helps.

:-)

Regards and best wishes,

Justin Clift


Aleksei Wolff wrote:
>
> Hello,

I am new to PostgreSQL.  I am wondering if there is currently a GUI
management tool available to be used with PostgreSQL?  I am debating
between MySQL and PostgreSQL.

I like MySQL because of its GUI management tool and because (according
to soom books) its tight integration with PHP.

On the other hand PostgreSQL has a PL/SQL "like" enhancement which I
really like too.

I plan on installing on Linux for DB/Web application I am hoping to
build.  Is there any performance advantages in using PostgreSQL over
MYSQL?

Any help would be appreciated in helping me make up my mind.

Alex-

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi

Hi Aleksei,

You can use the DBTools DBManager (http://www.dbtools.com.br) which is free
but for Windows only. If you are familiar with MySQL you gonna like this,
since this tool allows you to manage both in only one tool.

[]s

Crercio

----- Original Message -----
From: Aleksei Wolff
To: pgsql-general@postgresql.org
Sent: Saturday, November 23, 2002 10:54 PM
Subject: [GENERAL] GUI for Postgres Management? PostgreSQL vs MySQL.


Hello,
I am new to PostgreSQL.  I am wondering if there is currently a GUI
management tool available to be used with PostgreSQL?  I am debating
between MySQL and PostgreSQL.
I like MySQL because of its GUI management tool and because (according to
soom books) its tight integration with PHP.
On the other hand PostgreSQL has a PL/SQL "like" enhancement which I really
like too.
I plan on installing on Linux for DB/Web application I am hoping to build.
Is there any performance advantages in using PostgreSQL over MYSQL?
Any help would be appreciated in helping me make up my mind.
Alex-





Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

Thanks to all who responded.  Now I am tilting more towards PostgreSQL.

I'll definately look into phppgadmin.

Aleksei Wolff wrote:
>
> Hello,

I am new to PostgreSQL. I am wondering if there is currently a GUI
management tool available to be used with PostgreSQL? I am debating
between MySQL and PostgreSQL.

I like MySQL because of its GUI management tool and because (according
to soom books) its tight integration with PHP.

On the other hand PostgreSQL has a PL/SQL "like" enhancement which I
really like too.

I plan on installing on Linux for DB/Web application I am hoping to
build. Is there any performance advantages in using PostgreSQL over
MYSQL?

Any help would be appreciated in helping me make up my mind.

Alex-

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

Hi,

there are GUI-tools for postgresql. Look at http://gborg.postgresql.org (but
you should switch JavaScript off - there is a bug at the page for database
administration tools, which redirects you to sourceforge).

A very nice tool is pgaccess (www.pgaccess.org). It is written in tcl/tk.

I'm not an expert in PHP, but I think the integration of PostgreSQL is as good
as MySQL. I prefer perl, which has a database abstraction layer. HTML::Mason
(www.masonhq.com) does with perl what php does with php - it integrates perl
and html.

PostgreSQL is far better than MySQL. It has full SQL-support. MySQL is missing
some major features, which renders it unusable for me (views and subselects
to mention the major ones).

MySQL is told to be faster than PostgreSQL, but there are articles, which tell
the other way. In my experiences PostgreSQL is fast enough for simple queries
and superiour if it comes to complex ones, because there are features missing
in MySQL, which speeds thins up.

Once there was a very interesting article here at pgsql-general about
performance optimization. Someone optimized his application and used all
features, which makes PostgreSQL fast and MySQL unusable. The result was a
reduced CPU-load from 15% with MySQL to 1% in PostgreSQL!


Tommi


Am Sonntag, 24. November 2002 01:54 schrieb Aleksei Wolff:
> Hello,
>
> I am new to PostgreSQL.  I am wondering if there is currently a GUI
> management tool available to be used with PostgreSQL?  I am debating
> between MySQL and PostgreSQL.
>
> I like MySQL because of its GUI management tool and because (according to
> soom books) its tight integration with PHP.
>
> On the other hand PostgreSQL has a PL/SQL "like" enhancement which I really
> like too.
>
> I plan on installing on Linux for DB/Web application I am hoping to build.
> Is there any performance advantages in using PostgreSQL over MYSQL?
>
> Any help would be appreciated in helping me make up my mind.
>
> Alex-
>
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now

--
Dr. Eckhardt + Partner GmbH
http://www.epgmbh.de