DB Browser for SQLite 3.11.2

This is a minor bug fix release in the 3.11.x series

Bug fixes and enhancements since 3.11.1

• #1756 - Enable 'Edit Database Cell' when view is editable
• #1758 - DB browser crashes when I try to attach additional database to current one
• #1764 - CASE-SENSITIVITY: Error importing data from SQL file: cannot start a transaction within a transaction
• #1772 - Cell edit window considers binary data to be text/numeric if first byte is in ascii range
• #1774 - Crashes when browsing a empty view with view editing enabled
• #1777 - Trying to save after successfull import fails
• #1799 - Attach encrypted database results in Out of Memory Error
• #1814 - File is not a database
• #1829 - Can't remove password from an encrypted database any more
• 1a59c8c - grammar: Fix keywords as table name and keywords as column name
• Include SQLite 3.27.2 instead of SQLite 3.27.1
• Include SQLCipher 4.1.0 instead of 4.0.1
• Updated translation strings
  • #1600 - Korean
  • #1830 - Brazilian Portuguese
  • #1833 - Italian
  • e2ad545 - German

SHA256SUMS

• DB.Browser.for.SQLite-3.11.2-win32.msi
  • 0a660c8eefdfbb8be6cf8be2abe223b0149ce8723cc1c19a36b88198be071abe
• DB.Browser.for.SQLite-3.11.2-win32.zip
  • bdfcd05bf1890a3336a1091c6e9740d582167494d0010da061f9effab2243b9e
• DB.Browser.for.SQLite-3.11.2-win64.msi
  • 9db9d0c69c1372f09ef54599e3f87af3e28057a20c2bd6f59787d1cf16edb742
• DB.Browser.for.SQLite-3.11.2-win64.zip
  • c6117e9d75bde6e0a6cbf51ee2356daa0ce41ca2dd3a6f3d1c221a36104531a0
• DB.Browser.for.SQLite-3.11.2.dmg
  • 022536d420dca87285864a4a948b699d01430721b511722bcf9c8713ab946776
• SQLiteDatabaseBrowserPortable_3.11.2_Rev_2_English.paf.exe
  • 552af97ee80c91b096e5268c553c8cb526022938fe550951b5ab02e45df28afc

DB Browser for SQLite 3.11.1

Note that this is effectively 3.11.0 from last week, with a critical bug fix on top + some other additional fixes.

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 alpha/betas, 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 da...

DB Browser for SQLite 3.11.0

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.0-win32.msi
DB.Browser.for.SQLite-3.11.0-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.0-win32.zip
DB.Browser.for.SQLite-3.11.0-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.

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...

DB Browser for SQLite 3.11.0-beta3

This 3.11.0-beta3 release only has minor improvements over yesterdays 3.11.0-beta2.

• 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) too (was already added for Windows in a prior beta).
  • It's 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.
  • @SilvioGrosso has kindly created a video showing how to load the math extensions on windows

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.0-beta3-win32.msi
• DB.Browser.for.SQLite-3.11.0-beta3-win64.msi

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.0-beta3-win32.zip
• DB.Browser.for.SQLite-3.11.0-beta3-win64.zip

If you're not sure which one to get, try the .msi version first. :)

SHA256SUMS

• DB.Browser.for.SQLite-3.11.0-beta3.dmg
  • b667cc94f8f421ce94cb94334589ec23b0807819a791bb0f33490a5496ca2349
• DB.Browser.for.SQLite-3.11.0-beta3-win32.msi
  • 6b0ff8db3d303cbcfe26928b43bcf3f7cfcf09e8a9032f377c9a8ac994bf19f0
• DB.Browser.for.SQLite-3.11.0-beta3-win32.zip
  • d9c35e49432fc2e8d4e51ecf0b75b6284b3bfca0bee8d6f4d21fe1c32e1793f5
• DB.Browser.for.SQLite-3.11.0-beta3-win64.msi
  • eb7c05be05c4080262632d7f41b4998e3458d2467d6802080074e5724720a10f
• DB.Browser.for.SQLite-3.11.0-beta3-win64.zip
  • 8d762e02536516c6a82851c09911bc4fbc38b1000a397a20b530676834692f98

DB Browser for SQLite 3.11.0-beta2

This beta2 release has several improvements over the previous pre-releases for the 3.11.0 series.

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

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.0-beta2-win32.msi
• DB.Browser.for.SQLite-3.11.0-beta2-win64.msi

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.0-beta2-win32.zip
• DB.Browser.for.SQLite-3.11.0-beta2-win64.zip

If you're not sure which one to get, try the .msi version first. :)

SHA256SUMS

• DB.Browser.for.SQLite-3.11.0-beta2.dmg
  • 07ef3c4dc71f163539f1af13fce06f2f13169b30bf8067badfcfa89811cb8dfb
• DB.Browser.for.SQLite-3.11.0-beta2-win32.msi
  • 0be523f1133b914c79c9778762e361009a158c107c4d2d3c883e11bee90a6eef
• DB.Browser.for.SQLite-3.11.0-beta2-win32.zip
  • fd64b534986c2818336533ec61f0995b0bb5869a450dafe86416076df3099c11
• DB.Browser.for.SQLite-3.11.0-beta2-win64.msi
  • 1fad51e88980efda86a29ae0c844b71d7676b0147b8be9d55d7ec4fa3ce116a1
• DB.Browser.for.SQLite-3.11.0-beta2-win64.zip
  • fed5ffe33dd718ad46022313b82ff47ab593be0e73cab628b4f3b2fb4acc9182

DB Browser for SQLite 3.11.0-beta1

This beta1 release has several improvements over the previous (alpha1) release for the 3.11.0 series.

• 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

SHA256SUMS

• DB.Browser.for.SQLite-3.11.0-beta1.dmg
  • b58bce148df957006c3295c812d05e891a08f29b2b8934bfb1e6e45973900892
• DB.Browser.for.SQLite-3.11.0-beta1-win32.msi
  • 4fa771c00fca2726c7326d0dd0cdac9ebb6961faaa47f273f9ba360963607d5f
• DB.Browser.for.SQLite-3.11.0-beta1-win32.zip
  • 150e42f898cb9c208498805ddbf151e385342b6963213d1f4655f88c3cfc608d
• DB.Browser.for.SQLite-3.11.0-beta1-win64.msi
  • 8540f8a6df48751ce242966bdc38c35e2b37ce99e9adc8fe67424fa4658cf142
• DB.Browser.for.SQLite-3.11.0-beta1-win64.zip
  • 90f617f784629cdce73a96697f43935ff8c3e0ab9242175953c215ff09e5cdc6

DB Browser for SQLite 3.11.0-alpha1

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
• Multi-threaded loading of data
• Default quotes changed to double quotes
• Add Record dialog
• Printing support

Notes

• On windows, our new .msi installers don't uninstall the previous releases of DB4S. You'll need to manually uninstall older versions of DB4S yourself first before upgrading.
• Our project file format has changed. Older format files are loaded fine, but all saving of project files is done using the new project file format.
• This alpha1 release has some known outstanding things we intend to address in subsequent alpha or betas:
  • We still need to update the included SQLCipher version, as the version in this alpha1 release is pretty old. That should be done by the next alpha or beta. (@justinclift)
  • The Qt version for Win64 and macOS builds needing updating to the latest release, as this should improve our screen reader and accessibility support (#1451)

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 filte...

DB Browser for SQLite 3.10.1

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)

SHA256SUMS

• DB.Browser.for.SQLite-3.10.1-win32.exe
  • 2d4ee7c846aa0c9db36cc18a5078c7c296b8eddea8f8564622fef4bc23fa4368
• DB.Browser.for.SQLite-3.10.1-win64.exe
  • 2a04eceaf32d5a96a8a7d8a91f78fdd0bc8c44a5ae7f86cde568fee27d422d12
• DB.Browser.for.SQLite-3.10.1.dmg
  • 9456e8ff081004bd16711959dcf3b5ecf9d304ebb0284c51b520d6ad1e0283ed
• SQLiteDatabaseBrowserPortable_3.10.1_English.paf.exe
  • bd55d13f3fd8fe82ec856cfb430e428b0d921622e0cc5ed192cb5af827bf5f77

DB Browser for SQLite 3.10.0

This is probably our biggest release yet :)

Lots of features were added and many bugs have been fixed. 😄

We also did a lot of internal refactoring to lay the foundations for future improvements.

We hope you're as excited about this as we are! 😉

New team members

• Welcome to our new team members @karim and @iKlsR, who both became official members of the sqlitebrowser team over the past few months.
  • Thanks guys, your efforts are very much appreciated. 😁

Highlights

• DBHub.io integration
  • Uploading and downloading of databases works
  • Branching, forking, starring works, as does creating tags and releases
  • There's a 100MB per database limit at the moment though, as it's still in development 😉
  • Backups aren't done on it (yet), so don't use it as your only place for storing important things (!!!)
  • The front page is... not great. We're working on it. 👼
  • Still lots of upcoming stuff needing to be done. An API to query your databases, a cli, merging, discussions/issues
  • Please report bugs, ideas, suggestions (etc) on the dbhub.io repo issue tracker as you find them.
• Many plot improvements (NULL values, progress dialog, remember settings, better colours, and bug fixes)
• Better table editing (foreign key editor, toggling the WITHOUT ROWID flag, temporary tables, ...)
• Better Import CSV dialog. It can now handle multiple CSV files at once
• Improved Index dialog and better index handling in general
• Better handling of virtual tables
• Filter improvements (ranges, NULL search)
• The usual improvements to the grammar parser

Enhancements

• Better error reporting when saving the database failed. This also improves working with deferred foreign keys - #770 (thanks to @MKleusberg)
• Make the 'reload' shortcut dependent on the currently active tab - #759, ab5f6cf (thanks to @MKleusberg)
• Initial dbhub.io integration (thanks to @MKleusberg)
• Allow plotting of column when there is a NULL value in it - #822 (thanks to @MKleusberg)
• When fetching all table data for plotting show a progress dialog - #499 (thanks to @MKleusberg)
• Remember plot settings for each table and save them in the project files - #819 (thanks to @MKleusberg)
• Improve copying & pasting cells, especially with NULL values - #825 (thanks to @innermous)
• Keep the user_version when encrypting an existing database - #846 (thanks to @bssthu)
• Use platform-specific default line-endings in Export CSV dialog - #842 (thanks to @innermous)
• Add support for row values to the grammar parser - e9894b4 (thanks to @MKleusberg)
• Add a new display format for converting to Apple NSDates - #890 (thanks to @shanecb)
• Make SQL status pane resizable in Execute SQL tab - #906 (thanks to @MKleusberg)
• Add keyboard shortcut for browse table combo box - #908 (thanks to @MKleusberg)
• Show more items in tables combobox in Browse Data tab - #867 (thanks to @MKleusberg)
• Don't generate plot colours randomly - #816 (thanks to @MKleusberg)
• Show a message box when editing a table column fails - 63ba2c5 (thanks to @MKleusberg)
• Allow setting and unsetting the WITHOUT ROWID flag for existing tables - #51 (thanks to @MKleusberg)
• Add very, very basic support for virtual tables to the grammar parser - #917 (thanks to @MKleusberg)
• Support named foreign key constraints in the column definition - #741 (thanks to @MKleusberg)
• Support named primary keys in column constraints - #741 (thanks to @MKleusberg)
• Replace ASCII art in pagination controls in Browse Data tab by icons - 35725b0 (thanks to @MKleusberg)
• Enhanced UI for creating and editing foreign keys - #921 (thanks to @innermous)
• Allow opening databases in read only mode - #325 (thanks to @MKleusberg)
• Better error handling when opening a database fails - 1a6c349 (thanks to @MKleusberg)
• Allow setting the temporary table flag in Edit Table dialog - 6cc850c (thanks to @MKleusberg)
• Add live SQL preview to the Create Index dialog - 1bd1009 (thanks to @MKleusberg)
• Allow editing existing indices - c9ceb5d (thanks to @MKleusberg)
• When renaming a table column try to fix all indices referencing the column - dc934a7 (thanks to @MKleusberg)
• Show better error message when recreating objects after renaming column fails - 0f0b18d (thanks to @MKleusberg)
• Add index columns to database structure tree - 901e087 (thanks to @MKleusberg)
• Add new range operator to the filters - #939 (thanks to @schdub)
• Pretty-print CREATE statements in SQL export - #629 (thanks to @MKleusberg)
• Add support for filtering for NULL values - #588 (thanks to @MKleusberg)
• Save some space in the Database Structure tab - #620 (thanks to @MKleusberg)
• Add keyboard shortcuts for switching the currently browsed table - #536 (thanks to @MKleusberg)
• Allow changing case of column name in Edit Table dialog - #985 (thanks to @MKleusberg)
• Slightly reduce row height in data browser to fit more rows into the window - #419 (thanks to @MKleusberg)
• Implement page-wise scrolling using the buttons in Browse Data tab - #232 (thanks to @MKleusberg)
• Add new option for adding DROP statements to exported SQL files, add 'IF NOT EXISTS' to CREATE statements - #629 (thanks to @MKleusberg)
• Add an option to enable editing of views if there are triggers present for this - #141 (thanks to @MKleusberg)
• Completely new design of the Create/Edit Index dialog - 58996f1 (thanks to @MKleusberg)
• Add support for setting the partial index clause to the Edit Index dialog - e61d7d9 (thanks to @MKleusberg)
• Add proper support for multi-column indices to the Edit Index dialog - 6321d14 (thanks to @MKleusberg)
• Add support for expression columns to the Edit Index dialog - 8cc3154 (thanks to @MKleusberg)
• Allow importing multiple CSV files at once - #1018 (thanks to @iKlsR)
• Allow matching similar csv files for batch import - #1018 (thanks to @iKlsR)
• Add context menu to table views - 2421fef, 803a1fa (thanks to @MKleusberg)
• Keep SQL tabs opened after closing the database - #1035 (thanks to @MKleusberg)
• Allow opening and saving SQL files without database opened - 3c40a12 (thanks to @MKleusberg)
• When importing CSV data into existing tables, don't insert empty strings into numeric fields - #195 (thanks to @MKleusberg)
• Allow setting PRAGMAs from the Execute SQL tab - #1021, #980, #966 (thanks to @MKleusberg)
• Add a -v/--version command line switch to display the version number - #1065 (thanks to @FriedrichFroebel)

Bug fixes

• Fix uninitialised memory warnings - #793 (thanks to @revolter)
• Fix scrolling on MacOS X - #750, #810 (thanks to @revolter)
• Fix memory leaks - 7b86b17 (thanks to @MKleusberg)
• Row paging values not cleared from Browse Data table after closing database - #809 (thanks to @revolter)
• Fix multiple commented out lines not being ignored in Execute SQL tab - #811 (thanks to @revolter)
• Fix HTML escaping of Execute SQL results - #823 (thanks to @MKleusberg)
• Fix altering tables with multiple indices - #771 (thanks to @MKleusberg)
• Fix renaming of table columns when there are foreign keys constraints (thanks to @MKleusberg)
• Fix fetch all data button for plots based on query data - #820 (thanks to @MKleusberg)
• Add row number as possible column to select for plotting - #820 (thanks to @MKleusberg)
• Fix hanging when deleting large number of records - #856, #870 (thanks to @prutz1311)
• Improve handling of SQLite savepoints - #878, #836 (thanks to @prutz1311)
• Fix link to SQLite documentation in the user version pragma label - #897 (thanks to @MKleusberg)
• Apply changed font settings to edit dock without restart - #894 (thanks to @MKleusberg)
• Fix bugged pagination - #912 (thanks to @innermous)
• Fix 'modifying table not supported' message - 99a5d02 (thanks to @MKleusberg)
• Parse columns with explicit NULL (un-)constraint correctly - #741 (thanks to @MKleusberg)
• Clear edit dock after closing database - #469 (thanks to @MKleusberg)
• Fix editing table name and table columns at once - 11ca36e (thanks to @MKleusberg)
• Fix grammar parsing for tables and columns named 'no' - 396589d, ec9e05e (thanks to @MKleusberg)
• Fix grammar parsing for unquoted use of keywords as DEFAULT values in constraints - #877 (thanks to @MKleusberg)
• Fix grammar parsing for exotic column data types - 64fdd78 (thanks to @MKleusberg)
• Don't convert temporary tables into ...

DB Browser for SQLite 3.10.0 Beta 2

The second beta for our 3.10.0 release series!

Highlights

• Further updated translations
• Much improved dbhub.io integration
  • Much easier to use list and upload databases
  • The database licence, public/private setting, and a commit message can be set in the upload dialog
  • Try to avoid uploading files over ~100MB in size for now though, as we're investigating a bug around larger sized DB4S 😉
• ... several other minor bug fixes

Notes

• All builds (both Windows and MacOS X) include SQLCipher for strong encryption.
• The version of SQLCipher included is a bit old. We're waiting for the next official SQLCipher release so it can be included.

Please report any/all bugs you find. 😄

    https://github.com/sqlitebrowser/sqlitebrowser/issues/new