Thread: ER Diagram design tools (Linux)

ER Diagram design tools (Linux)

From
"Conor McTernan"
Date:
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

Re: ER Diagram design tools (Linux)

From
Kevin Kempter
Date:
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

Re: ER Diagram design tools (Linux)

From
Phil Rhoades
Date:
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


Re: ER Diagram design tools (Linux)

From
"Roderick A. Anderson"
Date:
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/>.

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
--
>>
>> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match


Re: ER Diagram design tools (Linux)

From
Thomas Pundt
Date:
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

Re: ER Diagram design tools (Linux)

From
Colin Fox
Date:
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


Re: ER Diagram design tools (Linux)

From
Thomas Kellerer
Date:
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/

Re: ER Diagram design tools (Linux)

From
David Fetter
Date:
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

Re: ER Diagram design tools (Linux)

From
Bjørn T Johansen
Date:
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

Re: ER Diagram design tools (Linux)

From
"Malinka Rellikwodahs"
Date:
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:
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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: ER Diagram design tools (Linux)

From
Colin Fox
Date:
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:
> 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
>
>


Re: ER Diagram design tools (Linux)

From
David Fetter
Date:
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

Re: ER Diagram design tools (Linux)

From
Colin Fox
Date:
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


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


Re: ER Diagram design tools (Linux)

From
David Fetter
Date:
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