DB Browser for SQLite Icon

DB Browser for SQLite

A light GUI editor for SQLite databases

4.5 Stars (86)
198 Downloads (This Week)
Last Update:





Reason why we moved → http://blog.gluster.org/2013/08/how-far-the-once-mighty-sourceforge-has-fallen/


DB Browser for SQLite is a light GUI editor for SQLite databases, built on top of Qt. The main goal of the project is to allow non-technical users to create, modify and edit SQLite databases using a set of wizards and a spreadsheet-like interface.

Note - This project has previous been known as "SQLite Browser" and "Database Browser for SQLite". "DB Browser for SQLite" will hopefully be the name that sticks. :)

DB Browser for SQLite Web Site


User Ratings

ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 3 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 3 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 3 / 5
Write a Review

User Reviews

  • gleach31
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    I have a perfectly formed sqlite database, which can be read by other programs. DB Browser refuses to open it, claiming it is an invalid file format. There is little point in installing this software, as it seems to be incapable of handling an sqlite database. There are plenty of other programs out there which work correctly, and work on my own database. DB Browser seems to be the worst of them all.

    Posted 10/30/2014
  • perdevcoc
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    The UI is really unconvenient.

    Posted 05/15/2013
  • cdqe
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    Several glaring problems if you want to use this for real SQLite situations: 1) The user interface was apparently never tested for functionality or usability. (Just open a database and look at the garbled mess in the "Schema" column: the display code assumes that the definition has no line breaks within it!) The column widths in "Browse data" are fixed width and there is no quick way of resetting them to make things more visible/usable. And it goes on from there. 2) The app is not fully SQLite 3 compatible. Real SQLite accepts the full range of datatypes that MySQL does, and converts them to the "affinity" datatypes of SQLite on the fly. (See section 2.2 of "Datatypes In SQLite Version 3" {google for it}: you should be able to move almost all datatypes directly from a MySQL table-creation definition to an SQLite database without problem. [Indices and foreign key defs are a different matter.]) If you do use one of the non-affinity types in a database you try to load or an SQL script you try to import the app freezes. 3) This app does not handle both the ON DELETE and ON UPDATE constraints of foreign keys, indeed, it does not seem even to know what to do with foreign keys. It has no way that I've found of displaying their definitions or relationships. It parses the REFERENCES directive, but doesn't seem to know how to do anything with it. The command line processor, sqlite3.exe, that comes with the SQLite distribution, handles issues 2 & 3 without fuss, and gives you a much better feel for working directly within this dialect of SQL. Even without a GUI front, it's far better than this application can claim for itself.

    Posted 04/25/2013
  • marijamarija
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    This is the worst SQLite Manager ever!!!!!!!!!

    Posted 04/18/2013
  • oid-4069949
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    Quite well... but, this is not handling encoding right. You might want to review it. Thanks for sharing!

    Posted 12/01/2012
Read more reviews

Additional Project Details



Intended Audience

Developers, End Users/Desktop

User Interface

X Window System (X11), Win32 (MS Windows), Cocoa (MacOS X)

Programming Language

C++, C


Screenshots can attract more users to your project.
Features can attract more users to your project.