I have a database that's been created with 2.8.14 and it has grown to 100M. When I zip it, however, I end up with a file that's about 1M. So I'd kind of like to try to figure out where all the space is going. I'd heard there was a tool for analyzing SQLite databases, but I can't seem to track it down on the website. Is there such a tool and will it help me figure out what might be going on with my database file?
Thanks.