Sunday’s are for schemacrawling
I love looking at database schema diagrams – and last Sunday I came across Schemacrawler. Getting it up and running all went pretty smoothly. I downloaded the zip file from here You also need to install GrahpViz. References: http://www.schemacrawler.com/diagramming.html Output your database schema To output a pdf of the schema:
1 2 |
bash schemacrawler.sh -server sqlite -database ~/apps/win32apps/test.db -infolevel=maximum -command=details -routines= -tabletypes=TABLE -outputformat=pdf |
To output a png of the schema:
1 2 |
bash schemacrawler.sh -server sqlite -database ~/apps/win32apps/test.db -infolevel=maximum -command=details -routines= -tabletypes=TABLE -outputformat=png -outputfile=mydb.png |