Thread: ER Diagram design tools (Linux)
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
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/>. 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
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 an XSL stylesheet that works with graphviz to reverseConor 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
>
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
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 > >
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 >> 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 >> > >
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