× Help save net neutrality! Learn more.
DB Browser for SQLite Icon

A light GUI editor for SQLite databases

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

  • 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
  • 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    The UI is really unconvenient.

    Posted 05/15/2013
  • 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
  • 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
  • 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
  • 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    What a bad design: everytime you switch tabs, it scans the whole db again - nice, if the db contains 800.000 records. Also bad: it reads the whole conten of the db into memory, ending up with consuming half a gig of ram. Might work on tiny db's - keep your fingers off this tool if you deal with bigger ones.

    Posted 05/04/2012
  • 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    Unusable because of https://sourceforge.net/tracker/?func=detail&aid=2936194&group_id=87946&atid=584909

    Posted 03/27/2012
  • 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    Cannot believe this has so many positive reviews. This is one of the worst pieces of software I have ever had the misfortune to try to use. The interface is incredibly clumsy, with poorly thought out data entry screens, and no attempt to remember file locations even within the same session. It locks up when I try to import a csv file. It locks up when I try to run a simple INSERT sql. I have nothing good to say about this.

    Posted 11/28/2010

Thanks for helping keep SourceForge clean.

Screenshot instructions:
Red Hat Linux   Ubuntu

Click URL instructions:
Right-click on ad, choose "Copy Link", then paste here →
(This may not be possible with some types of ads)

More information about our ad policies

Briefly describe the problem (required):

Upload screenshot of ad (required):
Select a file, or drag & drop file here.

Please provide the ad click URL, if possible:

Get latest updates about Open Source Projects, Conferences and News.

No, Thank you