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

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&amp;lang=2). Which is not mentioned on the page above.

Sincerely,

Wolfgang

--
NO "Courtesy Copies" PLEASE!

On Tue, Oct 20, 2009 at 11:27 AM, Wolfgang Keller <feliphil@gmx.net> wrote:

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&amp;lang=2). Which is not mentioned on
the page above.

which btw, is a nice program, written in java, but no linux/mac osx

version/package available. what a shame.

--
GJ

2009/10/20 Grzegorz Jaśkiewicz <gryzman@gmail.com>

On Tue, Oct 20, 2009 at 11:27 AM, Wolfgang Keller <feliphil@gmx.net>wrote:

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&amp;lang=2). Which is not mentioned on
the page above.

which btw, is a nice program, written in java, but no linux/mac osx

version/package available. what a shame.

correction, it's c++ program. But doesn't seem to work with wine here. A
shame.

(I mistake it for some other program).

--
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

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.

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&amp;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.
http://clk.atdmt.com/GBL/go/177141664/direct/01/

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..