8

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.

Giacomo1968
  • 53,069
  • 19
  • 162
  • 212
Jason S
  • 7,503
  • 16
  • 60
  • 79

7 Answers7

3

There is a related question on StackOverflow.

Community
  • 1
Synetech
  • 68,243
  • 36
  • 223
  • 356
3

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
  • 1,415
  • 8
  • 11
  • 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
1

There are online tools to query SQLite databases:

Cyril
  • 11
  • 2
  • 1
    Welcome to Super User! Please read [how to recommend software in answers](https://meta.superuser.com/questions/5329/how-do-i-recommend-software-in-my-answers), particularly the bits in **bold**; then edit your answer to follow the guidelines there. Thanks! – bertieb Oct 20 '18 at 11:58
1

sqlite-gui is the most simplest GUI for Windows. I'm the author.

Features

... and more

enter image description here

Aikon Mogwai
  • 111
  • 3
1

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
  • 34,215
  • 7
  • 113
  • 145
0

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
  • 1
  • 1
  • Welcome to Super User! Thank you for your contribution, but could you read [how to recommend software in answers](https://meta.superuser.com/questions/5329/how-do-i-recommend-software-in-my-answers) (especially the bit in **bold**) and [update your answer](https://superuser.com/posts/1314692/edit) so that it meets requirements. Thanks :) – bertieb Apr 17 '18 at 06:10
0

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

enter image description here

enter image description here

MarianD
  • 2,666
  • 1
  • 17
  • 26