Recent Releases

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.