Softpedia >Windows >Portable Software >Database Utils >Portable DB Browser for SQLite >  Changelog

Portable DB Browser for SQLite Changelog

What's new in Portable DB Browser for SQLite 3.12.2

May 18, 2021
  • The changes in this over the 3.12.1 release include:
  • Fix saving the list of extensions in the Preferences dialog (bd0e1feead6bb446f8a703338aa9893bf281e5b4)
  • Corrected a typo in the French translation (3bbd4ee271f98301476143749f7bf4abed052efe)
  • Updated the included SQLite and SQLCipher libraries to their latest release (SQLite 3.35.5, SQLCipher 4.4.3)
  • Updated the "public" certificate, used for communicating with DBHub.io anonymously (d85953c291b5f0bb467e2c12dfa4438f997d4f28)

New in Portable DB Browser for SQLite 3.12.1 (Nov 9, 2020)

  • Enhancements:
  • Completely reworked interface for accessing DBHub.io
  • Add .Net DateTime.Ticks to list of supported display formats (#2378)
  • Add more options for setting font sizes (#2306)
  • New predefined settings for simplified window layout (#2307)
  • Bug fixes:
  • Fix loading of project files with empty filter values (#2288)
  • Fix initial table view when using the -t / --table command line option (#2113)
  • Add status message when opening a file from the recent file list (4dfe4f7)
  • Make sure to not show "NULL" for empty but non-NULL values in the Edit dialog (#2204)
  • Fix plot being drawn before all data is loaded (#2286)
  • Restore original default for having condition format in filter line (f28ecc0)
  • Fix default font in the format toolbar (c4b2ffc)
  • Improve binary detection for cases starting by chance by a BOM (#2197)
  • Make sure the order of the statements in the SQL log is correct (05db901)
  • Fix executing selected SQL text when there are multi-byte characters (#2311)
  • Fix executing SQL queries with compound operators (#2316)
  • Fix SQL import of files with BOM (#2323)
  • Also update schema when clicking the Refresh button in Browse Data tab (16c3d8d)
  • Select column in table results when column header is pressed (#2343)
  • Tweak the output wording for command line options (#1069)
  • Remove the default property of the cancel button in the "Fetching data..." dialog (#2383)
  • Fix not being saved and not applied when modifying database cells in Windows external program (f2d8f79)
  • Fix incorrect display of SQL calltips containing non-US-ASCII characters (9f7851b)
  • Fix to 'Window Layout' options work properly (#2435)
  • Building and packaging:
  • Fix CMake warning during compilation (115aa00)
  • snap: Add environment variables to set Qt theme (7b5d652)
  • Updated to OpenSSL 1.1.1h for the Windows and macOS builds
  • Platform specific:
  • No longer force Light theme on macOS when "Follow the desktop style" is chosen (508118f)
  • Keep registry key consistent on Windows (#2328)
  • Allow use of integrated graphics card instead of high performance graphics card in macOS (#2377)
  • Use native path separators in Preferences dialog (f38b829)
  • Added message box for informative command line arguments for Windows (#1069)
  • Translations:
  • Remove all translations of key shortcuts (0070a15)
  • Update of the Korean translation (#2329, 82accb2)
  • Update of the Spanish translation (551a420)
  • Update of the Japanese translation (#2407)
  • Update of the French translation (2803da3)
  • Update of the Arabic translation (1dfa70c)
  • Fixes in the Spanish translation (4791b99, 5d85ca1, 454fd4a)
  • Fixes in the French translation (90d33c6, 0375206)
  • Update of the German translation (#2415)
  • Update of the Italian translation (#2419)
  • Update of the Portuguese translation (#2418)
  • Update of the Chinese translation (#2421)
  • Add of the Dutch translation (#2424)

New in Portable DB Browser for SQLite 3.12.1 RC 1 (Sep 27, 2020)

  • Enhancements:
  • Completely reworked interface for accessing DBHub.io
  • Add .Net DateTime.Ticks to list of supported display formats (#2378)
  • Add more options for setting font sizes (#2306)
  • New predefined settings for simplified window layout (#2307)
  • Bug fixes:
  • Fix loading of project files with empty filter values (#2288)
  • Fix initial table view when using the -t / --table command line option (#2113)
  • Add status message when opening a file from the recent file list (4dfe4f7)
  • Make sure to not show "NULL" for empty but non-NULL values in the Edit dialog (#2204)
  • Fix plot being drawn before all data is loaded (#2286)
  • Restore original default for having condition format in filter line (f28ecc0)
  • Fix default font in the format toolbar (c4b2ffc)
  • Improve binary detection for cases starting by chance by a BOM (#2197)
  • Make sure the order of the statements in the SQL log is correct (05db901)
  • Fix executing selected SQL text when there are multi-byte characters (#2311)
  • Fix executing SQL queries with compound operators (#2316)
  • Fix SQL import of files with BOM (#2323)
  • Also update schema when clicking the Refresh button in Browse Data tab (16c3d8d)
  • Select column in table results when column header is pressed (#2343)
  • Tweak the output wording for command line options (#1069)
  • Remove the default property of the cancel button in the "Fetching data..." dialog (#2383)
  • Building and packaging:
  • Fix CMake warning during compilation (115aa00)
  • snap: Add environment variables to set Qt theme (7b5d652)
  • Platform specific:
  • No longer force Light theme on macOS when "Follow the desktop style" is chosen (508118f)
  • Keep registry key consistent on Windows (#2328)
  • Allow use of integrated graphics card instead of high performance graphics card in macOS (#2377)
  • Use native path separators in Preferences dialog (f38b829)
  • Added message box for informative command line arguments for Windows (#1069)
  • Translations:
  • Remove all translations of key shortcuts (0070a15)
  • Update of the Korean translation (#2329, 82accb2)
  • Update of the Spanish translation (551a420)
  • Update of the Japanese translation (#2407)
  • Update of the French translation (2803da3)
  • Update of the Arabic translation (1dfa70c)
  • Fixes in the Spanish translation (4791b99, 5d85ca1, 454fd4a)
  • Fixes in the French translation

New in Portable DB Browser for SQLite 3.12.0 (Jun 16, 2020)

  • All Enhancements:
  • Make use of the enhanced ALTER TABLE features in SQLite 3.25.0 (5ec03ba)
  • Allow specifying an ON CONFLICT strategy in the Import CSV dialog (#1585)
  • Add option to remember last location per action type when saving and loading (#1587)
  • Add conditional formats to the Browse Data tab (#1503, #1815, #1976)
  • Show current database action and add a cancel button in status bar (11ace1e)
  • Save read-only state in the project file (#1598)
  • Add support for filtering by regular expressions using the /regexp/ syntax (#1522)
  • More efficient table editing. When editing the schema, do all changes in one go at the end (#1444, #1686)
  • Add comment/uncomment feature to the SQL editor (#1614)
  • Add option to find and replace in the selection in the SQL editor (#1618)
  • Execute SQL statements in a different thread, allowing long-running queries to be cancelled (1f9101a)
  • When editing a cell with a foreign-key, show a list of possible values in a dropdown list (#614, #1550)
  • Many small performance improvements (#1666, 7f597d0, e16537d, 9c0b36d, 5589bd9, a43e6a9, 66f9e69, a0b8b6f, fad8a84, 4e8eff7, ba1270c, 317918d, ff86e52, 1bab387)
  • Lots of UI reworking, allowing more flexibility, adding new shortcuts, fixing glitches, and making it more responsive. Some of the new settings are stored in the project file while the handling of project files itself is improved too (#459, #620, #788, #815, #1493, #1608, #1614, #1647, #1675, #1678, #1684, #1706, #1762, #1763, #1889, #1904, #1941, #1965, #1968, #1976, #2025, #2027, #2038, #2062, #2083, 8f32d15, 7541a82, 74befa3, fa3a844, ad15e7a)
  • New Save Project As menu item (#1706)
  • Ask the user whether to save modified SQL tabs when closing, add a new button to save changes in all open tabs, prompt to save changes in the project when closing the database or the application (#871, #1386, #1706, 71fc484)
  • Allow custom display formats (#573, #1720)
  • Add new log to the SQL log dock which prints the SQLite error log (#1754)
  • New setting allowing to set a dark style using a style-sheet (#1751, #1493, #1738)
  • Add support for sorting by multiple columns in the Browse Data tab and add a button to clear sort orders (#1761, #1810)
  • Add support for inserting rows into views with appropriate triggers (#141)
  • Enable build against external QCustomPlot (#1784)
  • Improved text editor in the Edit Cell dock (45c1e2a, #1796)
  • New command-line argument for saving settings (3e92ec2)
  • Show some information about the selected data when selecting cells in the Browse Data tab (4d5e841, 25715bb)
  • Detect changes in SQL files made by other programs (#1839)
  • Add a full find dialog to all text editors (#1746)
  • Add constraint editing to the Edit Table dialog (ad60a01, cd748d0, 3f60142, 9d654a1, 05e2def, a9e6fe4)
  • Include a built-in certificate which allows out-of-the-box read-only access to dbhub.io (b70e25c)
  • Support all Unicode quote and escape characters in the Import CSV dialog (#1860, #2012)
  • Add proxy support to dbhub.io functionality (#979)
  • Add "Browse Table" action to the context menu of the DB Structure dock (#1943)
  • Remember read-only flag for recent files list (#1913)
  • Extended regular expression support in the find dialogs (#1625)
  • Add duplicate tab feature to Execute SQL area (#1964)
  • Prompt user for options after dropping files (#1883)
  • Allow changing the collation of columns in the Edit Table dialog (#1973)
  • Add global filter field to Browse Data tab (#1608, #1662)
  • Support inline preview of image data in cells (#2000)
  • Add move field to top/bottom buttons to Edit Table dialog (#1988)
  • Add a find and replace toolbars to the Browse Data tab (#1608)
  • Add a toolbar for direct formatting of columns, rows, and single cells in the Browse Data tab (#1976)
  • Support custom SQLCipher cipher_plaintext_header_size (6b8fb51)
  • Add support for parsing, browsing, and editing tables with GENERATED ALWAYS AS columns (#2107)
  • Use the column type affinity for the default text alignment in the Browse Data tab (#2032)
  • Resize columns according to contents (#2006)
  • Allow opening of URLs or filenames from database cells and add a button to insert a link to the file into the cell (#1597)
  • Allow editing of the contents of database cells in external applications (#1746, #1791)
  • Add support for a secondary Y-axis to the plot area (#2026, #2131)
  • Drop close buttons on every Execute SQL tab(x) (#1968)
  • Show a useful icon in SQL tabs (#2153)
  • Open SQL tabs for modifying views and triggers (#2174)
  • Fix logo issues (#2184)
  • Install the AppStream file to the canonical location (#2195)
  • Open a set of SQL-Files (#2207)
  • Consistent naming of DB Browser for SQLite (#2224)
  • Minor: Change "Filter in all columns" => "Filter in any column" (#2233)
  • Avoid unchanged translation of keyboard shortcuts to work around problems (#2235)
  • Rearrange preferences database (#2240)
  • Use port 443 for DBHub.io traffic, to be more enterprise firewall friendly (c0cc696)
  • Application icon cleanup (#2270)
  • Update to Windows Icon Generation script (#2275)
  • All Bug fixes:
  • Avoid setting the database dirty with some trailing whitespace and comments (#1543)
  • Use native and localised names for shortcuts in the tool-tips (#721)
  • Add macOS .dylib extension to the extension selector dialog (66e3322)
  • Do not show more than 512 characters in DB Structure tooltips (#1659)
  • Load all pending data when select all is requested (#1373)
  • Make the Edit Cell Dock to update with the selected cell in SQL results (#481)
  • Fix selecting columns in Browse Data tab instead of sorting them (#1717)
  • Fix detection of XML data, some types of text data, and large numbers in the Edit Cell dock (3eebffd, 7d85d7a, #1846)
  • Fix default collations and callbacks when creating a new database (5c727e8)
  • Lots of bug fixes in the SQL parser (e828beb, cb694dd, 3f7b108, 3237e9d, #1950, #1969, #1990)
  • Always set sort direction to ascending when sorting a different column (00bc7db)
  • Fix problems with the JSON export (#1789)
  • Fix problems after closing a database (#1800)
  • Fix syntax highlighting to exactly match the SQLite keywords (fa66937)
  • Fix deleting from WITHOUT ROWID table (b788e2d)
  • Fix editing data in WITHOUT ROWID tables with multiple primary key columns (#516, #1075, #1834)
  • Silence some unnecessary warning messages (#1868, f877f8a, 99c7523)
  • Fix licence list in dbhub.io push dialog (16768d5)
  • Fix loading last used settings in the Import CSV dialog (cec6b82)
  • Fix setting last modified date when cloning a dbhub.io database (4cf6cb7)
  • Fix possible crash when loading a corrupt project file (30d0b18)
  • Include transaction statements in the SQL log (#1859, #1901)
  • Fixes for editing cells with RTL texts (#1793, #1929)
  • When updating a field try to respect the affinity data type if possible (#1592)
  • Fix value in size column of dbhub.io panel for very large databases (622ef9d)
  • Fix plotting data with NULL values by leaving gaps in the graph (#1977)
  • Fix importing CSV files with quote characters and no final line break and with only one column and no final line break (#193, #1986)
  • Escape filepath when attaching database (#2002)
  • Fix foreign-key editor not working correctly in Edit Table dialog (#1991)
  • Fix issues with resizing and with hiding a column (#1999)
  • Fix editing in tables with custom display formats (6f7fb74)
  • Fix problems with greediness in the DB4S implementation of the SQLite REGEXP operator (#2040)
  • Check if some column has a NOT NULL constraint in "Set to NULL" (#2021)
  • Fix error indication and savepoint handling after failed statements (#2073)
  • Make SQL editor in Edit Table dialog read-only (#2078)
  • Fix some problems with view editing in Browse Data tab (#2091)
  • Fix handling of databases with a view and a trigger with the same name (#2091)
  • Never mark the DB dirty if it is read-only (#1514)
  • Fix the recordset numbers in the Browse Data tab (cee3523, 13742c4)
  • Fix some typos and translation problems (3904710, 0db3c1e, 29db270, 1d1afaa, fe88463)
  • Fix dotenv not working for databases encrypted using SQLCipher 3 (7702354)
  • Fix dotenv not working when not specifying the plaintext header size (281cfe7)
  • Crash when -t option specifies missing table (#2180)
  • Translations:
  • Add Japanese translation (#2122, #2130)
  • Update Russian translation (faaa282)
  • Update Chinese translation (0282421)
  • Update Polish translation (5503667, 22a8cc0)
  • Update Portuguese translation (#2126)
  • Update French translation (daedace, d8b25e0)
  • Update Spanish translation (721ace4)
  • Update Turkish translation (#2133)
  • Update Italian translation (#2136, #2141)
  • Update German translation (#2137)
  • Update Arabic translation (#2146)
  • Update Simplified Chinese translation (#2145)
  • Update German translation for v3.12.x (#2277)
  • Updates the Brazilian Portuguese files for 3.12.0 (#2278)
  • Portuguese updates for 3.12 (#2280)
  • Update Japanese Translation for v3.12.x (#2281)
  • Update zh translation (#2282)
  • Packaging and Building:
  • Antlr is removed as a dependency
  • Niels Lohmann's JSON library is added as a dependency. A copy of the library is included in the source code.
  • Update bundled QScintilla library to version 2.11.1 (e392e64)
  • Update bundled QHexEdit2 library to version 0.8.6 (d4401f9)
  • Update bunbled QCustomPlot library to version 2.0.1 (#2119)
  • Update bundled QDarkStyleSheet to version 2.8 (3b2dec4)
  • More flexibility to override library paths (9f28851, b4af221, 800a8da, a692c06, #1784)
  • Add support for building with cmake 3.11 and later (#1361)
  • cmake installation on macOS also copies the icon and desktop files (#1723)
  • Add workaround for Qt bugs QTBUG-68891 and QTBUG-71020 (#1658)
  • Include a new SQLite extension for encoding and decoding base64 and decoding plist data (#1716, #1804)
  • Include the fileio, soundex, r-tree, and geopoly extensions (0d25d11, 5bf9015, 6565cdc)
  • Raise the maximum number of attached databases to 125 when using the bundled SQLite version (402af87, b0bca10)
  • Add MIME information file (#2024)

New in Portable DB Browser for SQLite 3.12.0 RC1 (Jun 8, 2020)

  • The changes in this from the alpha1 release:
  • 1968 - Drop close buttons on every Execute SQL tab(x).
  • 2153 - Show a useful icon in SQL tabs
  • 2174 - Open SQL tabs for modifying views and triggers
  • 2180 - Crash when -t option specifies missing table
  • 2184 - Fix logo issues
  • 2193 - Update German translation
  • 2195 - Install the AppStream file to the canonical location
  • 2207 - Open a set of SQL-Files
  • 2224 - Consistent naming of DB Browser for SQLite
  • 2233 - Minor: Change "Filter in all columns" => "Filter in any column"
  • 2235 - Avoid unchanged translation of keyboard shortcuts to work around problems
  • 2240 - Rearrange preferences database
  • c0cc696 - Use port 443 for DBHub.io traffic, to be more enterprise firewall friendly
  • 2270 - Application icon cleanup
  • 2275 - Update to Windows Icon Generation script

New in Portable DB Browser for SQLite 3.12.0 Alpha (Apr 15, 2020)

  • All Enhancements:
  • Make use of the enhanced ALTER TABLE features in SQLite 3250 (5ec03ba)
  • Allow specifying an ON CONFLICT strategy in the Import CSV dialog (#1585)
  • Add option to remember last location per action type when saving and loading (#1587)
  • Add conditional formats to the Browse Data tab (#1503, #1815, #1976)
  • Show current database action and add a cancel button in status bar (11ace1e)
  • Save read-only state in the project file (#1598)
  • Add support for filtering by regular expressions using the /regexp/ syntax (#1522)
  • More efficient table editing When editing the schema, do all changes in one go at the end (#1444, #1686)
  • Add comment/uncomment feature to the SQL editor (#1614)
  • Add option to find and replace in the selection in the SQL editor (#1618)
  • Execute SQL statements in a different thread, allowing long-running queries to be cancelled (1f9101a)
  • When editing a cell with a foreign-key, show a list of possible values in a dropdown list (#614, #1550)
  • Many small performance improvements (#1666, 7f597d0, e16537d, 9c0b36d, 5589bd9, a43e6a9, 66f9e69, a0b8b6f, fad8a84, 4e8eff7, ba1270c, 317918d, ff86e52, 1bab387)
  • Lots of UI reworking, allowing more flexibility, adding new shortcuts, fixing glitches, and making it more responsive Some of the new settings are stored in the project file while the handling of project files itself is improved too (#459, #620, #788, #815, #1493, #1608, #1614, #1647, #1675, #1678, #1684, #1706, #1762, #1763, #1889, #1904, #1941, #1965, #1968, #1976, #2025, #2027, #2038, #2062, #2083, 8f32d15, 7541a82, 74befa3, fa3a844, ad15e7a)
  • New Save Project As menu item (#1706)
  • Ask the user whether to save modified SQL tabs when closing, add a new button to save changes in all open tabs, prompt to save changes in the project when closing the database or the application (#871, #1386, #1706, 71fc484)
  • Allow custom display formats (#573, #1720)
  • Add new log to the SQL log dock which prints the SQLite error log (#1754)
  • New setting allowing to set a dark style using a style-sheet (#1751, #1493, #1738)
  • Add support for sorting by multiple columns in the Browse Data tab and add a button to clear sort orders (#1761, #1810)
  • Add support for inserting rows into views with appropriate triggers (#141)
  • Improved text editor in the Edit Cell dock (45c1e2a, #1796)
  • New command-line argument for saving settings (3e92ec2)
  • Show some information about the selected data when selecting cells in the Browse Data tab (4d5e841, 25715bb)
  • Detect changes in SQL files made by other programs (#1839)
  • Add a full find dialog to all text editors (#1746)
  • Add constraint editing to the Edit Table dialog (ad60a01, cd748d0, 3f60142, 9d654a1, 05e2def, a9e6fe4)
  • Include a built-in certificate which allows out-of-the-box read-only access to dbhubio (b70e25c)
  • Support all Unicode quote and escape characters in the Import CSV dialog (#1860, #2012)
  • Add proxy support to dbhubio functionality (#979)
  • Add "Browse Table" action to the context menu of the DB Structure dock (#1943)
  • Remember read-only flag for recent files list (#1913)
  • Extended regular expression support in the find dialogs (#1625)
  • Add duplicate tab feature to Execute SQL area (#1964)
  • Prompt user for options after dropping files (#1883)
  • Allow changing the collation of columns in the Edit Table dialog (#1973)
  • Add global filter field to Browse Data tab (#1608, #1662)
  • Support inline preview of image data in cells (#2000)
  • Add move field to top/bottom buttons to Edit Table dialog (#1988)
  • Add a find and replace toolbars to the Browse Data tab (#1608)
  • Add a toolbar for direct formatting of columns, rows, and single cells in the Browse Data tab (#1976)
  • Support custom SQLCipher cipher_plaintext_header_size (6b8fb51)
  • Add support for parsing, browsing, and editing tables with GENERATED ALWAYS AS columns (#2107)
  • Use the column type affinity for the default text alignment in the Browse Data tab (#2032)
  • Resize columns according to contents (#2006)
  • Allow opening of URLs or filenames from database cells and add a button to insert a link to the file into the cell (#1597)
  • Allow editing of the contents of database cells in external applications (#1746, #1791)
  • Add support for a secondary Y-axis to the plot area (#2026, #2131)
  • All Bug fixes:
  • Avoid setting the database dirty with some trailing whitespace and comments (#1543)
  • Use native and localised names for shortcuts in the tool-tips (#721)
  • Add macOS dylib extension to the extension selector dialog (66e3322)
  • Do not show more than 512 characters in DB Structure tooltips (#1659)
  • Load all pending data when select all is requested (#1373)
  • Make the Edit Cell Dock to update with the selected cell in SQL results (#481)
  • Fix selecting columns in Browse Data tab instead of sorting them (#1717)
  • Fix detection of XML data, some types of text data, and large numbers in the Edit Cell dock (3eebffd, 7d85d7a, #1846)
  • Fix default collations and callbacks when creating a new database (5c727e8)
  • Lots of bug fixes in the SQL parser (e828beb, cb694dd, 3f7b108, 3237e9d, #1950, #1969, #1990)
  • Always set sort direction to ascending when sorting a different column (00bc7db)
  • Fix problems with the JSON export (#1789)
  • Fix problems after closing a database (#1800)
  • Fix syntax highlighting to exactly match the SQLite keywords (fa66937)
  • Fix deleting from WITHOUT ROWID table (b788e2d)
  • Fix editing data in WITHOUT ROWID tables with multiple primary key columns (#516, #1075, #1834)
  • Silence some unnecessary warning messages (#1868, f877f8a, 99c7523)
  • Fix licence list in dbhubio push dialog (16768d5)
  • Fix loading last used settings in the Import CSV dialog (cec6b82)
  • Fix setting last modified date when cloning a dbhubio database (4cf6cb7)
  • Fix possible crash when loading a corrupt project file (30d0b18)
  • Include transaction statements in the SQL log (#1859, #1901)
  • Fixes for editing cells with RTL texts (#1793, #1929)
  • When updating a field try to respect the affinity data type if possible (#1592)
  • Fix value in size column of dbhubio panel for very large databases (622ef9d)
  • Fix plotting data with NULL values by leaving gaps in the graph (#1977)
  • Fix importing CSV files with quote characters and no final line break and with only one column and no final line break (#193, #1986)
  • Escape filepath when attaching database (#2002)
  • Fix foreign-key editor not working correctly in Edit Table dialog (#1991)
  • Fix issues with resizing and with hiding a column (#1999)
  • Fix editing in tables with custom display formats (6f7fb74)
  • Fix problems with greediness in the DB4S implementation of the SQLite REGEXP operator (#2040)
  • Check if some column has a NOT NULL constraint in "Set to NULL" (#2021)
  • Fix error indication and savepoint handling after failed statements (#2073)
  • Make SQL editor in Edit Table dialog read-only (#2078)
  • Fix some problems with view editing in Browse Data tab (#2091)
  • Fix handling of databases with a view and a trigger with the same name (#2091)
  • Never mark the DB dirty if it is read-only (#1514)
  • Fix the recordset numbers in the Browse Data tab (cee3523, 13742c4)
  • Fix some typos and translation problems (3904710, 0db3c1e, 29db270, 1d1afaa, fe88463)
  • Fix dotenv not working for databases encrypted using SQLCipher 3 (7702354)
  • Fix dotenv not working when not specifying the plaintext header size (281cfe7)

New in Portable DB Browser for SQLite 3.11.1 (Feb 18, 2019)

  • Highlights:
  • DBHub.io improvements
  • CSV import: speed, memory usage, usability, type detection and new default rules
  • Attach databases
  • Menu options for filtering
  • JSON and XML editors
  • Improvements to the plot UI
  • Better copy & paste support
  • Dark theme support on Linux
  • Dark mode support for windows and macOS isn't working yet. ??
  • Multi-threaded loading of data
  • Default quotes changed to double quotes
  • Add Record dialog
  • Printing support
  • The math extensions for SQLite are included in the windows and macOS installers
  • SilvioGrosso has kindly created a video showing how to load the math extensions on windows
  • Important Notes
  • This release includes SQLCipher 4.0.1, providing even stronger encryption than the previous release.
  • To open a database encrypted with a previous release, make sure to choose the "SQLCipher 3 defaults" in the dialog which asks for the encryption passphrase.
  • Our project file format has changed, to make it easier to modify with external tools.
  • Older format files are loaded fine, but all saving of project files is done using the new project file format.
  • Notes on the windows installers
  • We've moved to providing MSI based installers, instead of the previous .exe ones. These new installers include both SQLite and SQLCipher (for optional encryption):
  • DB.Browser.for.SQLite-3.11.1-win32.msi
  • DB.Browser.for.SQLite-3.11.1-win64.msi
  • These MSI based installers will automatically detect the previous release of DB4S (3.10.1) and remove it before upgrading. If you're using one of the 3.11.0 alphas/beta, or an older version of DB4S than 3.10.1, you'll need to manually remove it first before the upgrade.
  • Additionally, there's now a .zip version of each. That's useful for people needing to run DB Browser for SQLite without installing it first.
  • DB.Browser.for.SQLite-3.11.1-win32.zip
  • DB.Browser.for.SQLite-3.11.1-win64.zip
  • If you're not sure which one to get, try the .msi version first. ??
  • Note on the macOS installer
  • The macOS installation now includes the SQLite math extensions (math.dylib), located in the Contents/Extensions/ folder inside DB Browser for SQLite.app.
  • To use it, you'll need to either manually load it (Tools ? Load Extension), or tell DB4S to automatically load it every time (Preferences ? Extensions).
  • macOS doesn't easily allow going inside .app folders in file selection dialogs. To navigate to the correct folder you'll probably need to press Shift (?)+Command (?)+g when the file selection dialog is open, then give it the path of /Applications/DB Browser for SQLite.app/Contents/Extensions.
  • Bug fixes and enhancements since 3.11.0
  • DB Browser Crashes When Importing Its Own .sql dump (#1045)
  • Updated query optimisations (#1161)
  • Network inaccessible error when using a WiFi network (#1595)
  • "determining row count" displays forever in Browse Data tab (#1654)
  • About Info - display 32bit vs 64bit (#1660)
  • Allow bottom editor of Execute SQL tab to grow taller (#1670)
  • TEXT values show as BLOB (#1731)
  • Error encrypting in 3.11.0 (#1732)
  • It's not possible to modify some tables (#1733)
  • Class 'NullLineEdit' lacks Q_OBJECT macro (#1740)
  • Include SQLite 3.27.1 instead of SQLite 3.26.0
  • Enhancements:
  • Add menu option for attaching database and allow usage of attached databases throughout the entire UI (532fcd3, 44eb2d4, fbaf78e, 315019d, 1a3e3d3, ea1659e, a5ca756, 7db96cd, 72d64ed, f01ad40, 3e02420, #1131, #1132, #1133)
  • Make import of multiple CSV files easier to use (#1121)
  • Optimise the Import CSV dialog for better usability (#1072)
  • Improve speed of preview table for large fields in the Import CSV dialog (#720)
  • Speed up CSV import a lot and reduce its memory usage (6432517, b7a00d3, 6ed8080, 0eb1f65, 659f38e, ed9fda2)
  • All sorts of improvements for tracking dbhub.io databases and pushing them back to the cloud (8a540a2, fef884a, f18064f, b2ddcdd, f926a67, 8c0e4bf, c692ae0, 64b3341, d738597, 24ee209, a1855d8, eff92c2, #1136, a931699)
  • Move button for saving Execute SQL results to the toolbar (#1122)
  • Rearrange display format list for better usability (31e499d)
  • Add menu option to hide selected columns (and unhide them) in the Browse Data view (#1135, d4e228d)
  • Add automatic type detection to the CSV import (#1003, #1382)
  • Improve splitters in Execute SQL tab (#380)
  • New menu options for using a value as a filter in the Browse Data tab, and support all filter operators for strings (#1182, #1463)
  • Allow renaming SQL tabs by double clicking their title (#1186)
  • Add support for filtering for empty strings in the Browse Data tab (#1189)
  • Add a new menu option for also copying the headers to the clipboard (#1058)
  • Add a search bar (Ctrl+F) to Execute SQL editors (#191)
  • Add a find and replace dialog (Ctrl+H) to all SQL editors (#191, #1612)
  • It's now possible to select points in a plot and the corresponding rows in the table will be selected (e8e5671)
  • Show number of records to delete in the Delete Record button caption (5fbf5ca)
  • Add new display formats (46ec019, #1213, #1467)
  • Add special editor for JSON data in the Edit Cell dialog (#1173)
  • Add special editor for XML data in the Edit Cell dialog (#1253)
  • Use HTML when copying table data to the clipboard. This way less data is lost when pasting to spreadsheet applications (e60e9ff)
  • Some improvements to the plot UI including zooming, dragging and copying the plot to the clipboard (ade5627, #1245, cef1e90, #950, #1258, e34d360, #838, #1271, b2fbf45, #1310, c4109e6)
  • Some minor improvements to the Execute SQL UI (87e1b9b, 6d44c6d)
  • Allow pasting a value into multiple cells at once (0d7ca9b)
  • Allow changing the font of the result view in the Execute SQL tab (#1240)
  • Add a new button to the Browse Data tab to create a view from the current settings (#1246)
  • Add two new toolbar for Extra actions and for Project actions and add some more icons to the existing toolbars and menus (#331)
  • Allow configuration of BLOB text and style for the Browse Data tab (#1263)
  • Add a new dialog for managing database file extensions (#659)
  • Add possibility to drag and drop fields from the DB Schema dock to the SQL text editors (#119, #1250)
  • Add a Delete Record(s) option to the context menu of the table rows in the Browse Data tab(#1283)
  • Add a new --read-only command line option (#1265)
  • Allow duplicating multiple records at once (#1090)
  • Auto complete SQL keywords in upper case and add an option for it in the Preferences dialog (#1238, #1287)
  • Respect the ORDER BY clause when plotting a table view (#821, #838)
  • Also auto complete column names when they are not preceded by their table name (#1242)
  • Add bar charts to the plot dock (#1302)
  • Allow adding a legend to the plot (#1302)
  • Add "What's This" popups in some more places (52ae85d, 2c9cf75)
  • Avoid any hard coded colours and query system colours wherever possible. In practice this adds support for dark themes (#1324)
  • Add new option for setting the line wrap in editors (#1173)
  • When clicking the Report Bug menu item some system information are included automatically (#1386)
  • When an entire row is selected and you press the Delete key, the row is now deleted (#1391)
  • Change the rules for the CSV import and add a couple of options to override them (#1395)
  • Add a new menu item to export the current table view with all its settings to a CSV file (#1402)
  • Add support for deleting rows from views with editing unlocked (#141)
  • Add menu option to copy selection in table view as SQL statements (#1422)
  • Move loading of table records into a separate thread for better UI responsiveness (#1394)
  • Change the quotes for SQL identifiers from grave to double quotes and add an option to the Preferences dialog for it (#1436)
  • Change Open Database toolbar action to open a popup menu with an extra option to open a database in read-only mode (#1432)
  • Comments containing filename, line number and results of the executed statements are added to the "User" part of the SQL log dock (#1448)
  • Look for a dotenv file with a stored password when trying to open an encrypted database (#1404)
  • Make the Unlock View Editing dialog easier to use (241372e)
  • Add support for creating and editing in-memory databases (#335, #1492)
  • Menu restructured, Tools menu added (#1434)
  • Add case_sensitive_like pragma to the Edit Pragmas tab and save it to the project file (#1494, c9d651c)
  • When adding an empty row fails open a new Add Record dialog instead in the Browse Data tab. Also make the new dialog available by a new button (#530, #1477)
  • Store the values of all pragmas which aren't stored in the database in the project files (#1518)
  • Add schema names to the auto completion list of names and allow completion of schema.table.field (#1433)
  • Some new configuration options for the drag and drop of item names from the DB Schema dock (#1433, #1534)
  • Preselect file format filter depending on the current data type when exporting cell contents to a file (#1535)
  • Allow saving the hex editor contents when exporting binary cell contents to a file and allow copying the same data to the clipboard (#1438, #1485)
  • Add printing support to text and hex editors, plots, Database Structure tab, Browse Data tab and Execute SQL tabs (#1525)
  • Add some new menu items for optimising and checking the integrity of the database (#1435)
  • Save attached databases in the project file (#1532)
  • Add basic support for window functions (7e23214, 517743f)
  • Add an optional auto completion popup to the Browse Data tab which shows up when editing a cell (e1101ae, 04f27cc, 88d1cbc, b4b933c)
  • Some polishing of the main window UI (#420, f42b614)
  • Automatically preselect correct editor depending on the detected data type in the Edit Cell dialog (#1537)
  • Change project file format to support multiple sort columns (#1593)
  • The SQL function load_extension() is only enabled when explicitly requested by the user in a new setting (#1558)
  • Command line option for running with some setting set to a given value (#1588)
  • Bug fixes:
  • Avoid extra spaces when formatting SQL statements (18bcbf1)
  • Fix dbhub.io bugs (4dc5286)
  • Fix detection of image data in Edit Cell dialog (#1138, #1159)
  • Fix Vacuum dialog (c616b39)
  • Allow selecting text in Edit Cell dialog even if database is read only (#1123, #1461)
  • Clear filters in Browse Data tab when table structure changes (#1020)
  • Add support for parsing multiple foreign keys in column constraints (677d360)
  • Fix memory leaks (28446a4)
  • Fix input of custom data types in Edit Table dialog so it doesn't require you to hit Enter (#1147)
  • Don't query foreign key pragma all the time in Edit Table dialog (#1130)
  • Avoid unnecessary queries in Browse Data tab (#1108, #1187)
  • Support UTF16 strings in the default collation in DB4S (#1172)
  • Never override the built-in collations (#1172)
  • Fix problems when opening a database by drag and drop (9cff69f, #1236)
  • Fix crash when trying to edit the display format of a view column (9fd4ebe)
  • Better error and changes detection in Execute SQL tab (#1181, #1185)
  • Fix parsing of SQL statements on systems with some locales like Turkish (#1194)
  • Fix some high DPI issues (#1184)
  • Improve BLOB detection in Browse Data tab (9b30940)
  • Fix changing table name to a name that only differs in case (#1200)
  • Fix progress dialog of CSV import for very large files (#1212)
  • Select current display format when opening the Custom Display Format dialog (#1202)
  • Only display the horizontal scrollbar in the SQL editor when it's necessary (d8aeae1)
  • Show keyboard shortcuts in some places where they were missing (9ce4b23)
  • Fix restoring previous settings in the Export SQL dialog (ccb1fd4)
  • Never use quotes when copying data from the table view to the text clipboard (#1244)
  • Fix crash when clicking Save SQL file button when no SQL tab is opened (#1248)
  • Fix pasting table data from spreadsheet applications which put an extra line break at the end of the text (#1244)
  • Fix pasting when actually no data is in the clipboard (9db70e0)
  • Copying and pasting between different tables and copying binary data in the Browse Data tab is now always lossless (47b0749, #1257)
  • Fix copying binary data (316860a)
  • Don't ignore possible error messages when duplicating a record (#1255)
  • Don't truncate data at 32768 characters when editing it in directly in the table widget (#1281)
  • Fix binary data detection in table views (#1279, 27c6579, c9c848e, feda408)
  • Allow unsetting the encoding of a table (#1279)
  • Fix drag and drop of tables from the Schema tab (117af5a)
  • Fix style of web links in UI (#1286)
  • Fix execution of some SQL statements with comments and/or line breaks in them (#1270, #1334)
  • Add support for tables with ON CONFLICT clauses for their primary key (743e798)
  • Fix crash when pressing Tab at the last cell of a view (#1289)
  • Fix crash when trying to add an index to a database without any tables (#1293)
  • Fix problems after drag & drop of tables onto the structure view (#1288)
  • Copy original statement when clicking the Copy Create Statement menu option (#1300)
  • Fix updating and deleting from tables without rowid if the primary key value contains a "'" character (#1332)
  • Don't show "Show Rowid" menu option for tables without rowid (#1332)
  • Our project file format is now text only. This helps if you want to edit it in a text editor (#1306)
  • Don't commit the current transaction when trying to change the defer_foreign_keys PRAGMA (aebfc51)
  • Fix error messages when importing SQL files (431c671)
  • Show icons in Export SQL dialog (28baba8)
  • Only allow exporting tables in Export SQL dialog (b384027)
  • Tweak order of statements in exported SQL file for less import problems (b6c0560)
  • Fix text of toolbar actions for deleting and modifying objects other than tables (13d9f98)
  • Remember "primary key" of a view unlocked for editing when changing to another object and back (ea25618)
  • Only allow powers of two for page size in Cipher Settings dialog and Edit Pragma tab (#1405, 8a07f0e)
  • Make sure the insert and delete record buttons are only enabled if they can be used (115d1f1)
  • Suggest correct file extensions when export content of a cell to a file (885f4f7)
  • Make sure to reset results view even when a query didn't return any rows (#1437)
  • Auto suggest encodings in Select Encoding dialog (588363b)
  • Fix parsing of some complex SQL expressions in CREATE statements and fix parsing of CHECK constraints (#1454, c150d1a)
  • Fix multiple SQL statements in Execute SQL tab being split up at the wrong position (#1470)
  • Don't allow editing the SQL preview in the Create Index dialog (7a9f310)
  • When jumping to a row referenced to by a foreign key by using Ctrl+Shift+Click, perform an exact search instead of a LIKE search (d50a27a)
  • Fix crash when browsing a table, then deleting it in another tab and then switching back to the Browse Data tab (2701223)
  • Fix string quotes in Custom Display Format dialog (b6f47f9)
  • Prevent possible data loss when editing table with foreign keys enabled and ON DELETE CASCADE references (#1481)
  • Fix view when loading a project file while being in the Edit Pragma tab (a23c0a0)
  • Avoid confusion about the SQLCipher version in the About dialog (#1474)
  • Don't remove a record from the table view temporarily when deleting it has failed (#1511)
  • Show better error messages when importing SQL files (#1519)
  • Defer foreign keys when importing SQL files to avoid import issues for some files (#1519)
  • Fix editing of auto_vacuum pragma via the UI (#1518)
  • Fix initial loading of databases which depend on extension functions to be present (f3e6aec)
  • Fix cursor after SQL import finished (#1526)
  • Fix completion of quoted identifiers in SQL editor (#1433)
  • Fix positioning of cursor in Execute SQL tab when there is an error near a multi-byte character (99c53a4)
  • Fix some possible crashes when loading an invalid project file (717ff07)
  • Fix auto completion of keyword ROWID (78ae2c3)
  • Better error messages when editing the definition of a table fails (#1547)
  • Fix auto completion not working in some cases until you refresh the database (#1549)
  • Avoid unnecessary queries in the Browse Data tab in some cases (c78c03b)
  • Fix inserting, deleting and editing of rows in WITHOUT ROWID tables with a primary key of TEXT type (#1559)
  • Better error handling in import CSV dialog (#1590)
  • Fix possible resource leaks (#1691)
  • Platform specific:
  • Windows
  • Use MSI installers (#1400)
  • Make sure the image plugins are loaded properly (#1188, 9016bf6)
  • Also install license files (12ee94c)
  • Add version info to Windows executables (#1387)
  • Fix line breaks in SQL export (#1502) and quoting (041ceba)
  • macOS
  • Work around a Qt bug which causes high pings for Wifi connections (#1209, 77a701d)
  • Add a workaround to improve rendering performance on 4k/5k resolutions (#1233)
  • Add .sqlite, .db3 and .sqlite3 to the list of file associations (28f6c6e, 3008747)
  • Fix shortcut name for following a foreign key (#1539)
  • Linux
  • Make install paths configurable for qmake build (#1443)
  • Gnome
  • Fix problem with switching the workspace on Gnome (#934)
  • Translations:
  • Fix call tips in SQL editor for languages with non-Latin scripts (#1107, #1206)
  • Never translate the name of the pragmas in the Edit Pragma tab (9a30e6c)
  • Spanish translation updated (#1190, 2b6f0d7, aa82b52, 636136a)
  • German translation updated (09e170f, #1569)
  • Korean translation updated (8c85ff9)
  • Polish translation added (#1456)
  • French translation updated (b7dbfc8, 5a4df8d)
  • Italian translation added (#1705)
  • Czech translation updated (#1710)
  • Portuguese translation updated (#1707)
  • Simplified Chinese translation updated (#1594)
  • Russian translation updated (#1581)
  • Arabic translation updated (170fb69)
  • Packaging and Building
  • Fix code to work with Qt 5.10 and later (e6a4326, 189b750, 39302f5, 72506fb, #1475)
  • Update the bundled qcustomplot librar to version 2.0.0
  • Silence some cmake warnings (#635, #1143)
  • Show the build date of the nightly builds in the About dialog (0bc430b)
  • Restored Qt 5.2 compatibility (#1298)
  • SHA256SUMS
  • DB.Browser.for.SQLite-3.11.1-win32.msi
  • 76076d5c20240479238705f2211cad709f23c31cabe1682e2953bf6a7168b8d0
  • DB.Browser.for.SQLite-3.11.1-win32.zip
  • 558cb41445f0bdd31605aaeb52264ae9839b9e21aa75369a51352956966700fc
  • DB.Browser.for.SQLite-3.11.1-win64.msi
  • ffe1f44f10d49c9d382e66b951125ae1ee10d4bce93e5a32dbb8547d6bf7122f
  • DB.Browser.for.SQLite-3.11.1-win64.zip
  • a648b8faffc6da3fcf761f921270de2a2871d4116e2f7baf5e3b0280a538164c
  • DB.Browser.for.SQLite-3.11.1.dmg
  • bd4a74540a63a262fc49b816e8fc71fd816e81b215c31572d96b169d980a573e

New in Portable DB Browser for SQLite 3.11.0 (Feb 7, 2019)

  • Enhancements:
  • Add menu option for attaching database and allow usage of attached databases throughout the entire UI (532fcd3, 44eb2d4, fbaf78e, 315019d, 1a3e3d3, ea1659e, a5ca756, 7db96cd, 72d64ed, f01ad40, 3e02420, #1131, #1132, #1133)
  • Make import of multiple CSV files easier to use (#1121)
  • Optimise the Import CSV dialog for better usability (#1072)
  • Improve speed of preview table for large fields in the Import CSV dialog (#720)
  • Speed up CSV import a lot and reduce its memory usage (6432517, b7a00d3, 6ed8080, 0eb1f65, 659f38e, ed9fda2)
  • All sorts of improvements for tracking dbhub.io databases and pushing them back to the cloud (8a540a2, fef884a, f18064f, b2ddcdd, f926a67, 8c0e4bf, c692ae0, 64b3341, d738597, 24ee209, a1855d8, eff92c2, #1136)
  • Move button for saving Execute SQL results to the toolbar (#1122)
  • Rearrange display format list for better usability (31e499d)
  • Add menu option to hide selected columns (and unhide them) in the Browse Data view (#1135, d4e228d)
  • Add automatic type detection to the CSV import (#1003, #1382)
  • Improve splitters in Execute SQL tab (#380)
  • New menu options for using a value as a filter in the Browse Data tab, and support all filter operators for strings (#1182, #1463)
  • Allow renaming SQL tabs by double clicking their title (#1186)
  • Add support for filtering for empty strings in the Browse Data tab (#1189)
  • Add a new menu option for also copying the headers to the clipboard (#1058)
  • Add a search bar (Ctrl+F) to Execute SQL editors (#191)
  • Add a find and replace dialog (Ctrl+H) to all SQL editors (#191)
  • It's now possible to select points in a plot and the corresponding rows in the table will be selected (e8e5671)
  • Show number of records to delete in the Delete Record button caption (5fbf5ca)
  • Add new display formats (46ec019, #1213, #1467)
  • Add special editor for JSON data in the Edit Cell dialog (#1173)
  • Add special editor for XML data in the Edit Cell dialog (#1253)
  • Use HTML when copying table data to the clipboard. This way less data is lost when pasting to spreadsheet applications (e60e9ff)
  • Some improvements to the plot UI including zooming, dragging and copying the plot to the clipboard (ade5627, #1245, cef1e90, #950, #1258, e34d360, #838, #1271, b2fbf45, #1310, c4109e6)
  • Some minor improvements to the Execute SQL UI (87e1b9b, 6d44c6d)
  • Allow pasting a value into multiple cells at once (0d7ca9b)
  • Allow changing the font of the result view in the Execute SQL tab (#1240)
  • Add a new button to the Browse Data tab to create a view from the current settings (#1246)
  • Add two new toolbar for Extra actions and for Project actions and add some more icons to the existing toolbars and menus (#331)
  • Allow configuration of BLOB text and style for the Browse Data tab (#1263)
  • Add a new dialog for managing database file extensions (#659)
  • Add possibility to drag and drop fields from the DB Schema dock to the SQL text editors (#119, #1250)
  • Add a Delete Record(s) option to the context menu of the table rows in the Browse Data tab(#1283)
  • Add a new --read-only command line option (#1265)
  • Allow duplicating multiple records at once (#1090)
  • Auto complete SQL keywords in upper case and add an option for it in the Preferences dialog (#1238, #1287)
  • Respect the ORDER BY clause when plotting a table view (#821, #838)
  • Also auto complete column names when they are not preceded by their table name (#1242)
  • Add bar charts to the plot dock (#1302)
  • Allow adding a legend to the plot (#1302)
  • Add "What's This" popups in some more places (52ae85d, 2c9cf75)
  • Avoid any hard coded colours and query system colours wherever possible. In practice this adds support for dark themes (#1324)
  • Add new option for setting the line wrap in editors (#1173)
  • When clicking the Report Bug menu item some system information are included automatically (#1386)
  • When an entire row is selected and you press the Delete key, the row is now deleted (#1391)
  • Change the rules for the CSV import and add a couple of options to override them (#1395)
  • Add a new menu item to export the current table view with all its settings to a CSV file (#1402)
  • Add support for deleting rows from views with editing unlocked (#141)
  • Add menu option to copy selection in table view as SQL statements (#1422)
  • Move loading of table records into a separate thread for better UI responsiveness (#1394)
  • Change the quotes for SQL identifiers from grave to double quotes and add an option to the Preferences dialog for it (#1436)
  • Change Open Database toolbar action to open a popup menu with an extra option to open a database in read-only mode (#1432)
  • Comments containing filename, line number and results of the executed statements are added to the "User" part of the SQL log dock (#1448)
  • Look for a dotenv file with a stored password when trying to open an encrypted database (#1404)
  • Make the Unlock View Editing dialog easier to use (241372e)
  • Add support for creating and editing in-memory databases (#335, #1492)
  • Menu restructured, Tools menu added (#1434)
  • Add case_sensitive_like pragma to the Edit Pragmas tab and save it to the project file (#1494, c9d651c)
  • When adding an empty row fails open a new Add Record dialog instead in the Browse Data tab. Also make the new dialog available by a new button (#530, #1477)
  • Store the values of all pragmas which aren't stored in the database in the project files (#1518)
  • Add schema names to the auto completion list of names and allow completion of schema.table.field (#1433)
  • Some new configuration options for the drag and drop of item names from the DB Schema dock (#1433, #1534)
  • Preselect file format filter depending on the current data type when exporting cell contents to a file (#1535)
  • Allow saving the hex editor contents when exporting binary cell contents to a file and allow copying the same data to the clipboard (#1438, #1485)
  • Add printing support to text and hex editors, plots, Database Structure tab, Browse Data tab and Execute SQL tabs (#1525)
  • Add some new menu items for optimising and checking the integrity of the database (#1435)
  • Save attached databases in the project file (#1532)
  • Add basic support for window functions (7e23214, 517743f)
  • Add an optional auto completion popup to the Browse Data tab which shows up when editing a cell (e1101ae, 04f27cc, 88d1cbc, b4b933c)
  • Some polishing of the main window UI (#420, f42b614)
  • Automatically preselect correct editor depending on the detected data type in the Edit Cell dialog (#1537)
  • Bug fixes:
  • Avoid extra spaces when formatting SQL statements (18bcbf1)
  • Fix dbhub.io bugs (4dc5286)
  • Fix detection of image data in Edit Cell dialog (#1138, #1159)
  • Fix Vacuum dialog (c616b39)
  • Allow selecting text in Edit Cell dialog even if database is read only (#1123, #1461)
  • Clear filters in Browse Data tab when table structure changes (#1020)
  • Add support for parsing multiple foreign keys in column constraints (677d360)
  • Fix memory leaks (28446a4)
  • Fix input of custom data types in Edit Table dialog so it doesn't require you to hit Enter (#1147)
  • Don't query foreign key pragma all the time in Edit Table dialog (#1130)
  • Avoid unnecessary queries in Browse Data tab (#1108, #1187)
  • Support UTF16 strings in the default collation in DB4S (#1172)
  • Never override the built-in collations (#1172)
  • Fix problems when opening a database by drag and drop (9cff69f, #1236)
  • Fix crash when trying to edit the display format of a view column (9fd4ebe)
  • Better error and changes detection in Execute SQL tab (#1181, #1185)
  • Fix parsing of SQL statements on systems with some locales like Turkish (#1194)
  • Fix some high DPI issues (#1184)
  • Improve BLOB detection in Browse Data tab (9b30940)
  • Fix changing table name to a name that only differs in case (#1200)
  • Fix progress dialog of CSV import for very large files (#1212)
  • Select current display format when opening the Custom Display Format dialog (#1202)
  • Only display the horizontal scrollbar in the SQL editor when it's necessary (d8aeae1)
  • Show keyboard shortcuts in some places where they were missing (9ce4b23)
  • Fix restoring previous settings in the Export SQL dialog (ccb1fd4)
  • Never use quotes when copying data from the table view to the text clipboard (#1244)
  • Fix crash when clicking Save SQL file button when no SQL tab is opened (#1248)
  • Fix pasting table data from spreadsheet applications which put an extra line break at the end of the text (#1244)
  • Fix pasting when actually no data is in the clipboard (9db70e0)
  • Copying and pasting between different tables and copying binary data in the Browse Data tab is now always lossless (47b0749, #1257)
  • Fix copying binary data (316860a)
  • Don't ignore possible error messages when duplicating a record (#1255)
  • Don't truncate data at 32768 characters when editing it in directly in the table widget (#1281)
  • Fix binary data detection in table views (#1279, 27c6579, c9c848e, feda408)
  • Allow unsetting the encoding of a table (#1279)
  • Fix drag and drop of tables from the Schema tab (117af5a)
  • Fix style of web links in UI (#1286)
  • Fix execution of some SQL statements with comments and/or line breaks in them (#1270, #1334)
  • Add support for tables with ON CONFLICT clauses for their primary key (743e798)
  • Fix crash when pressing Tab at the last cell of a view (#1289)
  • Fix crash when trying to add an index to a database without any tables (#1293)
  • Fix problems after drag & drop of tables onto the structure view (#1288)
  • Copy original statement when clicking the Copy Create Statement menu option (#1300)
  • Fix updating and deleting from tables without rowid if the primary key value contains a "'" character (#1332)
  • Don't show "Show Rowid" menu option for tables without rowid (#1332)
  • Our project file format is now text only. This helps if you want to edit it in a text editor (#1306)
  • Don't commit the current transaction when trying to change the defer_foreign_keys PRAGMA (aebfc51)
  • Fix error messages when importing SQL files (431c671)
  • Show icons in Export SQL dialog (28baba8)
  • Only allow exporting tables in Export SQL dialog (b384027)
  • Tweak order of statements in exported SQL file for less import problems (b6c0560)
  • Fix text of toolbar actions for deleting and modifying objects other than tables (13d9f98)
  • Remember "primary key" of a view unlocked for editing when changing to another object and back (ea25618)
  • Only allow powers of two for page size in Cipher Settings dialog and Edit Pragma tab (#1405, 8a07f0e)
  • Make sure the insert and delete record buttons are only enabled if they can be used (115d1f1)
  • Suggest correct file extensions when export content of a cell to a file (885f4f7)
  • Make sure to reset results view even when a query didn't return any rows (#1437)
  • Auto suggest encodings in Select Encoding dialog (588363b)
  • Fix parsing of some complex SQL expressions in CREATE statements and fix parsing of CHECK constraints (#1454, c150d1a)
  • Fix multiple SQL statements in Execute SQL tab being split up at the wrong position (#1470)
  • Don't allow editing the SQL preview in the Create Index dialog (7a9f310)
  • When jumping to a row referenced to by a foreign key by using Ctrl+Shift+Click, perform an exact search instead of a LIKE search (d50a27a)
  • Fix crash when browsing a table, then deleting it in another tab and then switching back to the Browse Data tab (2701223)
  • Fix string quotes in Custom Display Format dialog (b6f47f9)
  • Prevent possible data loss when editing table with foreign keys enabled and ON DELETE CASCADE references (#1481)
  • Fix view when loading a project file while being in the Edit Pragma tab (a23c0a0)
  • Avoid confusion about the SQLCipher version in the About dialog (#1474)
  • Don't remove a record from the table view temporarily when deleting it has failed (#1511)
  • Show better error messages when importing SQL files (#1519)
  • Defer foreign keys when importing SQL files to avoid import issues for some files (#1519)
  • Fix editing of auto_vacuum pragma via the UI (#1518)
  • Fix initial loading of databases which depend on extension functions to be present (f3e6aec)
  • Fix cursor after SQL import finished (#1526)
  • Fix completion of quoted identifiers in SQL editor (#1433)
  • Fix positioning of cursor in Execute SQL tab when there is an error near a multi-byte character (99c53a4)
  • Fix some possible crashes when loading an invalid project file (717ff07)
  • Fix auto completion of keyword ROWID (78ae2c3)
  • Better error messages when editing the definition of a table fails (#1547)
  • Fix auto completion not working in some cases until you refresh the database (#1549)
  • Avoid unnecessary queries in the Browse Data tab in some cases (c78c03b)
  • Fix inserting, deleting and editing of rows in WITHOUT ROWID tables with a primary key of TEXT type (#1559)
  • Windows:
  • Use MSI installers (#1400)
  • Make sure the image plugins are loaded properly (#1188, 9016bf6)
  • Also install license files (12ee94c)
  • Add version info to Windows executables (#1387)
  • Fix line breaks in SQL export (#1502)

New in Portable DB Browser for SQLite 3.11.0 Beta 3 (Dec 13, 2018)

  • The Windows installer dialogs have been cleaned up and reorganised.
  • The Windows installer now detects and uninstalls the prior release (3.10.1) automatically.
  • The macOS installation now includes the SQLite math extensions (math.dylib).
  • To use it, you'll need to either manually load it (Tools → Load Extension), or tell DB4S to automatically load it every time (Preferences → Extensions).

New in Portable DB Browser for SQLite 3.11.0 Beta 2 (Dec 12, 2018)

  • All Windows installers include both the SQLite and SQLCipher executables:
  • The SQLite build has the most recent version of SQLite (3.26.0), but has no encryption.
  • The SQLCipher build has encryption, but provides a slightly older version of SQLite.
  • Run whichever one meets your needs, based up whether you need encryption or not.
  • Both the Windows (64-bit) and macOS builds now use Qt 5.12.0.
  • Several bug fixes.
  • Some updated language translation files.

New in Portable DB Browser for SQLite 3.11.0 Beta 1 (Nov 28, 2018)

  • Several bug fixes
  • Both the Windows and macOS installers are now based on Qt 5.11.2, and use the latest release of SQLCipher (3.4.2)
  • Updated language translation files
  • The standard Qt buttons should now be displayed translated, for most languages
  • Both Win32 and Win64 installers have a .zip download version as well, which can just be unzipped and run directly without needing Admin permissions to install

New in Portable DB Browser for SQLite 3.10.1 (Sep 29, 2017)

  • 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)

New in Portable DB Browser for SQLite 3.9.1 (Oct 21, 2016)

  • Major features:
  • Future releases of DB Browser for SQLite will optionally be able to save and retrieve your SQLite databases "in the cloud".
  • You can enable/disable this new submenu in Preferences.
  • Enhancements:
  • Decreased lagging with long strings (further work still needed) - #761
  • Indicate when display strings are being truncated - #767
  • Focus the newly created field after clicking 'Add field' - 64ee665
  • Improved Execute current SQL line action - #780, 45affc9, 531eddb
  • Bug fixes:
  • Fixed default font selected being incorrectly detected - b15c7f2, 49786e1
  • Increased custom Page Size upper limit - e12e043
  • Fixed program not being able to uninstall from "Programs and Features" in Windows 7 - 90c094e
  • Fixed executing current line action incorrectly logging the entire SQL - 55d8905
  • Added HTML entities escaping in output when executing SQL - b9dd11d
  • Fixed Indexes with spaces around their name not being able to be deleted - 8be2c54
  • Removed quotes around content when a single cell is copied - 8c510ff
  • Help button should not be present in Windows title bar - #796

New in Portable DB Browser for SQLite 3.9.0 (Sep 9, 2016)

  • MAJOR FEATURES:
  • Strong encryption is now supported on Windows, using SQLCipher!
  • Keyboard navigation in the "Browse Data" tab now works well
  • Our releases are now digitally signed on both Windows and MacOS
  • ENHANCEMENTS:
  • Add Fedora install instructions
  • Add Windows DATE display format
  • Remove ampersands from windows title
  • Feature request: Option to turn off "intellisense"-like suggestions
  • Add select and deselect all options for Export SQL dialog
  • Add Homebrew Cask install instructions
  • Add decimal support to display format
  • Add Edit Database Cell update when selecting a cell from the Execute SQL tab
  • Cannot view binary data on BLOB columns containing image
  • Update Fedora install instructions
  • Add preference setting for exports line ending
  • Adjust executable/app name according to the project's name
  • Add duplicate record option
  • Change default button to No in removal message dialogs
  • Add default field type preference setting
  • Add option to export only the data in an SQL export
  • Remove buggy Edit Dialog and improved Edit Dock
  • Add Ubuntu install instructions on the website
  • Add Rackspace logo on the website
  • Add binary data size to the Edit Dock
  • Update installer .dmg on Mac OS
  • Add Create Index button in the toolbar and fixed Create Index dialog sizing
  • Add backspace alongside delete key for cell empty, for laptops missing the delete key
  • Optimize choosing displayed text for cell
  • Improve copy/pasting in ExtendedTableWidget
  • Feature request: We should sign our official releases
  • Reimplement data handling in the Edit Cell widget
  • BUG FIXES:
  • Fix building on CentOS
  • Fix crash when browsing data in some cases
  • Fix font blur on retina displays in the SQL Log
  • Fix crash when trying to delete records from empty table
  • Fix database toolbar actions not updating after deleting a table
  • Fix cancel button not working in the Export SQL dialog
  • Fix Field separator and Quote character preferences not restoring correctly
  • Fix various small bugs with the quote and separator choices
  • Fix primary keys not being quoted when creating/modifying tables
  • Fix crash in Browse Data tab when pasting empty string over non-empty cell - 1ce62d7
  • Fix cell Edit Dialog not showing up centered
  • Fix Show rowid column option not correctly refreshing the table view
  • Fix crash when hovering over any row from the rowid column
  • Fix for unquoted path vulnerability in the Windows app - #649
  • Fix incorrect app version in Finder's Info view
  • Fix crash when trying to Export table(s) as CSV in some cases - 2c1ab5b
  • Fix navigation keyboard shortcuts not working in Browse Data tab in some cases - 2bcc603
  • Fix DB Toolbar visibility preference setting not restored in some cases
  • Fix Alt-Delete not setting the selected cell to NULL
  • Fix transactions not being ignored when executing SQL
  • Fix elements focus order on Tab press
  • Fix Edit Dialog opening when pressing Enter
  • Fix Filter Input row in RTL Locales
  • Fix Edit Dock default position
  • Fix crash when closing unsaved database (or some other rare cases)
  • Fix font preference settings not being reflected in the Edit Dock - 7eb733b
  • Fix Arabic translations not showing up correctly
  • Fix cell binary data getting corrupted when trying to edit in place
  • Fix foreign key preview not showing up for foreign keys in the first column
  • TRANSLATIONS:
  • Add Korean translation
  • Add Turkish translation
  • Add Spanish translation
  • Update German translation
  • Add Arabic translation
  • Update Arabic translation
  • Update Russian translation
  • Add Brazilian Portuguese translation
  • Update French translation
  • OTHER NOTES:
  • You can go to the Change Log for the detailed version of the changes listed here and to the Commit Log for the full list of changes.