ER Diagram design tools (Linux)

On Wednesday 05 March 2008 20:33:43 Conor McTernan wrote:

I was wondering if anyone knows of any good ER Diagram tools for
Postgres that run on Linux.

I have been using DBDesigner by FabForce for a couple of years, but
development has stopped while MySQL workbench is being built (for
windows only). Neither of these applications will talk to Postgres and
I've found DBDesigner to be a bit buggy at the best of times (it's
still quite good and better than nothing I suppose).

I've been using PgAdmin3 which is great for updating/managing
tables/view etc, but I would really like something for modelling ER
diagrams which will talk directly to Postgres.

Does anyone know of any commercial or open source software that will do
this?

Cheers,

Conor

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Have a look at Data Architect (www.theKompany.com)
or Open System Architect (www.codebydesign.com)

/Kevin

People,

On Wed, 2008-03-05 at 20:56 -0700, Kevin Kempter wrote:

On Wednesday 05 March 2008 20:33:43 Conor McTernan wrote:

I was wondering if anyone knows of any good ER Diagram tools for
Postgres that run on Linux.

I have been using DBDesigner by FabForce for a couple of years, but
development has stopped while MySQL workbench is being built (for
windows only). Neither of these applications will talk to Postgres and
I've found DBDesigner to be a bit buggy at the best of times (it's
still quite good and better than nothing I suppose).

I've been using PgAdmin3 which is great for updating/managing
tables/view etc, but I would really like something for modelling ER
diagrams which will talk directly to Postgres.

Does anyone know of any commercial or open source software that will do
this?

Cheers,

Conor

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Have a look at Data Architect (www.theKompany.com)
or Open System Architect (www.codebydesign.com)

I have never had much success with DA, don't know about OSA and although
I usually avoid Java, I have found Power*Architect excellent - they even
fixed a bug I found overnight!

http://www.sqlpower.ca/page/architect

Regards,

Phil.
--
Philip Rhoades

Pricom Pty Limited (ACN 003 252 275 ABN 91 003 252 275)
GPO Box 3411
Sydney NSW 2001
Australia
Fax: +61:(0)2-8221-9599
E-mail: phil@pricom.com.au

Kevin Kempter wrote:

On Wednesday 05 March 2008 20:33:43 Conor McTernan wrote:

I was wondering if anyone knows of any good ER Diagram tools for
Postgres that run on Linux.

If you're not against paying there is dbwrench <http://www.dbwrench.com/&gt;.

Java so it could be a bit of a problem because at the time I used it it
required a JRE that had some FOSS issues. :-)

Rod
--

Hi,

Conor McTernan schrieb:

I was wondering if anyone knows of any good ER Diagram tools for
Postgres that run on Linux.

[...]

Does anyone know of any commercial or open source software that will do this?

Datastudio (www.aquafold.com) also has a tool to build ER diagrams.
It is a commercial java application, they offer a fully functional
evaluation version for download on their site.

Ciao,
Thomas

Conor McTernan wrote:

I was wondering if anyone knows of any good ER Diagram tools for
Postgres that run on Linux.

I have been using DBDesigner by FabForce for a couple of years, but
development has stopped while MySQL workbench is being built (for
windows only). Neither of these applications will talk to Postgres and
I've found DBDesigner to be a bit buggy at the best of times (it's
still quite good and better than nothing I suppose).

I've been using PgAdmin3 which is great for updating/managing
tables/view etc, but I would really like something for modelling ER
diagrams which will talk directly to Postgres.

Does anyone know of any commercial or open source software that will do this?

Cheers,

Conor

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

I've created an XSL stylesheet that works with graphviz to reverse
engineer an ERD from a postgres database.

If anyone's interested, I can make this available. It works quite well.
It uses a postgres-to-xml extractor that someone wrote (I don't know who
- their name is not in the file) and then I convert the xml to graphviz.

Regards
cf

Conor McTernan wrote on 06.03.2008 04:33:

I have been using DBDesigner by FabForce for a couple of years, but
development has stopped

It seems that someone picked up the source. There is a new project on
sourceforge that seems to continue the work on DbDesigner:

https://sourceforge.net/projects/dbdesigner-fork/

On Fri, Mar 07, 2008 at 11:44:38AM -0800, Colin Fox wrote:

Conor McTernan wrote:

I was wondering if anyone knows of any good ER Diagram tools for
Postgres that run on Linux.

I have been using DBDesigner by FabForce for a couple of years, but
development has stopped while MySQL workbench is being built (for
windows only). Neither of these applications will talk to Postgres and
I've found DBDesigner to be a bit buggy at the best of times (it's
still quite good and better than nothing I suppose).

I've been using PgAdmin3 which is great for updating/managing
tables/view etc, but I would really like something for modelling ER
diagrams which will talk directly to Postgres.

Does anyone know of any commercial or open source software that will do this?

Cheers,

I've created an XSL stylesheet that works with graphviz to reverse
engineer an ERD from a postgres database.

If anyone's interested, I can make this available. It works quite
well. It uses a postgres-to-xml extractor that someone wrote (I
don't know who - their name is not in the file) and then I convert
the xml to graphviz.

Sounds good :)

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

On Fri, 07 Mar 2008 11:44:38 -0800
Colin Fox <cfox@cfconsulting.ca> wrote:

I've created an XSL stylesheet that works with graphviz to reverse
engineer an ERD from a postgres database.

If anyone's interested, I can make this available. It works quite well.
It uses a postgres-to-xml extractor that someone wrote (I don't know who
- their name is not in the file) and then I convert the xml to graphviz.

Regards
cf

That sounds interesting..... :)

BTJ

i'm interested in both the xml extractor and the conversion, could you reply
with a link or some such it would be greatly appreciated ;)

On Fri, Mar 7, 2008 at 2:44 PM, Colin Fox <cfox@cfconsulting.ca> wrote:

I've created a pg_foundry project for this.

Assuming the project gets approved, I'll post the link here.

Regards,
cf

Malinka Rellikwodahs wrote:

On Fri, Mar 07, 2008 at 01:22:49PM -0800, Colin Fox wrote:

I've created a pg_foundry project for this.

Assuming the project gets approved, I'll post the link here.

Wouldn't it be better just to send that XSLT to the upstream project?

Cheers,
David.

Regards,
cf

Malinka Rellikwodahs wrote:

i'm interested in both the xml extractor and the conversion, could you
reply with a link or some such it would be greatly appreciated ;)

On Fri, Mar 7, 2008 at 2:44 PM, Colin Fox <cfox@cfconsulting.ca
<mailto:cfox@cfconsulting.ca>> wrote:

Conor McTernan wrote:

I was wondering if anyone knows of any good ER Diagram tools for
Postgres that run on Linux.

I have been using DBDesigner by FabForce for a couple of years, but
development has stopped while MySQL workbench is being built (for
windows only). Neither of these applications will talk to

Postgres and

I've found DBDesigner to be a bit buggy at the best of times (it's
still quite good and better than nothing I suppose).

I've been using PgAdmin3 which is great for updating/managing
tables/view etc, but I would really like something for modelling ER
diagrams which will talk directly to Postgres.

Does anyone know of any commercial or open source software that

will do this?

Cheers,

Conor

---------------------------(end of

broadcast)---------------------------

TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org

<mailto:majordomo@postgresql.org> so that your

message can get through to the mailing list cleanly

I've created an XSL stylesheet that works with graphviz to reverse
engineer an ERD from a postgres database.

If anyone's interested, I can make this available. It works quite
well.
It uses a postgres-to-xml extractor that someone wrote (I don't
know who
- their name is not in the file) and then I convert the xml to
graphviz.

Regards
cf

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
<mailto: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

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

David Fetter wrote:

On Fri, Mar 07, 2008 at 01:22:49PM -0800, Colin Fox wrote:

I've created a pg_foundry project for this.

Assuming the project gets approved, I'll post the link here.

Wouldn't it be better just to send that XSLT to the upstream project?

Cheers,
David.

I don't know which project you mean. The postgresql project?

I have a couple of files that go along with it - instructions, some
documentation, examples, etc.

I'm certainly more than willing to provide this to the PG team, if
they're interested.

It just seems that the pg_foundry is a logical place to put all the
project information.

Regards,
cf

On Sat, Mar 08, 2008 at 10:49:02AM -0800, Colin Fox wrote:

David Fetter wrote:

On Fri, Mar 07, 2008 at 01:22:49PM -0800, Colin Fox wrote:

I've created a pg_foundry project for this.

Assuming the project gets approved, I'll post the link here.

Wouldn't it be better just to send that XSLT to the upstream
project?

Cheers, David.

I don't know which project you mean. The postgresql project?

Actually, I meant the xmltoddl project. http://xml2ddl.berlios.de/

I have a couple of files that go along with it - instructions, some
documentation, examples, etc.

I'm certainly more than willing to provide this to the PG team, if
they're interested.

It just seems that the pg_foundry is a logical place to put all the
project information.

See above :)

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