Convenient tool to insert data into SQLite database? [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. 开发者_运维问答

---

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 question

Can 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.