DB Browser for SQLite 3.10.0 Beta 1

The first beta for our 3.10.0 release series!

Highlights

• Basic dbhub.io integration
• 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

& many, many other enhancements + bug fixes

Notes

• All builds (both Windows and MacOS X) include SQLCipher for strong encryption.
• The version of SQLCipher included is a bit old. Our next beta or Release Candidate will include the newest version.
• The initial DBHub.io (remote dock) code still needs work, but should be ok to try in the next beta or Release Candidate.

Please report any/all bugs you find. 😄

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

DB Browser for SQLite 3.9.1

*Update 2017-05-14* - Due to popular request, we've added a Windows XP compatible version. If you're using WinXP, you'll want "DB.Browser.for.SQLite-3.9.1v2-winXP.exe".

---

This is a small release that prepares the terrain for a new upcoming feature called DBHub 🎉 plus a few old bugs fixed and some others that were introduced by 3.9.0 🙈.

Major features

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

  

Enhancements

• Decreased lagging with long strings (further work still needed) - #761 (thanks to @innermous and @MKleusberg)

  

• Indicate when display strings are being truncated - #767 (thanks to @justinclift)

• Focus the newly created field after clicking 'Add field' - 64ee665 (thanks to @revolter)

• Improved Execute current SQL line action - #780, 45affc9, 531eddb (thanks to @revolter)

Bug fixes

• Fixed default font selected being incorrectly detected - b15c7f2, 49786e1 (thanks to @innermous and @justinclift)
• Increased custom Page Size upper limit - e12e043 (thanks to @MKleusberg)
• Fixed program not being able to uninstall from "Programs and Features" in Windows 7 - 90c094e (thanks to @justinclift)
• Fixed executing current line action incorrectly logging the entire SQL - 55d8905 (thanks to @revolter)
• Added HTML entities escaping in output when executing SQL - b9dd11d (thanks to @innermous)
• Fixed Indexes with spaces around their name not being able to be deleted - 8be2c54 (thanks to @MKleusberg)
• Removed quotes around content when a single cell is copied - 8c510ff (thanks to @revolter)
• Help button should not be present in Windows title bar - #796 (thanks to @schdub)

Translations

• Updated Russian translation - #795 (thanks to @schdub)
• Updated Spanish translation - #794, #801 (thanks to @lulol)
• Updated German translation - #798 (thanks to @FriedrichFroebel)
• Updated Korean translation - #797 (thanks to @progh2)
• Updated Brazilian Portuguese translation - #802 (thanks to @mafagafogigante)

SHA256SUMS

• DB.Browser.for.SQLite-3.9.1-win32.exe
  • feb8d7bc6a04b84fb5198eafcb16b468b14990e8386a4361e2eb8ad16b7fc282
• DB.Browser.for.SQLite-3.9.1-win64.exe
  • b844f3528e94d481ecea158d7c18bdcd08ffcadcca17db72c5eb7d2f659656cc
• DB.Browser.for.SQLite-3.9.1v2.dmg
  • 52c92282e70e9d7f328329e12682d8ab7e06456071465f63196f769d98d6e6d7
• SQLiteDatabaseBrowserPortable_3.9.1_English.paf.exe
  • e742214e0500534b608e6dc2b2ef6e63bae9039b6d8f4447715f711d66e66362
• DB.Browser.for.SQLite-3.9.1v2-winXP.exe
  • 998347b0980e16c5db557750a4b9ac08a9aff9c39d95b90596e7968adc689100

DB Browser for SQLite 3.9.0

It's been yet another half a year (more precisely, 8 months) since the previous version 3.8.0 was released, and a lot of good things happened. 😄

Major features

• Strong encryption is now supported on Windows, using SQLCipher! - 5d98a19 (thanks to @huy-cong and @justinclift for figuring this out)
• Keyboard navigation in the "Browse Data" tab now works well
• Our releases are now digitally signed on both Windows and MacOS

Enhancements

• Add Fedora install instructions - #467, #470 (thanks to @subdriven)
• Add Windows DATE display format - #471 (thanks to @MyRoGeertGit)
• Remove ampersands from windows title - d9d2f96 (thanks to @MKleusberg)
• Feature request: Option to turn off "intellisense"-like suggestions - #537 (thanks to @MKleusberg)
• Add select and deselect all options for Export SQL dialog - #549 (thanks to @wierzba3)
• Add Homebrew Cask install instructions - #564, #566 (thanks to @timbroder)
• Add decimal support to display format - #569 (thanks to @jungle-boogie)
• Add Edit Database Cell update when selecting a cell from the Execute SQL tab - #570 (thanks to @larsimmisch)
• Cannot view binary data on BLOB columns containing image - #580 (thanks to @justinclift)
• Update Fedora install instructions - #586, #587 (thanks to @FreedomBen)
• Add preference setting for exports line ending - #592, #597 (thanks to @justinclift)
• Adjust executable/app name according to the project's name - #593 (thanks to @justinclift)
• Add duplicate record option - #594 (thanks to @innermous)
• Change default button to No in removal message dialogs - #618 (thanks to @innermous)
• Add default field type preference setting - #652 (thanks to @revolter)
• Add option to export only the data in an SQL export - c8f0203 (thanks to @MKleusberg)
• Remove buggy Edit Dialog and improved Edit Dock - #668, #679 (thanks to @justinclift)
• Add Ubuntu install instructions on the website - #671 (thanks to @justinclift)
• Add Rackspace logo on the website - 6fda155 (thanks to @justinclift)
• Add binary data size to the Edit Dock - #699 (thanks to @revolter)
• Update installer .dmg on Mac OS - #693 (thanks to @justinclift and @revolter)
• Add Create Index button in the toolbar and fixed Create Index dialog sizing - #704 (thanks to @revolter)
• Add backspace alongside delete key for cell empty, for laptops missing the delete key - #705 (thanks to @justinclift)
• Optimize choosing displayed text for cell - 6b42af7 (thanks to @innermous)
• Improve copy/pasting in ExtendedTableWidget - #709 (thanks to @innermous)
• Feature request: We should sign our official releases - #711 (thanks to @justinclift)
• Reimplement data handling in the Edit Cell widget - #713 #410 (thanks to @justinclift)

Bug fixes

• Fix building on CentOS - #572 (thanks to @Maxim-Mazurok)
• Fix crash when browsing data in some cases - 730a272 (thanks to @MKleusberg)
• Fix font blur on retina displays in the SQL Log - #575 (thanks to @nickberry17)
• Fix crash when trying to delete records from empty table - #590 (thanks to @innermous)
• Fix database toolbar actions not updating after deleting a table - #600 (thanks to @revolter)
• Fix cancel button not working in the Export SQL dialog - #608 (thanks to @justinclift)
• Fix Field separator and Quote character preferences not restoring correctly - #609 (thanks to @justinclift)
• Fix various small bugs with the quote and separator choices - #611 (thanks to @justinclift)
• Fix primary keys not being quoted when creating/modifying tables - 7e0adab (thanks to @MKleusberg)
• Fix crash in Browse Data tab when pasting empty string over non-empty cell - 1ce62d7 (thanks to @innermous)
• Fix cell Edit Dialog not showing up centered - #644 (thanks to @DelphiGit)
• Fix Show rowid column option not correctly refreshing the table view - #645 (thanks to @revolter)
• Fix crash when hovering over any row from the rowid column - #646 (thanks to @revolter)
• Fix for unquoted path vulnerability in the Windows app - #649 (thanks to @DelphiGit and @justinclift)
• Fix incorrect app version in Finder's Info view - #658 (thanks to @revolter)
• Fix crash when trying to Export table(s) as CSV in some cases - 2c1ab5b (thanks to @innermous)
• Fix navigation keyboard shortcuts not working in Browse Data tab in some cases - 2bcc603 (thanks to @justinclift)
• Fix DB Toolbar visibility preference setting not restored in some cases - #666 😈 (thanks to @innermous)
• Fix Alt-Delete not setting the selected cell to NULL - #663 (thanks to @justinclift)
• Fix transactions not being ignored when executing SQL - #656 (thanks to @revolter)
• Fix elements focus order on Tab press - #676 (thanks to @chrisjlocke)
• Fix Edit Dialog opening when pressing Enter - a7b5c3f (thanks to @MKleusberg)
• Fix Filter Input row in RTL Locales - #685 (thanks to @SafaAlfulaij)
• Fix Edit Dock default position - 30d2ce3 (thanks to @revolter)
• Fix crash when closing unsaved database (or some other rare cases) - #690 (thanks to @revolter)
• Fix font preference settings not being reflected in the Edit Dock - 7eb733b (thanks to @justinclift)
• Fix Arabic translations not showing up correctly - #702 (thanks to @justinclift)
• Fix cell binary data getting corrupted when trying to edit in place - #708 (thanks to @SafaAlfulaij)
• Fix foreign key preview not showing up for foreign keys in the first column - #718 (thanks to @schdub)

Translations

• Add Korean translation - #475, #736 (thanks to @progh2)
• Add Turkish translation - #546, #548 f33a988 (thanks to @firateski)
• Add Spanish translation - #560, #723, #740 b1c853a (thanks to @lulol)
• Update German translation - #567, #733 (thanks to @FriedrichFroebel)
• Add Arabic translation - #642 (thanks to @0xbsec)
• Update Arabic translation - #706, #716 efba2eb (thanks to @SafaAlfulaij)
• Update Russian translation - #719 (thanks to @schdub)
• Add Brazilian Portuguese translation - #730 (thanks to @mafagafogigante)
• Update French translation - #727 (thanks to @mvt91)

Other notes

You can go to the Change Log for the detailed version of the changes listed here and to the Commit Log for the full list of changes.

SHA256SUMS

• DB Browser for SQLite-3.9.0-win32.exe
  • 91ca3e0ec015fef1bcb8924a9c727dffa170bd8a134ffd742f891440b33bf468
• DB Browser for SQLite-3.9.0-win64.exe
  • 0e1cb18193d7fb8414fb7572ab7055aa1a8bd9c47136af687c42a45be36b5c4f
• DB Browser for SQLite-3.9.0.dmg
  • 6d82db8924c3ff7d9abda45a844fe000db9679255722fb2ebf07b93d9c2f0e11
• SQLiteDatabaseBrowserPortable_3.9.0_English.paf.exe
  • b09e87139291e47e0d4e694d72b70d27a073835f2ec2e02f47bef7b3f3fcb10a

DB Browser for SQLite 3.9.0 Beta 1

Update 2016-08-16

Added a new Qt5 based release for OSX (below). If you're using MacOS, please try that first. If it gives issues please let us know, then fall back to the other one (Qt4 based) until they're resolved. :)

Original release text

The first beta for our 3.9.0 release series!

• All builds (both Windows and MacOS X) include SQLCipher for strong encryption.
• 100% complete translations for Arabic, Spanish, and Russian languages
  • Program language can be manually changed in the Preferences dialog, if it's not auto-detecting on startup

Please report any/all bugs you find. :)

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

If nothing too terrible turns up, the "official" 3.9.0 release will probably be next weekend (~20th August).

DB Browser for SQLite 3.8.0

It is over 6 months since the previous version 3.7.0 was released and a lot has happened since, all the details on which are below and as you can see there is a lot! On MacOS X, this is our first release using Qt5, and it's worth noting we updated the underlying SQLite to version 3.9.2 (on both platforms) this is so we can support the changes made for 3.9.x which impact database schema, see https://www.sqlite.org/releaselog/3_9_2.html for these changes.

You will also notice a lot of "user experience" enhancements and fixes, so hopefully you will find this new release a pleasure to use. 😄
Happy Christmas!

Enhancements

• Add proper file extension filters to all file dialogs - 6b8f57d (thanks to @MKleusberg)
• Improved error handling, e.g. more error messages with more detailed error descriptions - #362, #363, 1696ad1 (thanks to @schdub and @MKleusberg)
• Allow changing table columns even when there is a foreign key constraint on the table - #362 (thanks to @MKleusberg)
• When holding Ctrl and Shift while clicking on a cell with a foreign key set, the browser now jumps to the referenced record - #192 (thanks to @MKleusberg)
• Add option for disabling the SQL error indicators in the Execute SQL area - #302 (thanks to @MKleusberg)
• Add an option for setting the colours of fields with regular and binary data - #377 (thanks to @schdub)
• Use the name of the imported file as default suggestion for a table name during CSV import - #376 (thanks to @MKleusberg)
• 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 (thanks to @MKleusberg)
• Show a small clear button inside each filter box - 944e22a (thanks to @MKleusberg)
• 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 (thanks to @MKleusberg)
• Remove deleted files from list of recently opened files - #379 (thanks to @MKleusberg)
• Add a new option for horizontal tiling of the code and result view in the Execute SQL area - #380 (thanks to @MKleusberg)
• Move execution time of the SQL statement to the top of the result view in the Execute SQL area - #381 (thanks to @MKleusberg)
• Add 'x rows affected' information to the result view of the Execute SQL area - 82292c2 (thanks to @MKleusberg)
• Add built-in UTF16 and UTF16CI collation - #391 (thanks to @sebastian-philipp)
• Add Ctrl+R shortcut (besides F5) for the refresh table button - #388 (thanks to @MKleusberg)
• Add option for setting the font and font size of the text in the table browser view - #383 (thanks to @MKleusberg)
• Support opening of read only database files - #402 (thanks to @MKleusberg)
• Add option for showing the rowid column in the data browser view - #408 (thanks to @MKleusberg)
• Add option for showing the text in the data browser view using a different encoding - #414 (thanks to @MKleusberg)
• Add option for setting an escape character for the filters in the data browser - #421 (thanks to @MKleusberg)
• Add a small delay before applying a new filter value instead of performing an instantaneous search to improve performance on large tables - #415 (thanks to @MKleusberg)
• Automatically add '%...%' wildcards to a filter query - #415 (thanks to @MKleusberg)
• Add Delete and Alt+Delete keyboard shortcuts for setting the current cell to empty string or NULL in the data browser view - #443 (thanks to @MKleusberg)
• Add new option for moving the Edit cell data dialog into a dock which is locked to the main window and stays opened - #416, #440, #441 (thanks to @MKleusberg)
• Allow drag-&-dropping text and files on a cell in the data browser - #441 (thanks to @MKleusberg)
• Add keyboard shortcuts for recently opened files - #432 (thanks to @MKleusberg)
• Add new option for setting a SQL script which gets executed whenever any database file is opened - #451 (thanks to @MKleusberg)
• Allow pasting data (e.g. from a spreadsheet) directly into the data browser view - #453 (thanks to @MilosSubotic)

Bug fixes

• Fix missing SQL log when query contains a line break, also trim the log - #337, #356 (thanks to @schdub and @MKleusberg)
• Also set foreign key settings when creating a new database instead of just setting them when opening a file - 212116a (thanks to @MKleusberg)
• Fix drawing of Unicode characters in the SQL editor where the font settings wouldn't apply as they should have - #365 (thanks to @SevenLines)
• Allow values greater than 10000 in the user_version pragma of a database - #366 (thanks to @schdub)
• Fix adding new a record into a table where all fields are set to a default value - #369 (thanks to @schdub)
• Fix resizing of the code and result view in the Execute SQL area - 6806a9b (thanks to @MKleusberg)
• Fix error message when changing table - #390 (thanks to @MKleusberg and @GeorgijK)
• Fix parsing of double backticks and double quotes used to escape a single one in create table statements - 160bc87, dce47b3 (thanks to @MKleusberg)
• Fix handling of tables when their name contains a backtick - #387 (thanks to @MKleusberg)
• Try to set a better window position when opening the Edit cell data dialog - #342, #394 (thanks to @MKleusberg)
• Fix possible infinite loop in the Edit cell data dialog - #444 (thanks to @manisandro)
• Fix bug when pressing the cancel button in the dialog you see when you're closing a database with unsaved changes - #432 (thanks to @MKleusberg)
• Don't allow conflicting field names in the Edit Table dialog - #460 (thanks to @MKleusberg)

Translations

• Add translation into Traditional Chinese - #425 (thanks to @PeterDaveHello)

Cross platform fixes

• Fix building on OS X 10.10 - #384 (thanks to @jehoffmann)

Notes for the MacOS X binaries

• The OSX binaries were built on an OSX 10.9.5 system, and should be backwards compatible with OSX 10.7 and above (that's the theory anyway... 😉)
• OS X 10.6 is no longer supported - DB4S always crashes on it, and we haven't been able to figure out why. OSX 10.7 and above work well though. If someone wants to investigate this in depth and get OSX 10.6 working again, that would be useful 😁
• The normal release on OSX (without SQLCipher support), bundles SQLite 3.9.2
• The SQLCipher supporting release on OSX bundles SQLCipher 3.3.1 (based on SQLite 3.8.10.2). If you need features from the new SQLite 3.9.x series, you'll have to do without SQLCipher support for now

SHA256SUMS

• sqlitebrowser-3.8.0-win32v3.exe
  • 6013b6f0ba372ed905046b1df990e2dda3ba559df88fdc6da812f00c0000c7e3
• sqlitebrowser-3.8.0-win64v2.exe
  • f632d94d2aedb9591ca36097d2510891fde8548d1ab420b4891700dd516d15ac
• sqlitebrowser-3.8.0v5.dmg
  • b32597066279442e67e363dab9d89cf2533a6624f3a769b0d2681e22552ed3eb
• sqlitebrowser-with_sqlcipher_support-3.8.0v5.dmg
  • 97fcdd0fac7ab96ccea528afa959bf77760c1c80c044313e96db19ab5ef4a9ce
• SQLiteDatabaseBrowserPortable_3.8.0_English.paf.exe
  • 3d2a4fe1248245827639c5fa409a06378368e8409a61bcac4934f50f0237ef53

DB Browser for SQLite 3.7.0

Whilst it is not so long since the release of 3.6.0 this new version contains some important enhancements, and fixes issues that are getting filed a lot. Specifically UTF-8 characters in the SQL Editor window and Windows dependency installation issues.

Please note that with any new translation you will need to manually select it in the preferences if you have used an earlier version, however fresh installs should detect the new translation.

Enhancements

• Remove superfluous whitespace from Schema column in DB Structure view - #283 (thanks to @MKleusberg)
• Add option to remember last location for file dialogs - #224, #276, #281 (thanks to @MKleusberg)
• Add option for setting the font used in the SQL code editor - #299 (thanks to @MKleusberg)
• Preserve filters in Browse Data tab when changing tabs - #305 (thanks to @schdub)
• Allow setting the line type and the point shape in the plot area - #317 (thanks to @schdub)
• Add a 'Copy Create statement' popup action to Database Browser tab - #140 (thanks to @MKleusberg)

Bug fixes

• Fix UTF-8 characters in SQL code editor - #282 (thanks to @MKleusberg)
• 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 (thanks to @schdub)
• EditTableDialog: Add '=' in front of default value when it is a function - #166 (thanks to @MKleusberg)
• Fix a couple of typos - abc432f (thanks to @mafagafogigante)
• Fix incorrect extra ');' after create table statement in exported SQL - #349 (thanks to @schdub)
• Regexp cannot handle NULL text - #353 (thanks to @MKleusberg)

Updated translations

• Update Russian translation - 07af4b6 (thanks to @schdub)
• Add a Brazilian Portuguese translation - #328 (thanks to @mafagafogigante)
• Add an English (United Kingdom) translation - 0f68c85 (thanks to @glawrence)

For packagers

• Fix encoding in CSV test cases - 584f5d6 (thanks to @pinotree)
• Restructure tests - 57f2622, 27df9cf, e8b9de3 (thanks to @pinotree)
• Use an external antlr2 library if available - ae08f77 (thanks to @pinotree)
• Include translations in application resources - #310 (thanks to @schdub)

Windows release

• Add support for Windows XP again - 4f3855e (thanks to @rp-)
• Install the vcredist package during installation - d99d83f (thanks to @rp-)

Special thanks

• @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 issues. Especially the more technical sqlite database ones. 😀
• @deepsidhu1313 and @lbartoletti - For packaging and porting DB4S on Ubuntu and FreeBSD. 😄

Other notes

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

SHA256SUMS

• sqlitebrowser-3.7.0-win32.exe
  • dd61e4a9458f89016a100da51bbdef636a9c907c2daae424ab61a5a5c468d189
• sqlitebrowser-3.7.0-win64.exe
  • 614dbb321d10bef847cdfbd893a801b9b4db3d04feb7026b3b7711cd968b9424
• sqlitebrowser-3.7.0.dmg
  • 421dc0d64a61f393bee6a482bc32fbdce4b4cdab6f5be10e9214624604079bbb
• sqlitebrowser-with_sqlcipher_support-3.7.0.dmg
  • 37fa7dca77bad0cf14616f44538f2fb9372d97310be3017a57d1045051faf9b3
• SQLiteDatabaseBrowserPortable_3.7.0_English.paf.exe
  • bb10b8c76a7b8d70fe3fc03de12f67414cf990d55dfeb6d01247af9b951847fc

DB Browser for SQLite 3.6.0

NOTE - On windows, if you get an error message about MSVCP120.dll being missing, then you need to install the (free) Microsoft Visual C++ Redistributable Packages for Visual Studio 2013, available here. It's pretty easy. 😉

Release 3.6.0 is here!

After a LOOONG wait (over two and a half months!) version 3.6.0 is ready for your use.

This is a very big update - including our very first 64-bit windows build - with tonnes of usability enhancements, bug fixes, and many improvements. You'll want to upgrade to this. 😀

Major new features are...

• 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
  

Enhancements

• Highlight NULL values in all table views and make the highlighting configurable - #163 and #220 (thanks to @Samir-Aguiar)
• Use Scintilla as code editor - #260 (thanks to @MKleusberg)
• Allow manually setting the application language in the Preferences Dialog - #182 (thanks to @Samir-Aguiar)
• Pressing tab on last field of "Browse Data" now auto-creates a new record, making it faster to add new rows - #209 (thanks to @MKleusberg)
• Added an AppData file for all the Linux software centres - #178 (thanks to @glawrence)
• Add an option for the tab size in the SQL code editor - d8cdcbd (thanks to @rp-)
• Add option to name the columns in the SQL export files - #242 (thanks to @schdub)
• Allow schema only export when exporting SQL files - #103 (thanks to @schdub)
• Allow resizing multiple columns at once in the Browse Data tab - #241 (thanks to @schdub)
• Mark syntax errors in the Execute SQL tab after their execution failed - 649b179 (thanks to @MKleusberg)
• Data browsing using Database Structure table selection - #246 (thanks to @MKleusberg)
• Add support for non-integer primary keys in Without Rowid tables - #240 (thanks to @MKleusberg)
• Add option to Preferences Dialog to disable automatic version check - #173 and #208 (thanks to @MKleusberg)
• Improve error messages a little bit - 3c24397, b2b068f, and 808c771 (thanks to @MKleusberg)
• Add support for CR line ending in the CSV import - #212 (thanks to @Samir-Aguiar)
• Add implementation for the REGEXP operator in SQL code - #215 (thanks to @MKleusberg)
• Allow copying information in About dialog - #222 (thanks to @MKleusberg)
• Set focus to text edit after clearing in Edit Data dialog - 50c0340 (thanks to @Samir-Aguiar)
• Support MSVC2013 builds - 8cbc13a (thanks to @rp-)

Bug fixes

• Some translations had the Preferences menu in the wrong place on OSX - #200 (thanks to @MKleusberg)
• Fix new version check - 2c25b7e (thanks to @MKleusberg)
• Fix +Infinite and -Infinite Expression on Export Database to SQL file - #244 (thanks to @schdub)
• Fix type of imported BLOB data - #239 (thanks to @schdub)
• Modify Table list selection could be 'fooled' by dragging - #261 (thanks to @MKleusberg)
• There were no file format filters in the Open File dialog when opening a database file - #266 (thanks to @Samir-Aguiar)
• Escape special characters in headers and values correctly in CSV export - #219 (thanks to @Samir-Aguiar)
• Grammar parser didn't read foreign key column constraints - #227 (thanks to @MKleusberg)
• Fix crash when having a table with a foreign key referencing a column the name of which uses different upper/lower case characters - #228 (thanks to @MKleusberg)
• Disable actions to save SQL when no file is open - #233 (thanks to @Samir-Aguiar)
• Don't add file filters on OS X in Edit Data dialog to work around a Qt bug - #230 (thanks to @Samir-Aguiar)
• Fix bug where sort arrows in the Browse Data tab were pointing in the wrong direction - #231 (thanks to @Samir-Aguiar)

Translations

• Updated the French translation - d6f9716 (thanks to @mvt91)

Other notes

• New Windows builds
  • New 64-bit build
  • Updated to QT 5.4.1 (shared dll)
  • Bundles SQLite 3.8.9
  • Requires the (free) Microsoft Visual C++ Redistributable Packages for Visual Studio 2013 to be installed, available here.
• MacOS X builds
  • The standard SQLite build bundles SQLite 3.8.9
  • The build including SQLCipher support bundles SQLCipher 3.2.0 (based on SQLite 3.8.6)

Special thanks

• @glawrence for writing wiki pages, helping our with issues, and getting his first commit done for the AppData issue! 😉
• @richardfontana for helping us with legal pointers!
• @lbartoletti for updating the FreeBSD port.
• @deepsidhu1313 for volunteering to package .debs for our releases.
• @Z4us for answering people's questions and generally being helpful 😄
• @cbredesen for taking the time to compile a special 32-bit OSX build for us to help a DB4S Community member out
• And last but not least, thank you to all of the people who are suggesting ideas, or reporting issues and confirming back if the fixes work or not. It really makes a positive difference!

SHA256SUMS

• sqlitebrowser-3.6.0v3-win32.exe
  • d3edc5fd80a152c7d219ba8298d8c52b3dd8a87f6a4f5a9fb66f00e619bbabe5
• sqlitebrowser-3.6.0v3-win64.exe
  • 21c406468ed6f3a61909162a696602d6079c84d2c8cab96b61a9a24bde54e2c6
• sqlitebrowser-3.6.0.dmg
  • 6231a90898cf2189b5d9715e64a04d59c9f1aa83ca81501274ab03316f0adf06
• sqlitebrowser-with_sqlcipher_support-3.6.0.dmg
  • 580c439c8c43bd81adb234314ccb14a5972e3a4222287428f175b0f67fcd6ccf
• SQLiteDatabaseBrowserPortable_3.6.0_English.paf.exe
  • d0288aca18b86efc6ef51d3e38f20632a637385a99a576bff4e0b7fb5530c7c8

DB Browser for SQLite 3.5.1

This release fixes some important issues which showed up in v3.5.0 (just over a week ago).

Also, the embedded version of SQLite on MacOS X has been updated to version 3.8.8.2, matching the windows version.

Bug fixes

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

Other notes

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

DB Browser for SQLite 3.5.0

DB Browser for SQLite v3.5.0 is now available for download! 😀

One of the major improvements in this release, is support for encrypted databases (for MacOS X and Linux only, not Windows yet). This is done using the SQLCipher encryption library.

In addition to that, there are a lot of significant bug fixes and general improvements. It's definitely worth updating, if you're in doubt. 😄

Enhancements

• I18N - Simplified Chinese language support - #138 (thanks to @efreeking)
• Add tooltip for all table items - #139 (thanks to @xiangxw and @MKleusberg)
• Remember CSV export options - #149 (thanks to @MKleusberg)
• Distinguish Save and Save As when saving SQL files in the Execute SQL tab - #152 (thanks to @MKleusberg)
• Add support for compiling on OS/2 - #157 (thanks to @TeLLie)
• Add two buttons to navigate to the head and the tail - #169 (thanks to @yunfzhan)
• Compatibility with shadow build - #175 (thanks to @Samir-Aguiar)
• Support Indices without sorting - #176 (thanks to @MKleusberg)
• FreeBSD Port - #180 (thanks to @lbartoletti)

Enhancements with progress, though more still needs to be done

• Open Encrypted Database - #12 (thanks to @MKleusberg)
• Add full support for tables without rowid - #51 (thanks to @MKleusberg)
• NULL field values are not highlighted - #163 (thanks to @MKleusberg)
• Ability to change language - #182 #187 (thanks to @Samir-Aguiar)

Bug fixes

• Foreign Key in Edit Create Table - #109 (thanks to @MKleusberg)
• CSV export bug - Fields aren't automatically quoted when separator character is present in the data - #144 (thanks to @MKleusberg)
• [feature request]"Execute SQL": clear output if query returns nothing - #151 (thanks to @MKleusberg)
• Export to SQL INT Datatype Expression - #156 (thanks to @rp-)
• Crash when opening db without rowid and composite primary key - #159 (thanks to @rp-)
• Database Structure view: wrong parsing of CHECK constraints - #179 (thanks to @MKleusberg )
• tests: fix QCoreApplication parameters #185 (thanks to @pinotree)

Other notes

• The Windows release uses SQLite v3.8.8.2
• The MacOS X release has two potential downloads
  • One download uses "standard" SQLite (v3.8.8.1)
  • 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 😄

DB Browser for SQLite 3.4.0

Our first release using the new(-ish) name of "DB Browser for SQLite". 😄

In this release, our CSV file import and export code has been extensively
modified for better RFC compatibility. The CSV code has also been changed
to use a streaming approach (thanks Rene!) instead of loading everything
into memory first. This allows the import and export of large data sets, which
previously crashed the application when it ran out of memory.

Another important feature in this release is support for custom collation
sequences. This lets people use SQLite3 databases copied from their Android
phone or tablet. Previously, the database would load, but every operation
would error out with "No such collation sequence: LOCALIZED". Should be
useful. 😉

Naturally this release has several other bug fixes and usability tweaks, plus
the bundled version of SQLite has been updated to the latest (v3.8.7).

Enhancements

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

Bug Fixes

• 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