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

Jason S

Posted 2012-08-13T18:24:15.570

Reputation: 5 983

Answers

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:

Synetech

Posted 2012-08-13T18:24:15.570

Reputation: 63 242

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

tao

Posted 2012-08-13T18:24:15.570

Reputation: 1 355

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 – 2012-08-13T21:37:47.477

sorry on delay .. i use this one exclusively and never experienced crashes. although i cannot contest to using it on windows, so... – tao – 2012-08-13T23:17:48.300

There are online tools to query SQLite databases:

ExtendsClass: https://extendsclass.com/sqlite-browser.html This website allows to open SQLite file directly in the browser, without installation. You can open SQLite file, and view the contents of tables (just click on the name of the table).
SQLiteOnline: https://sqliteonline.com/ It is like the previous website, it is easy to use.

Cyril

Posted 2012-08-13T18:24:15.570

Reputation: 11

Welcome to Super User! Please read how to recommend software in answers, particularly the bits in bold; then edit your answer to follow the guidelines there. Thanks!

– bertieb – 2018-10-20T11:58:42.893

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.

allquixotic

Posted 2012-08-13T18:24:15.570

Reputation: 32 256

Check out TablePlus, it's a native app with sleek UI that works well with SQLite.

Also, check out the simple guide to using TablePlus

Hong Ng

Posted 2012-08-13T18:24:15.570

Reputation: 1

Welcome to Super User! Thank you for your contribution, but could you read how to recommend software in answers (especially the bit in bold) and update your answer so that it meets requirements. Thanks :)

– bertieb – 2018-04-17T06:10:36.293

SQLite Studio - cross platform free software (GPL license).

MarianD

Posted 2012-08-13T18:24:15.570

Reputation: 2 572