Easy and simple SQLite database GUI?

I'm looking for a really simple GUI that interfaces with an SQLite database to facilitate editing/searching a single table, which includes:

• Editing the table in tabular format, like a spreadsheet (not requiring the extra clicks to edit individual fields)

• "live search" filtering of the table

I currently use the SQLite Manager Firefox add-on but it doesn't provide either feature.

Solution 1:

There is a related question on StackOverflow.

• SQLite Administrator is easy to use:

  

• SQLite Manager is a little less user-friendly, but offers a web interface:

  

• phpSQLiteAdmin is another web-interface that is relatively easy to use:

  

Solution 2:

SQLite Database Browser

SQLite Database Browser is a freeware, public domain, open source visual tool used to create, design and edit database files compatible with SQLite. It is meant to be used for users and developers that want to create databases, edit and search data using a familiar spreadsheet-like interface, without the need to learn complicated SQL commands. Controls and wizards are available for users to:

• Create and compact database files
• Create, define, modify and delete tables
• Create, define and delete indexes
• Browse, edit, add and delete records
• Search records
• Import and export records as text
• Import and export tables from/to CSV files
• Import and export databases from/to SQL dump files
• Issue SQL queries and inspect the results
• Examine a log of all SQL commands issued by the application

Download: V1.3 - or - v2.0 beta1

Solution 3:

I love DbVisualizer and Squirrel SQL -- both are great tools, and are compatible with sqlite.

Check out this page for info about DbVis's graphical table editing features.