there're a few solid Database IDE/Administration Tools for SQLite in market. I love using dbForge Studio cause the development environment and work flow are so natural and boost my productivity to manage data, analyst data in advanced. Another feature that I love from dbForge Studio are data compare, schema compare, master-data view, and database snapshot & version control.

Another tools that I review for DB Administration / IDE for SQLite is navicat. their have simplicity UI but leak advance feature in data compare, schema compare, version control and etc.

There're many free and open source DB Administration for SQLite but much of them no update since 2010. And some of them have solid basic functionality, but leak help support subscription for Professional or Corporate, advance feature for data analysis and development.