Recent Releases

3.13.012 Nov 2023 03:15 minor feature:
3.12.208 Jul 2023 19:52 minor feature:
3.12.114 May 2021 07:25 minor feature: Completely reworked interface for accessing DBHub.io. Add.Net DateTime.Ticks to list of supported display formats. Add more options for setting font sizes. New predefined settings for simplified window layout. loading of project files with empty filter values. initial table view when using the -t / --table command line option. 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. plot being drawn before all data is loaded. Restore original default for having condition format in filter line (f28ecc0). default font in the format toolbar (c4b2ffc). Improve binary detection for cases starting by chance by a BOM. Make sure the order of the statements in the SQL log is correct (05db901). executing selected SQL text when there are multi-byte characters. executing SQL queries with compound operators. SQL import of files with BOM. Also update schema when clicking the Refresh button in Browse Data tab (16c3d8d). Select column in table results when column header is pressed. Tweak the output wording for command line options. Remove the default property of the cancel button in the "Fetching data..." dialog. not being saved and not applied when modifying database cells in Windows external program (f2d8f79). incorrect display of SQL calltips containing non-US-ASCII characters (9f7851b). to 'Window Layout' options work properly. 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. No longer force Light theme on macOS when "Follow the desktop style" is chosen (508118f). Keep registry key consistent on Windows. Allow use of integrated graphics card instead of high performance graphics card in macOS. Use native path separators in Preferences dialog (f38b829). Added message box for informative command line arguments for Windows. Remove all translations of key shortcuts (0070a15)
3.12.012 Sep 2020 07:25 minor feature: SQLite 3.25.0 added support for renaming columns with the ALTER TABLE command (previously you had to create a new table with the renamed column, copy all data over, delete the old table, then rename the new table - even leaving out some details of the process here...). This does not only make renaming columns a lot faster, it makes it safer too because the new process is less prone to errors and also makes sure to update all references to the renamed column in your indices and triggers. Starting with this release DB4S makes as much use of this new feature as possible. This gives you the full ALTER TABLE support we offer but additionally, all the benefits just mentioned. . Often you do not edit just one bit of your table schema. For example, when renaming a column you might want to edit its data type or default value too. Before each of these modifications would be carried out immediately which, for large tables, makes editing them very slow and tiresome. With this release DB4S keeps track of all your modifications, only applying them in one single process when clicking the OK button. This should make editing the schema of large tables a lot faster. . We have also added a new constraint editor. This allows you to add and edit constraints for multiple columns but it is also useful for setting constraint names or just getting an overview of all constraints in the table. . We have added a new feature for configuring conditional formats in the Browse Data tab. With this, you can set colours, font, font size, text alignment, and more depending on the values of the cell. It works very similarly to what you might know from your spreadsheet application. . Conditional formats are set per column and multiple formats can be configured for each column. Conditional formats can select for anything that can be filtered for, e.g. equals, does not equal, less than, more than, LIKE, etc. . To set a conditional format you can right-click a cell or right-click a filter bar, the
3.11.119 Feb 2019 19:25 minor feature: 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. . 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. . @SilvioGrosso has kindly created a video showing how to load the math extensions on windows. 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. . 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. . Older format files are loaded fine, but all saving of project files is done using the new project file format. 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. DB Browser Crashes When Importing Its Own.sql dump. Updated qu
3.11.008 Feb 2019 09:25 minor feature: 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. 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. . @SilvioGrosso has kindly created a video showing how to load the math extensions on windows. 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. . 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. 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. Add menu option for attaching database and allow usage of attached databases throughout the entire UI. Make import of multiple CSV files easier to use. Optimise the Import CSV dialog for better usability. Improve speed of preview table for large fields in the Import CSV dialog. Speed up CSV import a lot an
3.11.0-beta316 Dec 2018 22:45 minor feature: Cipher: passphrases containing single quotes - #1105. Cipher: Change tab order in encryption dialog - 9afb0fc. Typo in Russian translation - #1107. Pass /norestart to vcredist installer - #1114. Index updating when removing an indexed column from a table - #1115. Don't automatically commit all changes when editing a table column - #1116. Make text selectable in Edit dock even if db is opened as read only - #1123. Add 'NULL' filter - #1124. Custom type saving when only focus changes for user-entered type - #1147. Dbhub: Tweak certificate UI in the preferences dialog - #1087. Dbhub: progress dialog for very large files - #1095. Dbhub: Remove closing "." from the progress dialog - #1095. Dbhub: Ask user what to do when trying to open an updated database - #1096. Dbhub: Enforce name and commit message length limits in push dialog - #1097. Dbhub: Add tooltip to cog tool button - #1111. Dbhub: Redownload database if local copy has been deleted - #1111. Dbhub: wrong file size being shown for very large files - #1113. Dbhub: Support pushing to different branches than "master" - 5025e4d. Dbhub: Improve file size format - fe7707d. Dbhub: Optimise code - 876d938. Dbhub: branch list in push dialog - 8021523. DB.Browser.for.SQLite-3.10.1-win32.exe 2d4ee7c846aa0c9db36cc18a5078c7c296b8eddea8f8564622fef4bc23fa4368 . 2d4ee7c846aa0c9db36cc18a5078c7c296b8eddea8f8564622fef4bc23fa4368. DB.Browser.for.SQLite-3.10.1-win64.exe 2a04eceaf32d5a96a8a7d8a91f78fdd0bc8c44a5ae7f86cde568fee27d422d12 . 2a04eceaf32d5a96a8a7d8a91f78fdd0bc8c44a5ae7f86cde568fee27d422d12. DB.Browser.for.SQLite-3.10.1.dmg 9456e8ff081004bd16711959dcf3b5ecf9d304ebb0284c51b520d6ad1e0283ed . 9456e8ff081004bd16711959dcf3b5ecf9d304ebb0284c51b520d6ad1e0283ed. SQLiteDatabaseBrowserPortable_3.10.1_English.paf.exe Bd55d13f3fd8fe82ec856cfb430e428b0d921622e0cc5ed192cb5af827bf5f77 . Bd55d13f3fd8fe82ec856cfb430e428b0d921622e0cc5ed192cb5af827bf5f77.
3.11.0-beta212 Dec 2018 07:25 minor feature: Cipher: passphrases containing single quotes - #1105. Cipher: Change tab order in encryption dialog - 9afb0fc. Typo in Russian translation - #1107. Pass /norestart to vcredist installer - #1114. Index updating when removing an indexed column from a table - #1115. Don't automatically commit all changes when editing a table column - #1116. Make text selectable in Edit dock even if db is opened as read only - #1123. Add 'NULL' filter - #1124. Custom type saving when only focus changes for user-entered type - #1147. Dbhub: Tweak certificate UI in the preferences dialog - #1087. Dbhub: progress dialog for very large files - #1095. Dbhub: Remove closing "." from the progress dialog - #1095. Dbhub: Ask user what to do when trying to open an updated database - #1096. Dbhub: Enforce name and commit message length limits in push dialog - #1097. Dbhub: Add tooltip to cog tool button - #1111. Dbhub: Redownload database if local copy has been deleted - #1111. Dbhub: wrong file size being shown for very large files - #1113. Dbhub: Support pushing to different branches than "master" - 5025e4d. Dbhub: Improve file size format - fe7707d. Dbhub: Optimise code - 876d938. Dbhub: branch list in push dialog - 8021523. DB.Browser.for.SQLite-3.10.1-win32.exe 2d4ee7c846aa0c9db36cc18a5078c7c296b8eddea8f8564622fef4bc23fa4368 . 2d4ee7c846aa0c9db36cc18a5078c7c296b8eddea8f8564622fef4bc23fa4368. DB.Browser.for.SQLite-3.10.1-win64.exe 2a04eceaf32d5a96a8a7d8a91f78fdd0bc8c44a5ae7f86cde568fee27d422d12 . 2a04eceaf32d5a96a8a7d8a91f78fdd0bc8c44a5ae7f86cde568fee27d422d12. DB.Browser.for.SQLite-3.10.1.dmg 9456e8ff081004bd16711959dcf3b5ecf9d304ebb0284c51b520d6ad1e0283ed . 9456e8ff081004bd16711959dcf3b5ecf9d304ebb0284c51b520d6ad1e0283ed. SQLiteDatabaseBrowserPortable_3.10.1_English.paf.exe Bd55d13f3fd8fe82ec856cfb430e428b0d921622e0cc5ed192cb5af827bf5f77 . Bd55d13f3fd8fe82ec856cfb430e428b0d921622e0cc5ed192cb5af827bf5f77.
3.11.0-beta128 Nov 2018 07:05 minor feature: Cipher: passphrases containing single quotes - #1105. Cipher: Change tab order in encryption dialog - 9afb0fc. Typo in Russian translation - #1107. Pass /norestart to vcredist installer - #1114. Index updating when removing an indexed column from a table - #1115. Don't automatically commit all changes when editing a table column - #1116. Make text selectable in Edit dock even if db is opened as read only - #1123. Add 'NULL' filter - #1124. Custom type saving when only focus changes for user-entered type - #1147. Dbhub: Tweak certificate UI in the preferences dialog - #1087. Dbhub: progress dialog for very large files - #1095. Dbhub: Remove closing "." from the progress dialog - #1095. Dbhub: Ask user what to do when trying to open an updated database - #1096. Dbhub: Enforce name and commit message length limits in push dialog - #1097. Dbhub: Add tooltip to cog tool button - #1111. Dbhub: Redownload database if local copy has been deleted - #1111. Dbhub: wrong file size being shown for very large files - #1113. Dbhub: Support pushing to different branches than "master" - 5025e4d. Dbhub: Improve file size format - fe7707d. Dbhub: Optimise code - 876d938. Dbhub: branch list in push dialog - 8021523. DB.Browser.for.SQLite-3.10.1-win32.exe 2d4ee7c846aa0c9db36cc18a5078c7c296b8eddea8f8564622fef4bc23fa4368 . 2d4ee7c846aa0c9db36cc18a5078c7c296b8eddea8f8564622fef4bc23fa4368. DB.Browser.for.SQLite-3.10.1-win64.exe 2a04eceaf32d5a96a8a7d8a91f78fdd0bc8c44a5ae7f86cde568fee27d422d12 . 2a04eceaf32d5a96a8a7d8a91f78fdd0bc8c44a5ae7f86cde568fee27d422d12. DB.Browser.for.SQLite-3.10.1.dmg 9456e8ff081004bd16711959dcf3b5ecf9d304ebb0284c51b520d6ad1e0283ed . 9456e8ff081004bd16711959dcf3b5ecf9d304ebb0284c51b520d6ad1e0283ed. SQLiteDatabaseBrowserPortable_3.10.1_English.paf.exe Bd55d13f3fd8fe82ec856cfb430e428b0d921622e0cc5ed192cb5af827bf5f77 . Bd55d13f3fd8fe82ec856cfb430e428b0d921622e0cc5ed192cb5af827bf5f77.
3.11.0-alpha110 Oct 2018 06:25 minor feature: Cipher: passphrases containing single quotes - #1105. Cipher: Change tab order in encryption dialog - 9afb0fc. Typo in Russian translation - #1107. Pass /norestart to vcredist installer - #1114. Index updating when removing an indexed column from a table - #1115. Don't automatically commit all changes when editing a table column - #1116. Make text selectable in Edit dock even if db is opened as read only - #1123. Add 'NULL' filter - #1124. Custom type saving when only focus changes for user-entered type - #1147. Dbhub: Tweak certificate UI in the preferences dialog - #1087. Dbhub: progress dialog for very large files - #1095. Dbhub: Remove closing "." from the progress dialog - #1095. Dbhub: Ask user what to do when trying to open an updated database - #1096. Dbhub: Enforce name and commit message length limits in push dialog - #1097. Dbhub: Add tooltip to cog tool button - #1111. Dbhub: Redownload database if local copy has been deleted - #1111. Dbhub: wrong file size being shown for very large files - #1113. Dbhub: Support pushing to different branches than "master" - 5025e4d. Dbhub: Improve file size format - fe7707d. Dbhub: Optimise code - 876d938. Dbhub: branch list in push dialog - 8021523. DB.Browser.for.SQLite-3.10.1-win32.exe 2d4ee7c846aa0c9db36cc18a5078c7c296b8eddea8f8564622fef4bc23fa4368 . 2d4ee7c846aa0c9db36cc18a5078c7c296b8eddea8f8564622fef4bc23fa4368. DB.Browser.for.SQLite-3.10.1-win64.exe 2a04eceaf32d5a96a8a7d8a91f78fdd0bc8c44a5ae7f86cde568fee27d422d12 . 2a04eceaf32d5a96a8a7d8a91f78fdd0bc8c44a5ae7f86cde568fee27d422d12. DB.Browser.for.SQLite-3.10.1.dmg 9456e8ff081004bd16711959dcf3b5ecf9d304ebb0284c51b520d6ad1e0283ed . 9456e8ff081004bd16711959dcf3b5ecf9d304ebb0284c51b520d6ad1e0283ed. SQLiteDatabaseBrowserPortable_3.10.1_English.paf.exe Bd55d13f3fd8fe82ec856cfb430e428b0d921622e0cc5ed192cb5af827bf5f77 . Bd55d13f3fd8fe82ec856cfb430e428b0d921622e0cc5ed192cb5af827bf5f77.
3.10.121 Sep 2017 05:45 minor feature: Cipher: passphrases containing single quotes - #1105. Cipher: Change tab order in encryption dialog - 9afb0fc. Typo in Russian translation - #1107. Pass /norestart to vcredist installer - #1114. Index updating when removing an indexed column from a table - #1115. Don't automatically commit all changes when editing a table column - #1116. Make text selectable in Edit dock even if db is opened as read only - #1123. Add 'NULL' filter - #1124. Custom type saving when only focus changes for user-entered type - #1147. Dbhub: Tweak certificate UI in the preferences dialog - #1087. Dbhub: progress dialog for very large files - #1095. Dbhub: Remove closing "." from the progress dialog - #1095. Dbhub: Ask user what to do when trying to open an updated database - #1096. Dbhub: Enforce name and commit message length limits in push dialog - #1097. Dbhub: Add tooltip to cog tool button - #1111. Dbhub: Redownload database if local copy has been deleted - #1111. Dbhub: wrong file size being shown for very large files - #1113. Dbhub: Support pushing to different branches than "master" - 5025e4d. Dbhub: Improve file size format - fe7707d. Dbhub: Optimise code - 876d938. Dbhub: branch list in push dialog - 8021523. DB.Browser.for.SQLite-3.10.1-win32.exe 2d4ee7c846aa0c9db36cc18a5078c7c296b8eddea8f8564622fef4bc23fa4368 . 2d4ee7c846aa0c9db36cc18a5078c7c296b8eddea8f8564622fef4bc23fa4368. DB.Browser.for.SQLite-3.10.1-win64.exe 2a04eceaf32d5a96a8a7d8a91f78fdd0bc8c44a5ae7f86cde568fee27d422d12 . 2a04eceaf32d5a96a8a7d8a91f78fdd0bc8c44a5ae7f86cde568fee27d422d12. DB.Browser.for.SQLite-3.10.1.dmg 9456e8ff081004bd16711959dcf3b5ecf9d304ebb0284c51b520d6ad1e0283ed . 9456e8ff081004bd16711959dcf3b5ecf9d304ebb0284c51b520d6ad1e0283ed.
3.10.020 Aug 2017 03:16 minor feature: DBHub.io integration Uploading and downloading of databases works There's a 100MB per database limit atm 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 (!!!) Please report, ideas, suggestions (etc) on the dbhub.io repo tracker as you find them. . Uploading and downloading of databases works. There's a 100MB per database limit atm 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 (!!!). Please report, ideas, suggestions (etc) on the dbhub.io repo tracker as you find them. Many plot improvements (NULL values, progress dialog, remember settings, better colours, and ). 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. Better error reporting when saving the database failed. This also improves working with deferred foreign keys - #770. Make the 'reload' shortcut dependent on the currently active tab - #759, ab5f6cf. Initial dbhub.io integration. Allow plotting of column when there is a NULL value in it - #822. When fetching all table data for plotting show a progress dialog - #499. Remember plot settings for each table and save them in the project files - #819. Improve copying pasting cells, especially with NULL values - #825. Keep the user_version when encrypting an existing database - #846. Use platform-specific default line-endings in Export CSV dialog - #842. Add support for row values to the grammar parser - e9894b4. Add a new display format for converting to Apple NSDates - #890. Make SQL status pane resizable in Execute SQL tab - #906. Add keyboard shortcut for browse table combo box - #908. S
3.10.0-beta214 Aug 2017 03:16 minor feature: DBHub.io was recently announced. ? 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. . You can enable/disable this new submenu in Preferences. 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. . default font selected being incorrectly detected - b15c7f2, 49786e1. Increased custom Page Size upper limit - e12e043. program not being able to uninstall from "Programs and Features" in Windows 7 - 90c094e. executing current line action incorrectly logging the entire SQL - 55d8905. Added HTML entities escaping in output when executing SQL - b9dd11d. 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. Updated Russian translation - #795. Updated Spanish translation - #794, #801. Updated German translation - #798. Updated Korean translation - #797. Updated Brazilian Portuguese translation - #802. DB.Browser.for.SQLite-3.9.1-win32.exe feb8d7bc6a04b84fb5198eafcb16b468b14990e8386a4361e2eb8ad16b7fc282 . feb8d7bc6a04b84fb5198eafcb16b468b14990e8386a4361e2eb8ad16b7fc282. DB.Browser.for.SQLite-3.9.1-win64.exe b844f3528e94d481ecea158d7c18bdcd08ffcadcca17db72c5eb7d2f659656cc . b844f3528e94d481ecea158d7c18bdcd08ffcadcca17db72c5eb7d2f659656cc. DB.Browser.for.SQLite-3.9.1v2.dmg 52c92282e70e9d7f328329e12682d8ab7e06456071465f63196f769d98d6e6d7 . 52c92282e70e9d7f328329e12682d8ab7e06456071465f63196f769d98d6e6d7. SQLiteDatabaseBrowserPortable_3.9.1_English.paf.exe e742214e0500534b608e6dc2b2ef6e63bae9039b6d8f4447715f711d66e66362 . e742214e0500534b608e6dc2b2ef6e63bae9039b6d8f4447715
3.10.0-beta122 Jul 2017 07:05 minor feature: DBHub.io was recently announced. ? 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. . You can enable/disable this new submenu in Preferences. 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. . default font selected being incorrectly detected - b15c7f2, 49786e1. Increased custom Page Size upper limit - e12e043. program not being able to uninstall from "Programs and Features" in Windows 7 - 90c094e. executing current line action incorrectly logging the entire SQL - 55d8905. Added HTML entities escaping in output when executing SQL - b9dd11d. 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. Updated Russian translation - #795. Updated Spanish translation - #794, #801. Updated German translation - #798. Updated Korean translation - #797. Updated Brazilian Portuguese translation - #802. DB.Browser.for.SQLite-3.9.1-win32.exe feb8d7bc6a04b84fb5198eafcb16b468b14990e8386a4361e2eb8ad16b7fc282 . feb8d7bc6a04b84fb5198eafcb16b468b14990e8386a4361e2eb8ad16b7fc282. DB.Browser.for.SQLite-3.9.1-win64.exe b844f3528e94d481ecea158d7c18bdcd08ffcadcca17db72c5eb7d2f659656cc . b844f3528e94d481ecea158d7c18bdcd08ffcadcca17db72c5eb7d2f659656cc. DB.Browser.for.SQLite-3.9.1v2.dmg 52c92282e70e9d7f328329e12682d8ab7e06456071465f63196f769d98d6e6d7 . 52c92282e70e9d7f328329e12682d8ab7e06456071465f63196f769d98d6e6d7. SQLiteDatabaseBrowserPortable_3.9.1_English.paf.exe e742214e0500534b608e6dc2b2ef6e63bae9039b6d8f4447715f711d66e66362 . e742214e0500534b608e6dc2b2ef6e63bae9039b6d8f4447715
3.9.130 Sep 2016 06:05 minor feature: Strong encryption is now supported on Windows, using SQLCipher! - 5d98a19. Keyboard navigation in the "Browse Data" tab now works well. Our releases are now digitally signed on both Windows and MacOS. Add Fedora install instructions - #467, #470. Add Windows DATE display format - #471. Remove ampersands from windows title - d9d2f96. Feature request: Option to turn off "intellisense"-like suggestions - #537. Add select and deselect all options for Export SQL dialog - #549. Add Homebrew Cask install instructions - #564, #566. Add decimal support to display format - #569. Add Edit Database Cell update when selecting a cell from the Execute SQL tab - #570. Cannot view binary data on BLOB columns containing image - #580. Update Fedora install instructions - #586, #587. Add preference setting for exports line ending - #592, #597. Adjust executable/app name according to the project's name - #593. Add duplicate record option - #594. Change default button to No in removal message dialogs - #618. Add default field type preference setting - #652. Add option to export only the data in an SQL export - c8f0203. Remove gy Edit Dialog and improved Edit Dock - #668, #679. Add Ubuntu install instructions on the website - #671. Add Rackspace logo on the website - 6fda155. Add binary data size to the Edit Dock - #699. Update installer.dmg on Mac OS - #693. Add Create Index button in the toolbar and Create Index dialog sizing - #704. Add backspace alongside delete key for cell empty, for laptops missing the delete key - #705. Optimize choosing displayed text for cell - 6b42af7. Improve copy/pasting in ExtendedTableWidget - #709. Feature request: We should sign our official releases - #711. Reimplement data handling in the Edit Cell widget - #713 #410. building on CentOS - #572. crash when browsing data in some cases - 730a272. font blur on retina displays in the SQL Log - #575. crash when trying to delete records from empty table - #590. database toolbar actions not updating after delet
3.9.025 Aug 2016 19:45 minor feature: Strong encryption is now supported on Windows, using SQLCipher! - 5d98a19. Keyboard navigation in the "Browse Data" tab now works well. Our releases are now digitally signed on both Windows and MacOS. Add Fedora install instructions - #467, #470. Add Windows DATE display format - #471. Remove ampersands from windows title - d9d2f96. Feature request: Option to turn off "intellisense"-like suggestions - #537. Add select and deselect all options for Export SQL dialog - #549. Add Homebrew Cask install instructions - #564, #566. Add decimal support to display format - #569. Add Edit Database Cell update when selecting a cell from the Execute SQL tab - #570. Cannot view binary data on BLOB columns containing image - #580. Update Fedora install instructions - #586, #587. Add preference setting for exports line ending - #592, #597. Adjust executable/app name according to the project's name - #593. Add duplicate record option - #594. Change default button to No in removal message dialogs - #618. Add default field type preference setting - #652. Add option to export only the data in an SQL export - c8f0203. Remove gy Edit Dialog and improved Edit Dock - #668, #679. Add Ubuntu install instructions on the website - #671. Add Rackspace logo on the website - 6fda155. Add binary data size to the Edit Dock - #699. Update installer.dmg on Mac OS - #693. Add Create Index button in the toolbar and Create Index dialog sizing - #704. Add backspace alongside delete key for cell empty, for laptops missing the delete key - #705. Optimize choosing displayed text for cell - 6b42af7. Improve copy/pasting in ExtendedTableWidget - #709. Feature request: We should sign our official releases - #711. Reimplement data handling in the Edit Cell widget - #713 #410. building on CentOS - #572. crash when browsing data in some cases - 730a272. font blur on retina displays in the SQL Log - #575. crash when trying to delete records from empty table - #590. database toolbar actions not updating after delet
3.9.0-beta115 Aug 2016 07:45 minor feature: Add proper file extension filters to all file dialogs - 6b8f57d. Improved error handling, e.g. more error messages with more detailed error descriptions - #362, #363, 1696ad1. Allow changing table columns even when there is a foreign key constraint on the table - #362. When holding Ctrl and Shift while clicking on a cell with a foreign key set, the browser now jumps to the referenced record - #192. Add option for disabling the SQL error indicators in the Execute SQL area - #302. Add an option for setting the colours of fields with regular and binary data - #377. Use the name of the imported file as default suggestion for a table name during CSV import - #376. Save filter values, sort order and column widths for all tables when switching the current table or tab; also save the settings in the project file - 748f06d. Show a small clear button inside each filter box - 944e22a. Add basic support for different 'display formats', i.e. a conversion of the contents of a column into a different format for display purposes (e.g. converting a Unix epoch into an actual date) - 7c1d237, 22e858d. Remove deleted files from list of recently opened files - #379. Add a new option for horizontal tiling of the code and result view in the Execute SQL area - #380. Move execution time of the SQL statement to the top of the result view in the Execute SQL area - #381. Add 'x rows affected' information to the result view of the Execute SQL area - 82292c2. Add built-in UTF16 and UTF16CI collation - #391. Add Ctrl+R shortcut (besides F5) for the refresh table button - #388. Add option for setting the font and font size of the text in the table browser view - #383. Support opening of read only database files - #402. Add option for showing the rowid column in the data browser view - #408. Add option for showing the text in the data browser view using a different encoding - #414. Add option for setting an escape character for the filters in the data browser - #421. Add a small delay before apply
3.8.026 Dec 2015 03:15 minor feature: Remove superfluous whitespace from Schema column in DB Structure view - #283. Add option to remember last location for file dialogs - #224, #276, #281. Add option for setting the font used in the SQL code editor - #299. Preserve filters in Browse Data tab when changing tabs - #305. Allow setting the line type and the point shape in the plot area - #317. Add a 'Copy Create statement' popup action to Database Browser tab - #140. UTF-8 characters in SQL code editor - #282. Make sure to always show text data (instead of 'BLOB') in Browse Data tab no matter the column's data type in the table definition - 517ecec. EditTableDialog: Add '=' in front of default value when it is a function - #166. a couple of typos - abc432f. incorrect extra ');' after create table statement in exported SQL - #349. Regexp cannot handle NULL text - #353. Update Russian translation - 07af4b6. Add a Brazilian Portuguese translation - #328. Add an English (United Kingdom) translation - 0f68c85. encoding in CSV test cases - 584f5d6. Restructure tests - 57f2622, 27df9cf, e8b9de3. Use an external antlr2 library if available - ae08f77. Include translations in application resources - #310. Add support for Windows XP again - 4f3855e. Install the vcredist package during installation - d99d83f. @glawrence - (One of our two new team members) for your awesome Community spirit, and the excellent wiki pages you're creating. @schdub - (Our newest team member) for the Russian translations, much coding, and (hopefully) the upcoming ER bits. @Z4us - For helping out with our. Especially the more technical sqlite database ones. @deepsidhu1313 and @lbartoletti - For packaging and porting DB4S on Ubuntu and FreeBSD. MacOS X builds The standard SQLite build bundles SQLite 3.8.10.2. The build including SQLCipher support bundles SQLCipher 3.2.0 (based on SQLite 3.8.6) . The standard SQLite build bundles SQLite 3.8.10.2. The build including SQLCipher support bundles SQLCipher 3.2.0 (based on SQLite 3.8.6). s
3.7.015 Jun 2015 20:45 minor feature: Remove superfluous whitespace from Schema column in DB Structure view - #283. Add option to remember last location for file dialogs - #224, #276, #281. Add option for setting the font used in the SQL code editor - #299. Preserve filters in Browse Data tab when changing tabs - #305. Allow setting the line type and the point shape in the plot area - #317. Add a 'Copy Create statement' popup action to Database Browser tab - #140.
3.6.023 May 2015 07:05 minor feature: Our first 64-bit windows release! If you notice any weirdness from it, please let us know. . Now using Scintilla for our code editor which brings many nice improvements like brace matching, code folding, error highlighting, multi-line tab and shift+tab, better code completion, help texts, etc. Better SQL export. REGEXP support (see the wiki page for details...). NULL value highlighting - customisable in the preferences.
3.5.109 Feb 2015 03:15 minor feature: Default Location field can't be changed in v3.5.0 on OSX - #197 (thanks to @samir-aguiar) Crash when a table name is empty - #194 (thanks to @MKleusberg) CSV Import bug - final row being missed - #193 (thanks to @rp-) Attach database when main is encrypted - #174 (thanks to @MKleusberg) Failure to delete some SQLite entries (.s3db) - #172 (thanks to @MKleusberg) . The MacOS X release has two potential downloads One download uses "standard" SQLite (v3.8.8.2) The other download uses SQLCipher (v3.2.0) to give encryption support for your SQLite databases You only need to download one of them, not both . One download uses "standard" SQLite (v3.8.8.2) The other download uses SQLCipher (v3.2.0) to give encryption support for your SQLite databases You only need to download one of them, not both
3.5.002 Feb 2015 23:05 minor feature: I18N - Simplified Chinese language support. Add tooltip for all table items. Remember CSV export options. Distinguish Save and Save As when saving SQL files in the Execute SQL tab. Add support for compiling on OS/2. Add two buttons to navigate to the head and the tail. Compatibility with shadow build. Support Indices without sorting. FreeBSD Port. Open Encrypted Database. Add full support for tables without rowid. NULL field values are not highlighted. Ability to change language. Foreign Key in Edit Create Table. CSV export bug - Fields aren't automatically quoted when separator character is present in the data. feature request "Execute SQL": clear output if query returns nothing. Export to SQL INT Datatype Expression. Crash when opening db without rowid and composite primary key. Database Structure view: wrong parsing of CHECK constraints. tests: fix QCoreApplication parameters.
3.4.020 Nov 2014 03:15 minor feature: Install icon to hicolor directory bug enhancement fix #136 Updated OSX 10.10 (Yosemite) support status to confirmed #134 Updated Linux support status to confirmed #72 #111 key to move to next filter #106 Fixed the new compile warnings on OSX #102 Access more than one database #100 Add extra path to make it compile on FreeBSD #93 No such collation sequence: LOCALIZED #54 French translation thanks to @mvt91 #92 Allow custom types in edit table dialog #108 Improve handling of default values in the edit table dialog #64 #126 Improve database structure view 7b6bee1 9207e46 . Exporting Text fields should always use quotation marks #135 Insert data problem with NOT NULL #110 Table export to CSV crashes for large tables with out-of-memory exception #107 Refresh Button clears filters #105 Default value not working correctly #97 Crash with inserting 10000 rows #95 Importing csv-file deletes spaces bug #84 Fix query execution when there is an expression in the limit clause #91 Don't allow creating indices on views c7c7774 Data browser: only one result filtered. Bottom left we see 0, where there is 1 #122 Font size too small in log part of "Execute SQL" tab #131 Grammar parser fails to parse two quotes as used for escaping one #128
3.3.102 Sep 2014 21:58 cleanup: Project was renamed to "Browser for SQLite". The OSX build has been updated with a newer SQLite version in it.