Re: [sqlite] (UML) Visualisation of a SQLite schema ?

[Fredrik Karlsson]

Hi,

Just thought I'd tell you that I went into solving this issue myself.
The resulting script is here:

https://github.com/dargosch/sqlite2dot

* Requires Tcl and the sqlite3 package for Tcl.

It generates a .dot file for use with Graphviz. Very simple script,
but it solves the issue I wanted to solve :-)

Please suggest enhancements.

/Fredrik

On Fri, Apr 15, 2011 at 12:40 PM, Gary_Gabriel
 wrote:
> Hi Fredrik,
>> I'm looking for a tool that would generate a visualisation (UML?) of
>> the SQLite database schema I'm using, with table constraints and
>> references between tables if possible. Is there such a tool (for Mac)?
>>
> If you are interested in doing something yourself- then this might be a
> gentle reminder of a thread on the mailing list.
> Subject: [sqlite] Creating directed graphs and simple examples To:
> sqlite-users@sqlite.org From: Gary Briggs  Date: 15,
> Mar 2011
>
> Archive:  http://www.mail-archive.com/sqlite-users@sqlite.org/msg59602.html
>
> Graphviz: http://www.graphviz.org/
>
> As you probably know Graphviz integrates into Tcl/Tk with TclDot which
> is available for Posix.
>
> Good luck with your search- Gary Gabriel
>
>
>
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
"Life is like a trumpet - if you don't put anything into it, you don't
get anything out of it."
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] (UML) Visualisation of a SQLite schema ?

[Gary_Gabriel]

Hi Fredrik,
> I'm looking for a tool that would generate a visualisation (UML?) of
> the SQLite database schema I'm using, with table constraints and
> references between tables if possible. Is there such a tool (for Mac)?
>   
If you are interested in doing something yourself- then this might be a
gentle reminder of a thread on the mailing list.
Subject: [sqlite] Creating directed graphs and simple examples To:
sqlite-users@sqlite.org From: Gary Briggs  Date: 15,
Mar 2011

Archive:  http://www.mail-archive.com/sqlite-users@sqlite.org/msg59602.html

Graphviz: http://www.graphviz.org/

As you probably know Graphviz integrates into Tcl/Tk with TclDot which
is available for Posix.

Good luck with your search- Gary Gabriel






___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users