DB Browser for SQLite 3.8.0

@MKleusberg MKleusberg released this Dec 26, 2015 · 469 commits to master since this release

It is over 6 months since the previous version 3.7.0 was released and a lot has happened since, all the details on which are below and as you can see there is a lot! On MacOS X, this is our first release using Qt5, and it's worth noting we updated the underlying SQLite to version 3.9.2 (on both platforms) this is so we can support the changes made for 3.9.x which impact database schema, see https://www.sqlite.org/releaselog/3_9_2.html for these changes.

You will also notice a lot of "user experience" enhancements and fixes, so hopefully you will find this new release a pleasure to use. ๐Ÿ˜„
Happy Christmas!


  • Add proper file extension filters to all file dialogs - 6b8f57d (thanks to @MKleusberg)
  • Improved error handling, e.g. more error messages with more detailed error descriptions - #362, #363, 1696ad1 (thanks to @schdub and @MKleusberg)
  • Allow changing table columns even when there is a foreign key constraint on the table - #362 (thanks to @MKleusberg)
  • When holding Ctrl and Shift while clicking on a cell with a foreign key set, the browser now jumps to the referenced record - #192 (thanks to @MKleusberg)
  • Add option for disabling the SQL error indicators in the Execute SQL area - #302 (thanks to @MKleusberg)
  • Add an option for setting the colours of fields with regular and binary data - #377 (thanks to @schdub)
  • Use the name of the imported file as default suggestion for a table name during CSV import - #376 (thanks to @MKleusberg)
  • Save filter values, sort order and column widths for all tables when switching the current table or tab; also save the settings in the project file - 748f06d (thanks to @MKleusberg)
  • Show a small clear button inside each filter box - 944e22a (thanks to @MKleusberg)
  • Add basic support for different 'display formats', i.e. a conversion of the contents of a column into a different format for display purposes (e.g. converting a Unix epoch into an actual date) - 7c1d237, 22e858d (thanks to @MKleusberg)
  • Remove deleted files from list of recently opened files - #379 (thanks to @MKleusberg)
  • Add a new option for horizontal tiling of the code and result view in the Execute SQL area - #380 (thanks to @MKleusberg)
  • Move execution time of the SQL statement to the top of the result view in the Execute SQL area - #381 (thanks to @MKleusberg)
  • Add 'x rows affected' information to the result view of the Execute SQL area - 82292c2 (thanks to @MKleusberg)
  • Add built-in UTF16 and UTF16CI collation - #391 (thanks to @sebastian-philipp)
  • Add Ctrl+R shortcut (besides F5) for the refresh table button - #388 (thanks to @MKleusberg)
  • Add option for setting the font and font size of the text in the table browser view - #383 (thanks to @MKleusberg)
  • Support opening of read only database files - #402 (thanks to @MKleusberg)
  • Add option for showing the rowid column in the data browser view - #408 (thanks to @MKleusberg)
  • Add option for showing the text in the data browser view using a different encoding - #414 (thanks to @MKleusberg)
  • Add option for setting an escape character for the filters in the data browser - #421 (thanks to @MKleusberg)
  • Add a small delay before applying a new filter value instead of performing an instantaneous search to improve performance on large tables - #415 (thanks to @MKleusberg)
  • Automatically add '%...%' wildcards to a filter query - #415 (thanks to @MKleusberg)
  • Add Delete and Alt+Delete keyboard shortcuts for setting the current cell to empty string or NULL in the data browser view - #443 (thanks to @MKleusberg)
  • Add new option for moving the Edit cell data dialog into a dock which is locked to the main window and stays opened - #416, #440, #441 (thanks to @MKleusberg)
  • Allow drag-&-dropping text and files on a cell in the data browser - #441 (thanks to @MKleusberg)
  • Add keyboard shortcuts for recently opened files - #432 (thanks to @MKleusberg)
  • Add new option for setting a SQL script which gets executed whenever any database file is opened - #451 (thanks to @MKleusberg)
  • Allow pasting data (e.g. from a spreadsheet) directly into the data browser view - #453 (thanks to @MilosSubotic)

Bug fixes

  • Fix missing SQL log when query contains a line break, also trim the log - #337, #356 (thanks to @schdub and @MKleusberg)
  • Also set foreign key settings when creating a new database instead of just setting them when opening a file - 212116a (thanks to @MKleusberg)
  • Fix drawing of Unicode characters in the SQL editor where the font settings wouldn't apply as they should have - #365 (thanks to @SevenLines)
  • Allow values greater than 10000 in the user_version pragma of a database - #366 (thanks to @schdub)
  • Fix adding new a record into a table where all fields are set to a default value - #369 (thanks to @schdub)
  • Fix resizing of the code and result view in the Execute SQL area - 6806a9b (thanks to @MKleusberg)
  • Fix error message when changing table - #390 (thanks to @MKleusberg and @GeorgijK)
  • Fix parsing of double backticks and double quotes used to escape a single one in create table statements - 160bc87, dce47b3 (thanks to @MKleusberg)
  • Fix handling of tables when their name contains a backtick - #387 (thanks to @MKleusberg)
  • Try to set a better window position when opening the Edit cell data dialog - #342, #394 (thanks to @MKleusberg)
  • Fix possible infinite loop in the Edit cell data dialog - #444 (thanks to @manisandro)
  • Fix bug when pressing the cancel button in the dialog you see when you're closing a database with unsaved changes - #432 (thanks to @MKleusberg)
  • Don't allow conflicting field names in the Edit Table dialog - #460 (thanks to @MKleusberg)


Cross platform fixes

Notes for the MacOS X binaries

  • The OSX binaries were built on an OSX 10.9.5 system, and should be backwards compatible with OSX 10.7 and above (that's the theory anyway... ๐Ÿ˜‰)
  • OS X 10.6 is no longer supported - DB4S always crashes on it, and we haven't been able to figure out why. OSX 10.7 and above work well though. If someone wants to investigate this in depth and get OSX 10.6 working again, that would be useful ๐Ÿ˜
  • The normal release on OSX (without SQLCipher support), bundles SQLite 3.9.2
  • The SQLCipher supporting release on OSX bundles SQLCipher 3.3.1 (based on SQLite If you need features from the new SQLite 3.9.x series, you'll have to do without SQLCipher support for now


  • sqlitebrowser-3.8.0-win32v3.exe
    • 6013b6f0ba372ed905046b1df990e2dda3ba559df88fdc6da812f00c0000c7e3
  • sqlitebrowser-3.8.0-win64v2.exe
    • f632d94d2aedb9591ca36097d2510891fde8548d1ab420b4891700dd516d15ac
  • sqlitebrowser-3.8.0v5.dmg
    • b32597066279442e67e363dab9d89cf2533a6624f3a769b0d2681e22552ed3eb
  • sqlitebrowser-with_sqlcipher_support-3.8.0v5.dmg
    • 97fcdd0fac7ab96ccea528afa959bf77760c1c80c044313e96db19ab5ef4a9ce
  • SQLiteDatabaseBrowserPortable_3.8.0_English.paf.exe
    • 3d2a4fe1248245827639c5fa409a06378368e8409a61bcac4934f50f0237ef53