Convenient tool to insert data into SQLite database? [closed]
Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.
Closed 9 years ago.
Improve this questionCan anyone please suggest me a tool (preferably freeware) to insert data into a SQLite database? Most tools I've found allow you to only run queries, not insert.
The reason I need this, is because tables in he database contain BLOB fields, and I need to pre-feed data before deploying my application. And it's not really cool to do this in code.
Thanks!
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
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.
精彩评论