I use a pretty convenient and open source tool called "Mike T's SQL Database App". It lets you open an SQLite database, perform manual SQL queries as well as use a GUI to insert/edit/remove data all with minimal hassle.
There are Linux, Windows and Mac OS X versions available although he has currently stopped updating the tool, to be honest through my uses I don't think I've ever come across a bug.
To answer my own question - the most feature-rich tool I was able to find is SQLite2009 Pro Enterprise Manager. And it's free which is really important to me.
发布评论
评论（2）
我使用一个非常方便且开源的工具，称为“ Mike T的SQL数据库应用程序”。它使您可以打开一个SQLITE数据库，执行手动SQL查询，并使用GUI插入/编辑/删除所有数据的数据。
尽管他目前已经停止更新该工具，但有Linux，Windows和Mac OS X版本可用，说实话，我认为我从未遇到过错误。
Mike T's SQL数据库应用
I use a pretty convenient and open source tool called "Mike T's SQL Database App". It lets you open an SQLite database, perform manual SQL queries as well as use a GUI to insert/edit/remove data all with minimal hassle.
There are Linux, Windows and Mac OS X versions available although he has currently stopped updating the tool, to be honest through my uses I don't think I've ever come across a bug.
Mike T's SQL Database App
回答我自己的问题 - 我能找到的功能最丰富的工具是 SQLite2009 Pro Enterprise Manager 。而且它是免费的，这对我来说非常重要。
To answer my own question - the most feature-rich tool I was able to find is SQLite2009 Pro Enterprise Manager. And it's free which is really important to me.