Re: Visual Database Design Tools

Andrew, Ben,

> > As a complete Novice, I'm looking for a visual design tool for
> Databases
> > to use with PostgreSQL.
> > Currently all of our development is done in Flemaker Pro, so I'm
> looking
> > for a tool to ease my developers
> > into SQL without jolting their world too much.
> >
> > Any info gratefully received.

On Windows: PgAdminII, available at http://pgadmin.postgresql.org/
On Linux/Unix: PgAccess, which installs with most PostgreSQL RPMs

However, keep in mind that you will need a seperate interface design
tool and language.  PostgreSQL is just the back-end, and while PgAccess
does have a TCL forms designer, it is neither complete nore stable.

If you are on Windows or Linux, and have a little cash, I reccomend one
of the following IDEs:

Java: JBuilder by Borland or Forte For Java by Sun
Best VB/MS Access Substitute: Kylix + Delphi, by Borland

You can also use Filemaker as the front-end to your PostgreSQL database
as of version 5.5

> We have recently been looking for a somewhat more high-end ER/BP
> modelling tool ourselves for managing database designs.  A reasonable
> interface to PostgreSQL has been one of the harder requirements to
> meet,
> but I think we have found one that did, which unfortunately didn't
> meet
> our other requirements - we haven't bought anything yet.

You might contact Action Target, Inc.  Their WyattERP PostgreSQL-based
CRM-building and modelling toolkit recently went commercial.  I don't
know whether or not the product is limited to CRM databases, though.

-Josh Berkus


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco