Re: GUI for Postgres Management? PostgreSQL vs MySQL.

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