Home Original page

v3.13.0 Release · sqlitebrowser/sqlitebrowser · Discussion #3689

Caution

An issue has been reported where the app fails to launch on macOS Catalina (10.15.x).
We will be tracking and resolving the issue. For more information, see issue #3691

We are very excited to release a new stable version after almost three years. 🚀
It's been a while since we've released a new stable version, so there are a lot of changes, see the release notes below for more details.
You can download this release from one of the following links:

Also, to ensure a stable release, in-app update notifications will be enabled in about a week.

Notifying well-known package managers of new releases is a work in progress.

Package Manager Status Related
APT To Do -
Chocolatey To Do -
flathub Done flathub/org.sqlitebrowser.sqlitebrowser#20
Homebrew Done Homebrew/homebrew-cask#180359
portableApps.com To Do -
Scoop To Do -
Snap To Do -
Winget To Do Delayed due to technical issues
Release Notes

Table of Contents

Highlights on user-visible changes

SQLite update and improved support

New Built-in Extension: sqlean (#3517, 0561d3f, be10d1a)

sqlean: All the Missing SQLite Functions
This new built-in extension bring together several commonly known SQLite extensions neatly packaged into one domain module.
Check out their repository for further information: https://www.github.com/nalgeon/sqlean

Also, this inclusion of this awesome extension was made possible by the generosity of the original author, @nalgeon
We'd like to take this opportunity to thank him.

Docked Data Browsers (1e1e87e, c96c393, 28ae741, c40fb07, c33b8be)

imagen
Press the new button at the left of the toolbar in the "Browse Data" to get a new tab where you can browse a second table.
By default, the tab title follows the table name, but it can also be renamed to set a permanent name, using the contextual menu of the tab title.
imagen
You can drag this new tab by the title bar, or use the buttons at the right to detach this dock and make it an independent window.
imagen

Or you can drag the docked window inside the original Data Browser to drop it using different layouts.
This will allow you to compare two tables or different sections of the same tables side by side.
imagen

Moreover, when opening a related record by pressing Ctrl+Shift+Click on a foreign key cell, the other table will be opened now in a new tab.
imagen

Specifying multiple tables using the -t/--table parameter on the command line now opens all of them in different tabs. (ab682a3)

Other improvements in Data Browser

The table shows a visual hint for keys in its column header: primary keys are underscored, foreign keys are in italics (b6c5024).
imagen

Sort order indicators have been swapped to be in line with the majority of applications (03ce140).

Columns can be frozen when scrolling horizontally (a15f81b)
imagen

Database Cell Editor

A new "Evaluation" mode can be selected in the Database Cell Editor (9a70af7)
imagen

Any input in this mode will be interpreted as an SQLite expression,
and the result of the evaluation will be inserted in the corresponding cell when pressing "Apply".
imagen
Note another minor improvement in the Cell Editor: it now shows the current row and column number being edited.

A new prompt is shown for saving any modified data when abandoning the cell editor (8f5c17e)
imagen

The image mode now has zoom controls and can be adjusted with the mouse wheel (d3c69ad, d62ccb1, 8bc9d33, f749f38, 23a597b)
imagen

Better support for HiDPI and new scalable icons #2485

DB Browser for SQLite has now better display in High DPI monitors, including the use of scalable icons from the Paste SVG icon set by Michael Burckley under a Creative Commons Attribution Share Alike 4.0 license. This will allow better display in High DPI monitors.
imagen

Dark and light style

The dark style has been updated and a new light style has been added (2a830e5)
imagen
imagen

Import and export

CSV data can be imported now from the clipboard. (9d87b96)
imagen

CSV files can also be imported from the command line, passing necessary arguments to drive the correct import. If just a CSV file is passed as single argument in the command line, the data is imported into an in-memory database. This can work as a quick glance of CSV data, alternative to what you can do with inferior data management tools, a.k.a. your favorite spreadsheet 😄 (cfa4dee, 09aaacc, f75a358, 36c5b1b, 6bdacf6).

There's a new option to use system locale conventions for interpreting numbers in the CSV file (f9314b6).
imagen

Data in Browser and Execute SQL can now be exported as JSON (a5cc259, e225dc1)
imagen

File menu

Added new "Save Database As..." action for saving in-memory databases and saving database files to another
file name. (c8cd858)
imagen

Recent Files are now accessible in a new menu, can be cleared (ec6ff6a), and the maximum number of entries can be changed in Preferences (#2373)

Display formats

New and improved keyboard shortcuts

Shortcut Action Related
Ctrl+Shift+F Focus the filter line d1e82ed
Ctrl+Alt+F Focus the global filter d1e82ed
Alt+Number Removed for Unicode character entry;
Main tabs and menu items accessed using Alt+(underscored letter)		 2637072, be041e5
Ctrl+Shift+T Open SQL file(s) 128babb
Ctrl+Shift+Number Open file from Recent Files in read-only mode 1105863
Ctrl+Enter Execute query af84e89
Ctrl+Shift+W and Ctrl+Shift+F4 Close project operation aaa628b
Ctrl+Alt+W Close the current database without closing the project 576bbe7
Ctrl+Tab and Ctrl+Shift+Tab Navigate between SQL tabs 4bc10a5, 4e8623b
Ctrl+PgDown Focus the table results 4bc10a5, 4e8623b
Ctrl+PgUp Focus the SQL editor 4bc10a5, 4e8623b

Clipboard

  • Binary data pasted in the Data Browser is now inserted as BLOB and not as text (9475f31).
  • Column name can be copied from the contextual menu of the column header (Add copy column name to table viewer #3051)
  • Support of extended selections (non-contiguous cell selections using Control+Click) (c5199f5)
  • Cut operation in Data Browser (09320c2)

Improvements in project files

Project files are now more portable (can be moved to other disk locations along with the database) and are more consistent regarding what is saved in the project.

  • Store a relative filename if the path to project and to DB is the same (2390b9e)
  • Open SQL files are now linked when saving the project file, instead of being embedded in the project file itself. (3a4d7d8). An icon in the SQL tabs will differentiate these linked files from internal SQL buffers, which are still being embedded in the project file (Show a useful icon in SQL tabs #2153) (81b9b5a)
  • Until this version, once a project file was saved, there was no way to return to the original "project-less" state. Now, there is a new action to close the project file and return to initial state (aaa628b)

Undo operation #3428

Besides our long-lived "Revert Changes" button, which does a full revert to the last saved state of the database, we have now an "Undo" operation, which reverts only the last edition performed in the cells or the last execution in "Execute SQL" tab. The modifications can be undone one by one until the last saved state is reached. The undone steps cannot be redone.
imagen

Edit Table dialog

  • New tabs for editing check constraints and foreign keys (54d82ea, 53b5493)
  • Other GUI improvements (de28943)

Execute SQL

  • SELECT queries can be easily built by selecting, dragging and dropping tables or fields from the DB Schema dock to the SQL Execute tab (8bb16d1)
  • An asterisk next to the filename is used as indication of a tab which has been modified and it is still not saved. (4948e16)
  • Speed up execution (99ee8fa, 21c7f76, a4a1969, 73efa11, 89587a7)

Plot

  • Show x and y values on a tooltip when hovering over the plot (ce176be)
  • Improved display of numbers in axes (974954f, 7d04102)

Preferences

Console messages

Console message are now visible under Windows inside the GUI #1069

Translations #3452

Thanks to the help of many contributors, we have the following translations complete in this new version (in chronological order of the contribution):

For more information, see the following two links:

And many other minor improvements and bug fixes

Merged pull requests

New Contributors

SHA256SUM

81af0e90257b96d4ddac32b93801c160e18ec450c2727d507f80ba3c585279f3  DB.Browser.for.SQLite-v3.13.0-win32.msi
12c688c67acde2e76ff5d5a6c1dada854015f57c6b06c5378231fc357ddea47b  DB.Browser.for.SQLite-v3.13.0-win32.zip
4fd5a308481fa8ff3008bcbd069da03944698f1397b509f22a43bfda93dfccd3  DB.Browser.for.SQLite-v3.13.0-win64.msi
69465171d0eaca2a3d68ec5a5048f62ee192d136412a6f6747538d4535c18bbe  DB.Browser.for.SQLite-v3.13.0-win64.zip
58f4e35c7e8344fe1cf8f2431463b40be761c2120381257afbede2ff39fa21bc  DB.Browser.for.SQLite-v3.13.0-x86.64.AppImage
dfa72811ab9faa522586a31bf680db1604442e35a2725f0aed77d5f66388724b  DB.Browser.for.SQLite-v3.13.0.dmg