Browser for SQLite databases

Browser for SQLite databases

DB Browser for SQLite v3.13.1$$$Changelog$$$Added$$$Add links to the wiki as help for many dialogs (7af1256; b5abc86)$$$Changed$$$Change the default to install a shortcut to the Start menu when installing on Windows (623bec6)$$$Improve icon image for links in Help menu (#3693; 027c6a8)$$$Pragma names and values can now be translated (#3697; bf62f3a; ad00ad4)$$$Remove trailing characters when copying a single cell (#3735; 20f481a)$$$Update AppImage binary to use the latest SQLCipher library (#3744; 21ba2d0)$$$When editing the DB cells; expanded queries with parameters are included in the SQL Log (ac3209f)$$$Fixed$$$ExtendedTableWidget$$$$$$Fix an issue that prevented autocomplete from working in some race conditions (#2567; #3706)$$$Use Tab to close autocomplete popup and move to next item (3aff8c9)$$$Troubleshoot Copy as SQL action on a cell results in string being copied (#1952; 1ebe7bf)$$$Global$$$$$$Fix Argument Missing error in Korean translation (#3635; #3692; cd518de)$$$Fix an issue that caused apps to crash on some older versions of macOS (#3691)$$$Fix an issue when freezing after stopping a pragma (#3742; 15a9620)$$$Fix an issue with outputting the wrong version on macOS$$$Troubleshooting poor HiDPI support on Windows (#3684)$$$Troubleshoot SQL queries containing VACUUM that run incorrectly (#3723; 51784aa)$$$MainWindow$$$$$$Fix an issue when selecting queries containing multi-byte strings (#3731; f89097c)$$$TableBrowser$$$$$$Fix a bug where the first row was not adjusted (#3767; ad690e7)$$$etc$$$$$$Fix misleading links to Qt license information (8361aa5)$$$Replace http with https in the AboutDialog and MainWindow (9832a52)$$$Translation$$$German (#3749; 8e38bf0)$$$Indonesian (#3756; 6100595)$$$Japanese (#3755; e0f6aea)$$$Korean (7bbfcf9)$$$Simplified Chinese (#3761; 9eb0a5a)$$$Spanish (ac33918)

DB Browser for SQLite v3.13.1 Latest$$$Changelog$$$Added$$$Add links to the wiki as help for many dialogs (7af1256; b5abc86)$$$Changed$$$Change the default to install a shortcut to the Start menu when installing on Windows (623bec6)$$$Improve icon image for links in Help menu (#3693; 027c6a8)$$$Pragma names and values can now be translated (#3697; bf62f3a; ad00ad4)$$$Remove trailing characters when copying a single cell (#3735; 20f481a)$$$Update AppImage binary to use the latest SQLCipher library (#3744; 21ba2d0)$$$When editing the DB cells; expanded queries with parameters are included in the SQL Log (ac3209f)$$$Fixed$$$ExtendedTableWidget$$$$$$Fix an issue that prevented autocomplete from working in some race conditions (#2567; #3706)$$$Use Tab to close autocomplete popup and move to next item (3aff8c9)$$$Troubleshoot Copy as SQL action on a cell results in string being copied (#1952; 1ebe7bf)$$$Global$$$$$$Fix Argument Missing error in Korean translation (#3635; #3692; cd518de)$$$Fix an issue that caused apps to crash on some older versions of macOS (#3691)$$$Fix an issue when freezing after stopping a pragma (#3742; 15a9620)$$$Fix an issue with outputting the wrong version on macOS$$$Troubleshooting poor HiDPI support on Windows (#3684)$$$Troubleshoot SQL queries containing VACUUM that run incorrectly (#3723; 51784aa)$$$MainWindow$$$$$$Fix an issue when selecting queries containing multi-byte strings (#3731; f89097c)$$$TableBrowser$$$$$$Fix a bug where the first row was not adjusted (#3767; ad690e7)$$$etc$$$$$$Fix misleading links to Qt license information (8361aa5)$$$Replace http with https in the AboutDialog and MainWindow (9832a52)$$$Translation$$$German (#3749; 8e38bf0)$$$Indonesian (#3756; 6100595)$$$Japanese (#3755; e0f6aea)$$$Korean (7bbfcf9)$$$Simplified Chinese (#3761; 9eb0a5a)$$$Spanish (ac33918)

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$$$Wed 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).$$$$$$Theres 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 display formats: binary

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$$$Wed like to take this opportunity to thank him.

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)

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