I had trouble getting resources for viewing my sqlite db schema for a documentation I was writing. I published how-to here:
https://tech.xlab.si/2013/10/visualize-sqlite-database-with-schemaspy/
Simplifies the visualization a lot!
Cheers,
A
