Re: [GENERAL] ER Diagram design tools (Linux)
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 [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] ER Diagram design tools (Linux)
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 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] ER Diagram design tools (Linux)
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 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] ER Diagram design tools (Linux)
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 [EMAIL PROTECTED] 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: [GENERAL] ER Diagram design tools (Linux)
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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] ER Diagram design tools (Linux)
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 [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] ER Diagram design tools (Linux)
On Fri, 07 Mar 2008 11:44:38 -0800 Colin Fox [EMAIL PROTECTED] 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] ER Diagram design tools (Linux)
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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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: [GENERAL] ER Diagram design tools (Linux)
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 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 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: [GENERAL] ER Diagram design tools (Linux)
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 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] 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 [EMAIL PROTECTED] 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: [GENERAL] ER Diagram design tools (Linux)
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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] ER Diagram design tools (Linux)
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 [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 6: explain analyze is your friend