Assets 6

This is a minor bug fix release for most people, but does address one fairly important problem with the Windows installer for the previous (3.10.0) release.

That previous release included updated MSVC redistributables which rebooted some people's computers at the end of the install, without warning or even prompting to save files. 😦

Thanks to a fix by @Mischanix, the installer now instructs the included MSVC redistributes not to reboot when it finishes. Problem solved. πŸ˜„

Bug fixes

General

  • cipher: Fix passphrases containing single quotes - #1105 (thanks to @MKleusberg)
  • cipher: Change tab order in encryption dialog - 9afb0fc (thanks to @MKleusberg)
  • Fix typo in Russian translation - #1107 (thanks to @Vort)
  • Pass /norestart to vcredist installer - #1114 (thanks to @Mischanix)
  • Fix index updating when removing an indexed column from a table - #1115 (thanks to @MKleusberg)
  • Don't automatically commit all changes when editing a table column - #1116 (thanks to @MKleusberg)
  • Make text selectable in Edit dock even if db is opened as read only - #1123 (thanks to @MKleusberg)
  • Add '<>NULL' filter - #1124 (thanks to @MKleusberg)
  • Fix custom type saving when only focus changes for user-entered type - #1147 (thanks to @techee)

DBHub.io related

SHA256SUMS

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

@MKleusberg MKleusberg released this Aug 19, 2017 · 520 commits to master since this release

Assets 5

This is probably our biggest release yet :)

Lots of features were added and many bugs have been fixed. πŸ˜„

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

We hope you're as excited about this as we are! πŸ˜‰

New team members

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

Highlights

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

Enhancements

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

Bug fixes

  • Fix uninitialised memory warnings - #793 (thanks to @revolter)
  • Fix scrolling on MacOS X - #750, #810 (thanks to @revolter)
  • Fix memory leaks - 7b86b17 (thanks to @MKleusberg)
  • Row paging values not cleared from Browse Data table after closing database - #809 (thanks to @revolter)
  • Fix multiple commented out lines not being ignored in Execute SQL tab - #811 (thanks to @revolter)
  • Fix HTML escaping of Execute SQL results - #823 (thanks to @MKleusberg)
  • Fix altering tables with multiple indices - #771 (thanks to @MKleusberg)
  • Fix renaming of table columns when there are foreign keys constraints (thanks to @MKleusberg)
  • Fix fetch all data button for plots based on query data - #820 (thanks to @MKleusberg)
  • Add row number as possible column to select for plotting - #820 (thanks to @MKleusberg)
  • Fix hanging when deleting large number of records - #856, #870 (thanks to @prutz1311)
  • Improve handling of SQLite savepoints - #878, #836 (thanks to @prutz1311)
  • Fix link to SQLite documentation in the user version pragma label - #897 (thanks to @MKleusberg)
  • Apply changed font settings to edit dock without restart - #894 (thanks to @MKleusberg)
  • Fix bugged pagination - #912 (thanks to @innermous)
  • Fix 'modifying table not supported' message - 99a5d02 (thanks to @MKleusberg)
  • Parse columns with explicit NULL (un-)constraint correctly - #741 (thanks to @MKleusberg)
  • Clear edit dock after closing database - #469 (thanks to @MKleusberg)
  • Fix editing table name and table columns at once - 11ca36e (thanks to @MKleusberg)
  • Fix grammar parsing for tables and columns named 'no' - 396589d, ec9e05e (thanks to @MKleusberg)
  • Fix grammar parsing for unquoted use of keywords as DEFAULT values in constraints - #877 (thanks to @MKleusberg)
  • Fix grammar parsing for exotic column data types - 64fdd78 (thanks to @MKleusberg)
  • Don't convert temporary tables into permanent ones when editing them - cd2f14e (thanks to @MKleusberg)
  • Allow table names consisting only of spaces in Edit Table dialog - 5858ea4 (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 - 8da6262 (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 - 934dd39 (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 - f67817e (thanks to @MKleusberg)
  • Fix window title of Export JSON dialog - ace89f1 (thanks to @justinclift)
  • Deactivate Export JSON menu item when no database is loaded - 8b2e93d (thanks to @justinclift)
  • Add support for signed default values to grammar parser - e72df17 (thanks to @MKleusberg)
  • Add support for CHECK table constraints to grammar parser - 3596bf6 (thanks to @MKleusberg)
  • Work around rowid column not being properly hidden when using some Qt versions - f7421a9 (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, 6984d45 (thanks to @MKleusberg)
  • Fix default path in 'Save file as' dialog - e1fbc98 (thanks to @MKleusberg)
  • Fix unticking of plot columns when changing other columns or changing table - #950 (thanks to @MKleusberg)
  • Improve plot performance - 4706dd7 (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 - e404b22 (thanks to @MKleusberg)
  • Don't show 'Show rowid' menu item for views - 57c4e58 (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

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. πŸ˜„
  • 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

@justinclift justinclift released this Aug 13, 2017 · 534 commits to master since this release

Assets 5

The second beta for our 3.10.0 release series!

Highlights

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

Notes

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

Please report any/all bugs you find. πŸ˜„

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

@justinclift justinclift released this Jul 21, 2017 · 581 commits to master since this release

Assets 5

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

@revolter revolter released this Oct 2, 2016 · 9 commits to v3.9.x since this release

Assets 7

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

    2016-10-01 file menu options 1b

    • You can enable/disable this new submenu in Preferences.

    screen shot 2016-10-01 at 17 27 54

Enhancements

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

@revolter revolter released this Aug 24, 2016 · 48 commits to v3.9.x since this release

Assets 6

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

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

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

@revolter revolter released this Aug 13, 2016 · 67 commits to v3.9.x since this release

Assets 6

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

@MKleusberg MKleusberg released this Dec 26, 2015 · 1204 commits to master since this release

Assets 7

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

Cross platform fixes

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

@MKleusberg MKleusberg released this Jun 14, 2015 · 1314 commits to master since this release

Assets 7

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

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

@MKleusberg MKleusberg released this May 4, 2015 · 2 commits to v3.6.x since this release

Assets 7

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
    screen shot 2015-03-11 at 21 49 42

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

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