Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 presently use the sqlite-manager Firefox plugin but it doesn't provide either feature.

share|improve this question

SQLite Database Browser

enter image description here

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

share|improve this answer
That looks familiar (I recall testing an SQLite program that had the primitive looking toolbar that SQLDB has). If it’s the same one, then I recall it being troublesome and crashing. – Synetech Aug 13 '12 at 21:37
sorry on delay .. i use this one exclusively and never experienced crashes. although i cannot contest to using it on windows, so... – tao Aug 13 '12 at 23:17

There is a related question on StackOverflow.

share|improve this answer

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.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .