Thread: Free Tool to design Postgres Databases

On Mon, Oct 19, 2009 at 2:18 PM, Andre Lopes <lopes80andre@gmail.com> wrote:
> Hi,
>
> I'am searching for a free tool to design a Postgre Database. There is
> something similar to MySQL Workbench?

Search the archives this came up within the last couple of months.  I
currently use Power Architect, it's a beta product and still fairly
buggy but works.

--
Peter Hunsberger

Andre Lopes wrote:
> Hi,
>
> I'am searching for a free tool to design a Postgre Database. There is
> something similar to MySQL Workbench?
>
> Best Regards,
> Andre.

 From 9/11/2009 "Open source database design tool ,  alternative to
MicroOLDAP"

Open ModelSphere: http://www.modelsphere.org/


 From 5/24/2008 "best er modeling tool for postgreSQL":

/** GNU-GPL **/
OpenSystemArchitect
     http://www.codebydesign.com/
Power*Architect
     http://code.google.com/p/power-architect/
Druid
     http://druid.sourceforge.net/
ERW
     http://erw.dsi.unimi.it/
Dia
     http://live.gnome.org/Dia
XML to DDL (python scripts)
     http://xml2ddl.berlios.de/
Graphiz - I believe I've read of people using it to reverse engineer
from DDL
     http://graphviz.org/

/** Multiple versions/licenses (each has a "free" and a "not-free"
version) **/
DBVisualizer
     http://www.minq.se/products/dbvis/
Toad
     http://www.toadsoft.com/

/** Not-free **/
Microsoft Visio - (If you already have it, it does work quite well)
DataStudio - 30 day trial
     http://www.aquafold.com
DBWrench - 30 day trial
     http://www.dbwrench.com/

 From 3/13/2008 "ER diagram tool"

http://druid.sf.net/
http://schemaspy.sourceforge.net/
http://uml.sourceforge.net/index.php

And on it goes.  Keep searching and you'll find more.

--
Guy Rouillier

On Mon, Oct 19, 2009 at 10:48:47PM -0400, Guy Rouillier wrote:
> Andre Lopes wrote:
>> Hi,
>>  I'am searching for a free tool to design a Postgre Database. There is
>> something similar to MySQL Workbench?
>>  Best Regards,
>> Andre.
>
> From 9/11/2009 "Open source database design tool ,  alternative to
> MicroOLDAP"

> [extensive list]

Considering that PostgreSQL is a shared resource, you'll probably do
something more collaborative, at least at many stages.  Development
looks a little more like:

1.  Paper, pencil, trash can.  Lots of that last.

2.  Lather, rinse, repeat.

3.  Marker, dry-erase board, eraser, closed room.

4.  Lather, rinse, repeat.

5.  psql + $EDITOR

6.  Lather, rinse, repeat.

7.  $SCM

8.  Lather, rinse, repeat.

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

Hi

You can also try Mogwai ERDesignerNG. Free and Open Source.

Regards
Mirko

> -----Ursprüngliche Nachricht-----
> Von: "Peter Hunsberger" <peter.hunsberger@gmail.com>
> Gesendet: 19.10.09 22:52:50
> An: Andre Lopes <lopes80andre@gmail.com>
> CC: pgsql-general@postgresql.org
> Betreff: Re: [GENERAL] Free Tool to design Postgres Databases


> On Mon, Oct 19, 2009 at 2:18 PM, Andre Lopes <lopes80andre@gmail.com> wrote:
> > Hi,
> >
> > I'am searching for a free tool to design a Postgre Database. There is
> > something similar to MySQL Workbench?
>
> Search the archives this came up within the last couple of months.  I
> currently use Power Architect, it's a beta product and still fairly
> buggy but works.
>
> --
> Peter Hunsberger
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

> I'am searching for a free tool to design a Postgre Database. There is
> something similar to MySQL Workbench?

http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools

I've tried out nearly every (affordable or free) ER tool that's available and so far the one I like the most is DB-Main
(http://www.db-main.com/doc.php?id=to1&lang=2).Which is not mentioned on the page above. 

Sincerely,

Wolfgang

--
NO "Courtesy Copies" PLEASE!

--
GJ

--
GJ

Wolfgang

I am compiling 8.4.1 and am seeking any/all architecture documents..right now the architecture (relationship of classes) i see is extracted from makefile dependencies
An architecture document will detail the layout of the System Tables and their classes(sorry as neither C++/java is not the codebase this would be C functions)
something like
Tablespace - Tablespace.c<pp>
                   Extents and allocation Parameters in StorageParams.c<pp>
Tables       -  Tables.c<pp>
                   Indexes and key assignments in Index.c<pp>
                   Cursor assignments via cursors.c
                     ReadCursor.c<pp>
                     UpdateableCursor.c<pp>
                   Column assignments on known datatypes
                     Int.c
                     VARCHAR.c
                     Date.c
Roles         -  Roles which will be assigned for group and User classes - Roles.c<pp>
                   Users - individual Users which are assigned predefined Roles -Users.c<pp>
Packages   -  external packages which extend implement Postgres functionality for specific Application Systems packages.c<pp>
                   Postgis - A geographic Information System which enables one to provide Geometry and or WKT parameters which map to core Postgres tables - Postgis.c<pp>

Would appreciate any documentation which identified core functions, maps base core functions to actual c file names (and ot their library names)

*gruss*
Martin Gainty
______________________________________________
Verzicht und Vertraulichkeitanmerkung

> Date: Tue, 20 Oct 2009 12:27:06 +0200
> From: feliphil@gmx.net
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Free Tool to design Postgres Databases
>
> > I'am searching for a free tool to design a Postgre Database. There is
> > something similar to MySQL Workbench?
>
> http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
>
> I've tried out nearly every (affordable or free) ER tool that's available and so far the one I like the most is DB-Main (http://www.db-main.com/doc.php?id=to1&lang=2). Which is not mentioned on the page above.
>
> Sincerely,
>
> Wolfgang
>
> --
> NO "Courtesy Copies" PLEASE!
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

---

Hotmail: Trusted email with Microsoft’s powerful SPAM protection. Sign up now.

On Tue, Oct 20, 2009 at 07:56:48AM -0400, Martin Gainty wrote:
>
> Wolfgang
>
> I am compiling 8.4.1 and am seeking any/all architecture
> documents..right now the architecture (relationship of classes) i
> see is extracted from makefile dependencies An architecture document
> will detail the layout of the System Tables and their classes(sorry
> as neither C++/java is not the codebase this would be C functions)
> something like

Martin,

Mapping these low-level details to classes is exactly your wrong move
for the same reason that mapping disk blocks to classes is.  It's
digging into implementation details--private methods--rather than
looking at the much higher level of abstraction that really concerns
it.

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

I tried Power Architect for about 5 minutes, just enough time to
notice it had no support for UUIDs which makes it all but useless..  I
mean, seriously who doesn't use UUIDs :)

Maybe they'll fix that, it does look promising..

>>
>> Search the archives this came up within the last couple of months.  I
>> currently use Power Architect, it's a beta product and still fairly
>> buggy but works.
>>
>> --
>> Peter Hunsberger
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>