As its name clearly suggests, this program is a visual browser for databases of the popular SQLite database engine. The program allows you to create, edit and manage databases, tables and indexes, as well as insert, remove or modify records, all in a simple and easy-to-understand environment. You can also import and export databases, tables and records either as text, CSV files or SQL code.
In my opinion, the program's user interface is a bit dull and colorless. It is composed of several panels where you can perform all the required operations in your database and/or tables and cells. The main panel offers you four tabs where you can visualize your database's structure, browse and edit your data, edit your pragmas and directly execute customized SQL commands in case you need or prefer to do so. Another of the panels, in turn, also allows you to rotate among a SQL log, a plot graphic, your database schema and a log about your transactions with remote SQLite servers, as DB Browser for SQLite also allows you to connect to them. Finally, you also have a third panel that allows you to comfortably visualize and optionally edit a cell's content through a big box, either in text, binary or image modes.
SQLite is a lightweight and soft database engine which is not usually employed for production environments, however, in many cases it's perfect for design and testing purposes. While the original designers of this database engine didn't include an official browser, the developers of DB Browser for SQLite did a really great job creating this practical and lightweight tool, and making it available for free. So, if you are a software developer or a database designer who usually works with SQLite databases, and you haven't yet, you should try DB Browser for SQLite as soon as possible.
v3.7 [Jun 15, 2015]
Enhancements
Remove superfluous whitespace from Schema column in DB Structure view - #283 (thanks to @MKleusberg)
Add option to remember last location for file dialogs - #224, #276, #281 (thanks to @MKleusberg)
Add option for setting the font used in the SQL code editor - #299 (thanks to @MKleusberg)
Preserve filters in Browse Data tab when changing tabs - #305 (thanks to @schdub)
Allow setting the line type and the point shape in the plot area - #317 (thanks to @schdub)
Add a 'Copy Create statement' popup action to Database Browser tab - #140 (thanks to @MKleusberg)
Bug fixes
Fix UTF-8 characters in SQL code editor - #282 (thanks to @MKleusberg)
Make sure to always show text data (instead of 'BLOB') in Browse Data tab no matter the column's data type in the table definition - 517ecec (thanks to @schdub)
EditTableDialog: Add '=' in front of default value when it is a function - #166 (thanks to @MKleusberg)
Fix a couple of typos - abc432f (thanks to @mafagafogigante)
Fix incorrect extra ');' after create table statement in exported SQL - #349 (thanks to @schdub)
Regexp cannot handle NULL text - #353 (thanks to @MKleusberg)
Updated translations
Update Russian translation - 07af4b6 (thanks to @schdub)
Add a Brazilian Portuguese translation - #328 (thanks to @mafagafogigante)
Add an English (United Kingdom) translation - 0f68c85 (thanks to @glawrence)
Feature-rich relational database known for its high performance and excellent concurrency
