12

I'm working with SQLite. The database is used by a software. For some purposes I have to see the database and edit it. Can anyone recommend me software for doing this?

Requirements:

  • Show database/tables
  • Edit database/tables
  • Show overview about database (all tables and linked tables)
  • Execute SQL statements
  • Autocomplete function for SQL statements
  • Link tables
  • Easy to handle

At the moment I use SQLiteStudio, but it is not able to show a graphical overview about the tables of a database.

The software should run on a PC under Windows.

| improve this question | |
12

You could take a look at SQLite Expert. This application has a large number of features and is available in both a free and a paid version (which has more features like data importing from various file formats, exporting to various file formats, more drag and drop database manipulation, automatic query generation and some repair tools).

You can take a look at the full and comprehensive feature list on the SQLite Expert website but relating specifically to your list of requirements:

  • Has a graphical interface which shows databases and tables
  • Allows editing of databases and tables
  • Shows an overview of the database showing all tables
  • Allows the execution of SQL queries

Here are a couple of screenshots of SQLite Expert from their website:

enter image description here

enter image description here

Additionally, SQLite Expert can be customised further with skins and plugins to add further functionality.

| improve this answer | |
  • Nice one, Flyk! Might it be worth mentioning here that there's a cost-free "personal edition", as well as a "professional edition" for ~$60, and what the major differences are between the two? (+1 meanwhile from me ;) – Izzy♦ Feb 13 '14 at 12:38
  • I had kinda hinted at that but I've fleshed it out a bit. – Flyk Feb 13 '14 at 12:41
  • Mee too, checking for it; didn't see a price tag, and thus completely missed you mentioned "free" and "paid" ;) Thanks for the update! – Izzy♦ Feb 13 '14 at 12:55
  • As of Oct, 2016, the Visual Query Builder has been removed from the Free edition, is only available in the Pro edition. For Linux users: The software runs under wine (works for me without much tinkering). – knb Oct 18 '16 at 12:16
5

I'm using Sqliteman to work with my SQLite databases. One reason for my selection was I can invoke it from the command-line while passing the database file to work with.

Requested features:

  • Show database/tables: Sure.
  • Edit database/tables: Yes.
  • Show overview about database: in a tree-structure, so you can dive in where you like.
  • Execute SQL statements: Features an SQL editor with syntax highlighting etc.
  • Autocomplete function for SQL statements: Supported
  • Link tables: Not sure what you mean by that, sorry
  • GUI: See screenshots
  • Easy to handle: a little subjective, but I'd say "yes".

Editor on Linux Design a table on Windows
Selected screenshots: SQL editor (on Linux), graphical Table-designer (on windows); click images for larger variants

Personal notes:

As mentioned initially, there are some other criteria to count on the plus-side:

  • possibility to start the GUI from command-line, passing the database file to work with as argument
  • support for many platforms, including Linux, Mac OS, OS/2, Windows
  • graphical query-builder for those unfamiliar with SQL (or simply in need of some assistance)
  • free (as in "free beer", i.e. cost-free)
| improve this answer | |
1

"DB Browser for SQLite" (DB4S)

seems to do most of what you require, though I am uncertain about the "link" functionality.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.