Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:
OTHER License
Bot releases are visible (Hide)
Published by justinclift almost 4 years ago
This is the first bug fix release for our 3.12.x series.
There aren't any "super critical must upgrade" bugs fixed, so updating isn't urgent. 😄
The changes in this over the 3.12.0 release include:
Published by MKleusberg about 4 years ago
This is the first, and hopefully only 😉, release candidate for DB Browser for SQLite version 3.12.1.
The changes in this over the 3.12.0 release include:
Published by justinclift over 4 years ago
SQLite 3.25.0 added support for renaming columns with the ALTER TABLE
command (previously you had to create a new table with the renamed column, copy all data over, delete the old table, then rename the new table - even leaving out some details of the process here...). This does not only make renaming columns a lot faster, it makes it safer too because the new process is less prone to errors and also makes sure to update all references to the renamed column in your indices and triggers. Starting with this release DB4S makes as much use of this new feature as possible. This gives you the full ALTER TABLE support we offer but additionally, all the benefits just mentioned.
Often you do not edit just one bit of your table schema. For example, when renaming a column you might want to edit its data type or default value too. Before each of these modifications would be carried out immediately which, for large tables, makes editing them very slow and tiresome. With this release DB4S keeps track of all your modifications, only applying them in one single process when clicking the OK button. This should make editing the schema of large tables a lot faster.
We have also added a new constraint editor. This allows you to add and edit constraints for multiple columns but it is also useful for setting constraint names or just getting an overview of all constraints in the table.
We have added a new feature for configuring conditional formats in the Browse Data tab. With this, you can set colours, font, font size, text alignment, and more depending on the values of the cell. It works very similarly to what you might know from your spreadsheet application.
Conditional formats are set per column and multiple formats can be configured for each column. Conditional formats can select for anything that can be filtered for, e.g. equals, does not equal, less than, more than, LIKE, etc.
To set a conditional format you can right-click a cell or right-click a filter bar, then click 'Edit Conditional Formats...' to open the dialog. If you are currently filtering the view, you can also right-click the filter bar and click 'Use for Conditional Format' to quickly add a conditional format for the current filter condition.
Your configured conditional formats are saved to your project files as well.
Additionally there is a new format toolbar which allows you to set formats arbitrarily without giving any condition. This allows you to format the table contents just like a table in your favourite spreadsheet application, e.g. for presentations or printing.
SQL queries are now running in a separate thread. This means the UI can respond while the query is running. For long-running queries, this makes a huge difference because it allows you to cancel the query anytime.
SQLite does not support accessing the database from multiple threads simultaneously for all database configurations. Because we want to make sure that it is impossible to corrupt a database file, DB4S does not allow two queries or one query and another long-running process to run simultaneously. In the status bar, you are now notified of any long-running processes and you can cancel them too. But no worries: Whenever you try to start a second query, a message box will inform you and let you decide whether to cancel or wait for the other process to finish.
It is now possible to sort by multiple columns in the Browse Data tab. You can configure any number of sort keys. Their order will appear in the column headers.
Simply clicking a column header resets any old sort orders and sorts by just the clicked column. To add another sort key hold the Ctrl / cmd key while clicking the column header. Holding the Ctrl / cmd key and clicking a column header which is already in the list of columns for sorting changes the sort order of that column.
All the columns used for sorting are stored in your project files.
DB4S comes with a SQL parser which is used to analyse the tables schemas. The parser is not perfect and when failing to parse a certain table or index schema, you will not be able to use all features of DB4S on that table or index. Especially editing the schema but also to some extent modifying the contents of the table will not be possible. So even though it is not directly visible, the parser is a very important part of the application.
This release comes with a new parser. This allows us to fix a lot of problems, for example with complex CHECK constraints, which are now working as expected. The new parser is not only more robust, but it also extracts more information out of the SQL statements which makes editing these tables a smoother experience.
Finally, the new parser can handle Unicode characters in table and column names just like SQLite does. So if your table schema contains these characters the table will now display correctly.
We have added a find toolbar and a find and replace dialog to the Execute SQL editors. This means you can quickly jump to your search terms in the Execute SQL editor using the toolbar. But you can also open the more powerful dialog for more search options or replacing text. There are new toolbar icons at the top with new keyboard shortcuts.
We have also added the find and replace dialog to all other editors. This includes the Edit Cell and the SQL log docks because these might show a lot of text which is hard to navigate without a search option.
Additionally, we have added a new find and a new find and replace toolbar to the Browse Data tab. This allows you to look for values or patterns in the currently browsed table without applying a filter. This is especially useful when you have already specified a filter and do not want to change that. The new replace toolbar allows you to replace values without having to switch the tab or write a SQL statement.
Finally there is a new field 'Filter in all columns'. Type any number of words here to limit the view to only those rows which contain all these words, no matter in which column. This is super useful when looking for a certain value in a table without knowing in which column it could be.
This release includes a whole bunch of UI improvements throughout the application, too many to list them all here. Most notably maybe is the improved handling of project files. But there are also new keyboard shortcuts, cleaner window layouts, and many more details.
There are also more ways in which you can change the window layout and the UI is more responsive to your needs.
We have added proxy support to our network code. So it is finally possible to use DB4S through a proxy, for example, your company proxy. This also changes the defaults to use the system proxy configuration instead of not using any proxy at all.
The proxy settings affect all network code. This includes the automatic update check on Windows and macOS but also the dbhub.io integration. If you have not heard of it before, dbhub.io is a cloud service which allows you to work on SQLite databases collaboratively. It is developed by the same developers as DB4S. You can check it out for free. 😄
To change the proxy settings, open the Preferences dialog, go to the Remote tab, and click on the Configure button in the proxy section.
There are some major speed improvements in this release. The improved speed when editing a table schema has already been mentioned. The new SQL parser is also vastly faster which can make opening and browsing databases with lots of tables noticeably faster. The SQL import feature is faster too.
But other than that we have made a ton of small adjustments, each improving the performance a tiny bit. These are significant when combined, especially on older systems. This should make your overall experience a lot smoother.
In v3.11, the project file format was changed to support multiple sort columns (#1593), the database read-only state and the saving of configured conditional formats, while the handling of project files itself was improved too. While v.3.11 could read project files from previous versions, all saving of project files was done using the new project file format.
v3.12 will be the last version to support the pre-3.11 project file format - v3.13 won't be able to read the older format.
Published by justinclift over 4 years ago
This is the first, and hopefully only 😁, release candidate for DB Browser for SQLite version 3.12.0.
The changes in this from the alpha1 release:
There are a few text strings that still need an updated translation. We'll get those done over the next few days, and as long as no serious bugs turn up we'll make the final release next weekend or so. 😄
In v3.11, the project file format was changed to support multiple sort columns (#1593), the database read-only state and the saving of configured conditional formats, while the handling of project files itself was improved too. While v.3.11 could read project files from previous versions, all saving of project files was done using the new project file format.
v3.12 will be the last version to support the pre-3.11 project file format - v3.13 won't be able to read the older format.
Published by MKleusberg over 4 years ago
SQLite 3.25.0 added support for renaming columns with the ALTER TABLE
command (previously you had to create a new table with the renamed column, copy all data over, delete the old table, then rename the new table - even leaving out some details of the process here...). This does not only make renaming columns a lot faster, it makes it safer too because the new process is less prone to errors and also makes sure to update all references to the renamed column in your indices and triggers. Starting with this release DB4S makes as much use of this new feature as possible. This gives you the full ALTER TABLE support we offer but additionally, all the benefits just mentioned.
Often you do not edit just one bit of your table schema. For example, when renaming a column you might want to edit its data type or default value too. Before each of these modifications would be carried out immediately which, for large tables, makes editing them very slow and tiresome. With this release DB4S keeps track of all your modifications, only applying them in one single process when clicking the OK button. This should make editing the schema of large tables a lot faster.
We have also added a new constraint editor. This allows you to add and edit constraints for multiple columns but it is also useful for setting constraint names or just getting an overview of all constraints in the table.
We have added a new feature for configuring conditional formats in the Browse Data tab. With this, you can set colours, font, font size, text alignment, and more depending on the values of the cell. It works very similarly to what you might know from your spreadsheet application.
Conditional formats are set per column and multiple formats can be configured for each column. Conditional formats can select for anything that can be filtered for, e.g. equals, does not equal, less than, more than, LIKE, etc.
To set a conditional format you can right-click a cell or right-click a filter bar, then click 'Edit Conditional Formats...' to open the dialog. If you are currently filtering the view, you can also right-click the filter bar and click 'Use for Conditional Format' to quickly add a conditional format for the current filter condition.
Your configured conditional formats are saved to your project files as well.
Additionally there is a new format toolbar which allows you to set formats arbitrarily without giving any condition. This allows you to format the table contents just like a table in your favourite spreadsheet application, e.g. for presentations or printing.
SQL queries are now running in a separate thread. This means the UI can respond while the query is running. For long-running queries, this makes a huge difference because it allows you to cancel the query anytime.
SQLite does not support accessing the database from multiple threads simultaneously for all database configurations. Because we want to make sure that it is impossible to corrupt a database file, DB4S does not allow two queries or one query and another long-running process to run simultaneously. In the status bar, you are now notified of any long-running processes and you can cancel them too. But no worries: Whenever you try to start a second query, a message box will inform you and let you decide whether to cancel or wait for the other process to finish.
It is now possible to sort by multiple columns in the Browse Data tab. You can configure any number of sort keys. Their order will appear in the column headers.
Simply clicking a column header resets any old sort orders and sorts by just the clicked column. To add another sort key hold the Ctrl / cmd key while clicking the column header. Holding the Ctrl / cmd key and clicking a column header which is already in the list of columns for sorting changes the sort order of that column.
All the columns used for sorting are stored in your project files.
DB4S comes with a SQL parser which is used to analyse the tables schemas. The parser is not perfect and when failing to parse a certain table or index schema, you will not be able to use all features of DB4S on that table or index. Especially editing the schema but also to some extent modifying the contents of the table will not be possible. So even though it is not directly visible, the parser is a very important part of the application.
This release comes with a new parser. This allows us to fix a lot of problems, for example with complex CHECK constraints, which are now working as expected. The new parser is not only more robust, but it also extracts more information out of the SQL statements which makes editing these tables a smoother experience.
Finally, the new parser can handle Unicode characters in table and column names just like SQLite does. So if your table schema contains these characters the table will now display correctly.
We have added a find toolbar and a find and replace dialog to the Execute SQL editors. This means you can quickly jump to your search terms in the Execute SQL editor using the toolbar. But you can also open the more powerful dialog for more search options or replacing text. There are new toolbar icons at the top with new keyboard shortcuts.
We have also added the find and replace dialog to all other editors. This includes the Edit Cell and the SQL log docks because these might show a lot of text which is hard to navigate without a search option.
Additionally, we have added a new find and a new find and replace toolbar to the Browse Data tab. This allows you to look for values or patterns in the currently browsed table without applying a filter. This is especially useful when you have already specified a filter and do not want to change that. The new replace toolbar allows you to replace values without having to switch the tab or write a SQL statement.
Finally there is a new field 'Filter in all columns'. Type any number of words here to limit the view to only those rows which contain all these words, no matter in which column. This is super useful when looking for a certain value in a table without knowing in which column it could be.
This release includes a whole bunch of UI improvements throughout the application, too many to list them all here. Most notably maybe is the improved handling of project files. But there are also new keyboard shortcuts, cleaner window layouts, and many more details.
There are also more ways in which you can change the window layout and the UI is more responsive to your needs.
We have added proxy support to our network code. So it is finally possible to use DB4S through a proxy, for example, your company proxy. This also changes the defaults to use the system proxy configuration instead of not using any proxy at all.
The proxy settings affect all network code. This includes the automatic update check on Windows and macOS but also the dbhub.io integration. If you have not heard of it before, dbhub.io is a cloud service which allows you to work on SQLite databases collaboratively. It is developed by the same developers as DB4S. You can check it out for free. 😄
To change the proxy settings, open the Preferences dialog, go to the Remote tab, and click on the Configure button in the proxy section.
There are some major speed improvements in this release. The improved speed when editing a table schema has already been mentioned. The new SQL parser is also vastly faster which can make opening and browsing databases with lots of tables noticeably faster. The SQL import feature is faster too.
But other than that we have made a ton of small adjustments, each improving the performance a tiny bit. These are significant when combined, especially on older systems. This should make your overall experience a lot smoother.
In v3.11, the project file format was changed to support multiple sort columns (#1593), the database read-only state and the saving of configured conditional formats, while the handling of project files itself was improved too. While v.3.11 could read project files from previous versions, all saving of project files was done using the new project file format.
v3.12 will be the last version to support the pre-3.11 project file format - v3.13 won't be able to read the older format.
Published by justinclift over 5 years ago
This is a minor bug fix release in the 3.11.x series
Published by justinclift over 5 years ago
Note that this is effectively 3.11.0 from last week, with a critical bug fix on top + some other additional fixes.
We've moved to providing MSI based installers, instead of the previous .exe ones. These new installers include both SQLite and SQLCipher (for optional encryption):
DB.Browser.for.SQLite-3.11.1-win32.msi
DB.Browser.for.SQLite-3.11.1-win64.msi
These MSI based installers will automatically detect the previous release of DB4S (3.10.1) and remove it before upgrading. If you're using one of the 3.11.0 alpha/betas, or an older version of DB4S than 3.10.1, you'll need to manually remove it first before the upgrade.
Additionally, there's now a .zip version of each. That's useful for people needing to run DB Browser for SQLite without installing it first.
DB.Browser.for.SQLite-3.11.1-win32.zip
DB.Browser.for.SQLite-3.11.1-win64.zip
If you're not sure which one to get, try the .msi version first. 😄
The macOS installation now includes the SQLite math extensions (math.dylib
), located in the Contents/Extensions/
folder inside DB Browser for SQLite.app
.
Tools
→ Load Extension
), or tell DB4S to automatically load it every time (Preferences
→ Extensions
)..app
folders in file selection dialogs. To navigate to the correct folder you'll probably need to press Shift (⇧)+Command (⌘)+g when the file selection dialog is open, then give it the path of /Applications/DB Browser for SQLite.app/Contents/Extensions
.load_extension()
is only enabled when explicitly requested by the user in a new setting (#1558)Published by MKleusberg over 5 years ago
We've moved to providing MSI based installers, instead of the previous .exe ones. These new installers include both SQLite and SQLCipher (for optional encryption):
DB.Browser.for.SQLite-3.11.0-win32.msi
DB.Browser.for.SQLite-3.11.0-win64.msi
These MSI based installers will automatically detect the previous release of DB4S (3.10.1) and remove it before upgrading. If you're using one of the 3.11.0 alphas/beta, or an older version of DB4S than 3.10.1, you'll need to manually remove it first before the upgrade.
Additionally, there's now a .zip version of each. That's useful for people needing to run DB Browser for SQLite without installing it first.
DB.Browser.for.SQLite-3.11.0-win32.zip
DB.Browser.for.SQLite-3.11.0-win64.zip
If you're not sure which one to get, try the .msi version first. 😄
The macOS installation now includes the SQLite math extensions (math.dylib
), located in the Contents/Extensions/
folder inside DB Browser for SQLite.app
.
Tools
→ Load Extension
), or tell DB4S to automatically load it every time (Preferences
→ Extensions
)..app
folders in file selection dialogs. To navigate to the correct folder you'll probably need to press Shift (⇧)+Command (⌘)+g when the file selection dialog is open, then give it the path of /Applications/DB Browser for SQLite.app/Contents/Extensions
.load_extension()
is only enabled when explicitly requested by the user in a new setting (#1558)Published by justinclift almost 6 years ago
This 3.11.0-beta3 release only has minor improvements over yesterdays 3.11.0-beta2.
math.dylib
) too (was already added for Windows in a prior beta).
Contents/Extensions/
folder inside DB Browser for SQLite.app
.Tools
→ Load Extension
), or tell DB4S to automatically load it every time (Preferences
→ Extensions
)..app
folders in file selection dialogs. To navigate to the correct folder you'll probably need to press Shift (⇧)+Command (⌘)+g when the file selection dialog is open, then give it the path of /Applications/DB Browser for SQLite.app/Contents/Extensions
.We've moved to providing MSI based installers, instead of the previous .exe ones. These new installers include both SQLite and SQLCipher (for optional encryption):
Additionally, there's now a .zip version of each. That's useful for people needing to run DB Browser for SQLite without installing it first.
If you're not sure which one to get, try the .msi version first. :)
Published by justinclift almost 6 years ago
This beta2 release has several improvements over the previous pre-releases for the 3.11.0 series.
We've moved to providing MSI based installers, instead of the previous .exe ones. These new installers include both SQLite and SQLCipher (for optional encryption):
Additionally, there's now a .zip version of each. That's useful for people needing to run DB Browser for SQLite without installing it first.
If you're not sure which one to get, try the .msi version first. :)
Published by justinclift almost 6 years ago
This beta1 release has several improvements over the previous (alpha1) release for the 3.11.0 series.
Published by MKleusberg about 6 years ago
Published by justinclift about 7 years ago
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. 😄
Published by MKleusberg about 7 years ago
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! 😉
-v/--version
command line switch to display the version number - #1065 (thanks to @FriedrichFroebel)Change Log
for the detailed version of the changes listed here and to the Commit Log
for the full list of changes.Published by justinclift about 7 years ago
Please report any/all bugs you find. 😄
Published by justinclift about 7 years ago
& many, many other enhancements + bug fixes
Please report any/all bugs you find. 😄
Published by revolter about 8 years ago
*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 🙈.
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".
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)
Published by revolter about 8 years ago
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. 😄
.dmg
on Mac OS - #693 (thanks to @justinclift and @revolter)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.
Published by revolter about 8 years ago
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. :)
The first beta for our 3.9.0 release series!
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).
Published by MKleusberg almost 9 years ago
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!