Recommendation for Sqlite DB manager application?

Question

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

I use the SQLite manager plugin for Firefox.

It seems pretty stable to me.

Answer 2

For Windows: I've been looking for functionality and a comfortable GUI - it's been particularly hard to satisfy the latter requirement, but these two picks are both fine:

a) Good enough: SQLite Expert

Less expensive, fully featured manager. The author is very responsive to comments and bug reports, and publishes updates frequently. The flip side, if you look at version history, is that new releases seem to introduce new bugs, which are then fixed in sunsequent builds. The GUI is fine, very good for quickly designing new databases; a little less so for designing queries and working with large amounts of data. Main gripe: you can't see the schema while editing a query (without flipping tabs in the program).

b) Nearly perfect: SQLite Maestro

Pricier. Rich UI, easy access to all features, nice visual query builder and automatic SQL formatter for readability, lots of eye candy. There is a separate, more specialized query builder (SQLite Code Factory), but you can make do with just the main Maestro application. Main gripe: can't seem to be able to change font size for table display and the default is a little too small; at the beginning it's easy to get lost in the thicket of tabs, though overall I find the GUI very productive.

Both solutions are very stable in my experience, and both seem to offer occasional discounts, if you can afford to wait.

For just browsing data, try SQLite Spy - free and lets you execture queries, but no or little GUI support for editing. Very convenient for quick lookups though.

Answer 3

I've used Sqliteman in the past. Quite nice.

Answer 4

I like SQLite Administrator

Answer 5

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

Answer 6

Here's another free option. It has been pretty stable for me. SQLiteStudio

Answer 7

SQLite Spy is a good choice

Answer 8

If you're within Visual Studio most of the time then System.Data.SQLite is good, and as a plus handles encrypted databases.