This is probably our biggest release yet :)

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

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! :wink:

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 :wink:
  • 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, ab5f6cffa702c26bc324e2b951818cbfb14dc462 (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 - e9894b47fac79b970f3e29ca7062bfd84778442e (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 - 63ba2c5059f20488666483c398149f61273b30ac (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 - 35725b05e14bc75853d8902656e35dd8d83274aa (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 - 1a6c34951b9960efe27b0aab599673f3391642fa (thanks to @MKleusberg)
• Allow setting the temporary table flag in Edit Table dialog - 6cc850c167135cfad64f6e7bb1862c6b04b0ae15 (thanks to @MKleusberg)
• Add live SQL preview to the Create Index dialog - 1bd1009588b53dc7dd026e214f47f7d95f6e7041 (thanks to @MKleusberg)
• Allow editing existing indices - c9ceb5da591c63f6eb65e2af637e6b42082f009b (thanks to @MKleusberg)
• When renaming a table column try to fix all indices referencing the column - dc934a7ec781ea95b30ebdd2d9b850a9b3028635 (thanks to @MKleusberg)
• Show better error message when recreating objects after renaming column fails - 0f0b18d427e707ef42322247c08e7bcd43abe4ad (thanks to @MKleusberg)
• Add index columns to database structure tree - 901e087c985095d353ad6e916c09cae9b92cb030 (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 - 58996f134501f25bdd2072e1f6f6e2d49a8faa38 (thanks to @MKleusberg)
• Add support for setting the partial index clause to the Edit Index dialog - e61d7d9fa75fb8cb9f84c83771cbcdf66b125000 (thanks to @MKleusberg)
• Add proper support for multi-column indices to the Edit Index dialog - 6321d14dd60fa2112571e3bab35ea05fef43a881 (thanks to @MKleusberg)
• Add support for expression columns to the Edit Index dialog - 8cc3154c72442160f57e6e5eb400b05bdb8cd3a9 (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 - 2421fef2191da8dec87b4f7d25b1c56ed657aa06, 803a1fa5cb50c8f56d0c7135375d61d39d7f41ab (thanks to @MKleusberg)
• Keep SQL tabs opened after closing the database - #1035 (thanks to @MKleusberg)
• Allow opening and saving SQL files without database opened - 3c40a12103c6ad19132c8ce69a574989a40c0e59 (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 - 7b86b17788cadb7ec08a7bed39aa214dcc42b526 (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 - 99a5d02925ea9743560f8072109365fedbafefd5 (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 - 11ca36ef9dc2d13b00585d91c6567303e5ee6a15 (thanks to @MKleusberg)
• Fix grammar parsing for tables and columns named 'no' - 396589d3d451154f8074803a310a900a55791616, ec9e05ee7f88c38e68c00fcd533c9cf3122f14f1 (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 - 64fdd78105574838f03fb99c6df6934bd9cd9703 (thanks to @MKleusberg)
• Don't convert temporary tables into permanent ones when editing them - cd2f14e2dca3bde24a2a2a0228b5fc1dc4c5f709 (thanks to @MKleusberg)
• Allow table names consisting only of spaces in Edit Table dialog - 5858ea448d8e4e2816773deebfb8a67a122ecd72 (thanks to @MKleusberg)
• Make virtual tables browseable - #917 (thanks to @MKleusberg)
• Save foreign keys settings in the project files - #848 (thanks to @MKleusberg)
• Add support for encryption using the raw key format - #264 (thanks to @MKleusberg)
• Don't show foreign key tooltip within Execute SQL tab - #942 (thanks to @innermous)
• Make sure to register the regexp function when creating a new database - 8da626250d59c375c578b6fe0d0fc77ad9b1e45e (thanks to @MKleusberg)
• Improve error handling in execution of SQL commands - #955, #957 (thanks to @MKleusberg)
• Fix execution of problematic SQL scripts leading to empty commands - 934dd396f4ee6f6cac2fc5a464b76c0d5fbbbabb (thanks to @MKleusberg)
• Fix 'not an error' errors in the Execute SQL tab - #478 (thanks to @MKleusberg)
• Never set integer primary key fields to empty string - #859 (thanks to @MKleusberg)
• Add support for parsing collations in column definitions - #411 (thanks to @MKleusberg)
• Always add absolute path to the recent files menu - #965 (thanks to @dridk)
• Fix plotting with datetimes switching to DST on X axis - #738 (thanks to @prutz1311)
• Fix setting font for statement success/error message in Execute SQL tab - f67817ee680671b6a365eab1b01d627395d6c4f5 (thanks to @MKleusberg)
• Fix window title of Export JSON dialog - ace89f124d143fb7e594f16b399a35df8059f436 (thanks to @justinclift)
• Deactivate Export JSON menu item when no database is loaded - 8b2e93d547c98a84eb92fcbd351d8aabd351a65f (thanks to @justinclift)
• Add support for signed default values to grammar parser - e72df17bc3fc2af04b158e45fe9238ab57aedf58 (thanks to @MKleusberg)
• Add support for CHECK table constraints to grammar parser - 3596bf6c8d786e8daa369408547afee99aef2495 (thanks to @MKleusberg)
• Work around rowid column not being properly hidden when using some Qt versions - f7421a9d62a2b351fb3f53611db3567b583fadf9 (thanks to @MKleusberg)
• Show consistent slashes in recent files menu actions - #735 (thanks to @MKleusberg)
• Avoid executing some unnecessary SQL statements for better performance - #1007, 6984d451d6b249a11215472b5abeb5cba5c69ff3 (thanks to @MKleusberg)
• Fix default path in 'Save file as' dialog - e1fbc98ef2ef056c215fd55c8975f6a91bae10a4 (thanks to @MKleusberg)
• Fix unticking of plot columns when changing other columns or changing table - #950 (thanks to @MKleusberg)
• Improve plot performance - 4706dd7dd70bdd4071fbbdeb346d1de557936112 (thanks to @MKleusberg)
• Avoid warning being printed to console when creating a new database - #583 (thanks to @MKleusberg)
• Fix wrong message box texts when setting the table encoding - e404b22205fb1e79cab16dd62b3a9d5ff10b3ebf (thanks to @MKleusberg)
• Don't show 'Show rowid' menu item for views - 57c4e582c7e8ad2f67c76eceac661c7b2c29d202 (thanks to @MKleusberg)
• Also apply the current selection to the Edit Cell dock when using the keyboard to navigate in Execute SQL tab - #481 (thanks to @MKleusberg)
• Keep current sort order after refreshing in Browse Data tab - #1016 (thanks to @MKleusberg)
• Fix changing the page size pragma using the UI - #1021 (thanks to @MKleusberg)
• Don't include triggers and indices in SQL export if their base tables aren't exported, too - #1013 (thanks to @MKleusberg)
• Make SQL auto completion case insensitive - #1046 (thanks to @MKleusberg)
• Check for errors when reading or writing SQL files - #1036 (thanks to @MKleusberg)
• Enforce quote chars in CSV export for fields with line breaks - #1037 (thanks to @MKleusberg)
• Fix CSV import when line breaks appear at the buffer boundary - #1033 (thanks to @MKleusberg)

Translations

• Updated Simplified Chinese translation - #840, #843, #1085, #1091 (thanks to @bssthu)
• Updated Spanish translation - #924, #1062 (thanks to @lulol)
• Add Ukrainian translation - dd685afef16a1c756a6be907aec7355b864c68ee, db89568cbd6073ac09c5bb7873d84c9aa0da31e6, 0678f7627c20b2e391aacd5bdbac970f4e43a59b (thanks to @keedhost and @Genyk)
• 80% of Czech translation is complete - #1050, #1070, #1071, #1078 (thanks to @MrJiggers)
• Updated German translation - #1060, #1081 (thanks to @FriedrichFroebel)
• Updated French translation - #1066 (thanks to @mvt91)
• Portuguese translation - #1074 (thanks to @mafagafogigante)
• Korean translation - #1083, #1086 (thanks to @progh2)

Building

• Switch to C++11 and Qt5 - #808 (thanks to @MKleusberg)
• Drop Qt4 support - #603 (thanks to @MKleusberg)
• Try using the system version of libscintilla2 - #832 (thanks to @MKleusberg)
• Update QHexEdit library to 0.8.3
• Update QScintilla2 library to version 2.10
• Update QCustomPlot library to version 2.0-beta
• cmake: Add options to disable usage of distribution's libraries - #961 (thanks to @MKleusberg)
• qmake: Add a 'make install' rule - #833 (thanks to @MKleusberg)

Platform specific

• OS X: Change the default SQL editor font size to 12pt - #818 (thanks to @justinclift)
• Windows: Make sure the installer doesn't launch the application as Administrator - #338 (thanks to @justinclift)
• Windows: Add Windows XP support again - #1011 (thanks to @karim)

Other notes

• The win32 download should also work for WinXP too, no separate XP download needed. :smile:
• 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.10.0-win32.exe
  • b5dade746d00c4835c752b4a07e7de9b0ec137a78b51eb879e8d53669dfc9c9b
• DB Browser for SQLite-3.10.0-win64.exe
  • e68b8e22c042d193a4df3f652694bb0e959076ab05e5fdbde9305da467418e7f
• DB Browser for SQLite-3.10.0.dmg
  • b7d5bdc92c4d5b4d1b69203033e75cc537daca00b95e39f737ed32eae728c6aa