DB Browser for SQLite versions

Create, design, and edit database files compatible with SQLite
3.9
Oct 8, 2016
Review
3.8
Dec 28, 2015
Review
3.7
Jun 15, 2015
Review
3.6
Apr 30, 2015
Review
3.5
Feb 1, 2015
Review
3.4
Oct 31, 2014
3.1
Nov 18, 2021
Editorial review
rating

What's new

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)

v3.6 [Apr 30, 2015]
Better SQL export
REGEXP support
NULL value highlighting
Brace matching, code folding, error highlighting, multi-line tab and shift tab, better code completion, help texts, etc.

v3.1 [Aug 22, 2017]
This is a minor bug fix release for most people, but does address one fairly important problem with the Windows installer for the previous (3.10.0) release.
That previous release included updated MSVC redistributables which rebooted some people's computers at the end of the install, without warning or even prompting to save files.
Thanks to a fix by @Mischanix, the installer now instructs the included MSVC redistributes not to reboot when it finishes. Problem solved.
Bug fixes:
General:
- cipher: Fix passphrases containing single quotes - #1105 (thanks to @MKleusberg).
- cipher: Change tab order in encryption dialog - 9afb0fc (thanks to @MKleusberg)
- Fix typo in Russian translation - #1107 (thanks to @Vort).
- Pass /norestart to vcredist installer - #1114 (thanks to @Mischanix).
- Fix index updating when removing an indexed column from a table - #1115 (thanks to @MKleusberg).
- Don't automatically commit all changes when editing a table column - #1116 (thanks to @MKleusberg).
- Make text selectable in Edit dock even if db is opened as read only - #1123 (thanks to @MKleusberg).
- Add 'NULL' filter - #1124 (thanks to @MKleusberg).
- Fix custom type saving when only focus changes for user-entered type - #1147 (thanks to @techee).
DBHub.io related:
- dbhub: Tweak certificate UI in the preferences dialog - #1087 (thanks to @MKleusberg).
- dbhub: Fix progress dialog for very large files - #1095 (thanks to @MKleusberg).
- dbhub: Remove closing "." from the progress dialog - #1095 (thanks to @MKleusberg).
- dbhub: Ask user what to do when trying to open an updated database - #1096 (thanks to @MKleusberg).
- dbhub: Enforce name and commit message length limits in push dialog - #1097 (thanks to @MKleusberg).
- dbhub: Add tooltip to cog tool button - #1111 (thanks to @MKleusberg).
- dbhub: Redownload database if local copy has been deleted - #1111 (thanks to @MKleusberg).
- dbhub: Fix wrong file size being shown for very large files - #1113 (thanks to @MKleusberg).
- dbhub: Support pushing to different branches than "master" - 5025e4d (thanks to @MKleusberg).
- dbhub: Improve file size format - fe7707d (thanks to @MKleusberg).
- dbhub: Optimise code - 876d938 (thanks to @MKleusberg).
- dbhub: Fix branch list in push dialog - 8021523 (thanks to @MKleusberg).

Alternative downloads

SQLite Expert Professional
SQLite Expert Professional
rating

Create, maintain, manage and organize SQLite databases.

DBConvert for SQLite & MySQL
DBConvert for SQLite & MySQL
rating

It allows to convert between SQLite databases and MySQL server.

DBConvert for SQLite and MSSQL
DBConvert for SQLite and MSSQL
rating

You can import SQLite databases to MS SQL server and MS SQL databases to SQLite.

Toad for Cloud Databases
Toad for Cloud Databases
Free
rating

It helps you generate queries, migrate, browse and edit data.

Sql CE Browser
Sql CE Browser
Free
rating

Browse and edit Microsoft SQL CE databases from your Windows Desktop.