Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Skip to content

Convert sqlite3 databases to directed graph .dot files

Notifications You must be signed in to change notification settings

yhh2021/sqlite3todot

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

README for sqlite3todot


If ever there were some itch-scratching going on, this would be it. This
is a simple tool to create .dot directed graphs from sqlite3 databases.

It can optionally include things like clustering, and tables to ignore,
from a "meta" database.

To build:
  gcc -o sqlite3todot -lsqlite3 sqlite3todot.c

As an example to run, rendering the example meta database, with the meta
database as the meta database for that example meta [I can't go on]:
  cat meta.sql | sqlite3 meta.db
  ./sqlite3todot meta.db meta.db > verymeta.dot
  dot -Tpng -overymeta.png verymeta.dot

Alternatively, there's a script called "testlayouts.sh" that renders
all of the layouts graphviz has at time of writing. Simply pass it the
dot file you created before, and open the file it suggests:
  sh ./testlayouts.sh ./verymeta.dot


Gary "ChunkyKs" Briggs <chunky@icculus.org>

About

Convert sqlite3 databases to directed graph .dot files

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • C 70.2%
  • PLpgSQL 20.6%
  • Shell 5.7%
  • Makefile 3.5%