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

Spent the morning looking for a good Sqlite Database Manager/Browser and have settled on SqliteStudio, currently v2.20.28, which I'm running on Ubuntu Linux 10.04.

• The download is one 4.3MB uncompressed executable file. Period!
• It's fast, well-behaved, and uses modest resources.
• The interface is clean and attractive with logical functionality.
• I don't say this often, but it's just a "A Joy to Use".
• It was developed and is actively maintained by Pawel Salawa who is is to be commended for producing a very nice program.

I just used it to merge two Firefox FloatNotes databases (Sqlite v3), which just use a single table...

• The target database is on the local host where SqliteStudio is running (i.e. /0/LX02)
• The source database file is on a remote host mounted via SSHFS to /0/LX04
• Opened the two database files using Add Database.
• Used the SQL Editor to execute an INSERT to the LX02 database from a SELECT on the LX04.
• Click the Commit icon when all goes well or Rollback if there are errors to fix.
• Refresh the table data to see the inserted rows.

There's no Import GUI functionality but merging is pretty simple if you know SQL. I supplied NULL for the first column which is the unique-id primary-key so that Sqlite would autoincrement, thus renumbering the rows being merged in...

INSERT INTO [floatnotes.sqlite].floatnotes
SELECT NULL,
       url,
       protocol,
       content,
       x,
       y,
       w,
       h,
       color,
       status,
       guid,
       creation_date,
       modification_date
  FROM [floatnotes-LX04.sqlite].floatnotes;

Answer 2

If you want just CRUD operations on the sqlite database file, then SQuirreL is a very option as it has an auto complete feature which drastically improve the speed and efficiency of typing the sql queries.

To use the SQLite database in SQuirreL first download the JDBC driver of the SQLite from here then drop the jar in the lib folder of the SQuirreL folder. Now open SQuirreL and choose Create a New Driver. In the Example URL field put

jdbc:sqlite:$file_url

and in Class Name put

org.sqlite.JDBC

After that choose Create a New Alias and choose the driver that you just added and replace $file_url with the actual location of the sqlite file then click ok and you are done.

Answer 3

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 4

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

Answer 5

SQLiteSpy is a good choice

Answer 6

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