Recommendation for Sqlite DB manager application?

Question

Closed. This question is off-topic. It is not currently accepting answers.

---

Want to improve this question? Update the question so it's on-topic for Stack Overflow.

Closed 6 years ago.

There are quite a few Sqlite GUI applications listed here:

http://www.sqlite.org/cvstrac/wiki?p=ManagementTools

some appear to be incomplete, buggy, not maintained, etc. Do you have any recommendations?

Answer 1

Navicat SQLite is very good and they support Windows, OS X and Linux too.

Answer 2

I've been using SQL Explorer. The firefox plugin is awesome, but it couldn't handle BIGINTs properly (it truncated them). I have noticed that the .jar driver doesn't seem to support FTS4 (but it does support FTS3) and doesn't show indexes in the data structure.

I like SQL explorer as you can use other providers like mySQL too with the one client.

Answer 3

I've been using SQLite Professional and it's been reliable. The only downside was that changes I made to the db via the iOS simulator didn't resolve in the app (I had to close it and reopen for changes to show) but that feature was added in a recent version. So now it does everything I need. I'm happy with the support. It's good for testing and I use it to build out the db structure. Never been buggy.

Answer 4

Sqlite.org has a list of management tools available here:

http://www.sqlite.org/cvstrac/wiki?p=ManagementTools

Answer 5

I like SQLite Administrator

Answer 6

You didn't mention a platform, so here's a great comparison of Mac OS X SQLite tools. I personally found MesaSQLite to be most like my preference for database tools, which was CocoaMySQL incidentally. (For Windows, I just used the Firefox add-on mentioned above.)