Did I see some code posted here that would create a graphical representation of a database relationships using the graphviz utilities? -- Posted via http://www.ruby-forum.com/.
There''s pgautodoc if you''re using postgresql: http://www.rbt.ca/autodoc/index.html I''d be amazed if there wasn''t something similar for mysql. On 13/01/06, Jim <narf968@gmail.com> wrote:> Did I see some code posted here that would create a graphical > representation of a database relationships using the graphviz utilities?-- Rasputin :: Jack of All Trades - Master of Nuns http://number9.hellooperator.net/
Dick Davies wrote:> There''s pgautodoc if you''re using postgresql: > > http://www.rbt.ca/autodoc/index.html > > I''d be amazed if there wasn''t something similar for mysql. >I couldn''t find one... I was amazed.:^) I converted the db to PostgreSQL, used pg_autodoc, and Dia. It was faster than doing it all by hand! There are plenty of MySQL to PostgreSQL conversion tools on the PostgreSQL site, most of which don''t work with the latest MySQL, but they are a start. Please let me know if you find (or write) a MySQL -> Dia tool. - Ian -- Posted via http://www.ruby-forum.com/.
Hi Jim, Have you looked at DBDesigner4 at http://www.fabforce.net/ which will become mySQLWorkbench soon in the mySQL distro. I don''t have a lot of experience with it since I just downloaded and installed it myself. It can import existing schema but I am not sure if it will automatically generate a relationship diagram. I will soon find out :) -bakki On 1/12/06, Jim <narf968@gmail.com> wrote:> > Did I see some code posted here that would create a graphical > representation of a database relationships using the graphviz utilities? > > > -- > Posted via http://www.ruby-forum.com/. > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060113/4cf3b5ed/attachment-0001.html
I use DBVisualizer for an administration/graphical representation. You can print out the graphical output, arrange it in a hierarchical/orthagonical/organic method as well. http://www.minq.se/products/dbvis/ I really like their product and bought the full version. You just need to give it a JDBC driver for your database, and connect. - Nic. On 1/12/06, Jim <narf968@gmail.com> wrote:> Did I see some code posted here that would create a graphical > representation of a database relationships using the graphviz utilities? > > > -- > Posted via http://www.ruby-forum.com/. > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-- - Nic