Other How to draw a visual representation of database schema out of running db

blind0ne

blind0ne

How to draw a visual representation of database schema out of running db considering that the database is living on mysql or psql
The Example:
example

Is it possible, or it's just wrong thoughts?
 
SirDice

SirDice

Administrator
Staff member
Administrator
Moderator
Those are called UML diagrams. You can create those with Visio or graphics/dia. You typically design these before you start implementing it in a database, not the other way around. But I'm sure there are scripts or tools that could generate an UML diagram from an existing database.
 
OP
blind0ne

blind0ne

SirDice said:
Those are called UML diagrams. You can create those with Visio or graphics/dia. You typically design these before you start implementing it in a database, not the other way around. But I'm sure there are scripts or tools that could generate an UML diagram from an existing database.
Click to expand...
Yep, I'm looking for such tools
 
S

shkhln

And, of course, if you need to specifically draw a flashy diagram for whatever bullshit reason, yEd from yWorks is practically unbeatable. Not open source, though.
 
daeron

daeron

I was fond of dia when it popped up but I don't think its been developed since 2009, and does not produce automated layouts.
Just tested yEd, the 3.22 zip does not seem to be available (though I might just have looked in the wrong spot), however the 3.23.1.zip works perfectly (just make a port with updated distinfo and Makefile). They're using a AI database to rearrange layouts, so at least the 'free' version requires you give feedback whether you think the automated layout is good or bad. In exchange it looks to handle quite complex diagrams, use their "one click layout" tool to have it rearrange the layout so connectors don't need to cross each other, looks cute.
 
You must log in or register to reply here.
Top