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 hidden (Show)
Published by lucydodo 10 months ago
Related: #3357, #3541
[!CAUTION]
This release is a test build.
Published by lucydodo about 1 year ago
This is a testing version for implementing undo functionality for changes in the Data Browser. Please, report any issue in #3428.
9872fa6a50158e49a241cd647d10a7efbfa1fa147440762a4527e1e083a5d8e1 DB.Browser.for.SQLCipher-dev-002bc66.dmg
a16c85656da26401cd28589742d259b08341c0d402a4b997ffcf4b8368b1b54e DB.Browser.for.SQLite-dev-002bc66.dmg
d7d619e2df2b19d6219a40ef1e635299c48b9ef6b003ec8d3dcccc443b778408 DB_Browser_for_SQLCipher-dev-002bc66-x86_64.AppImage
Published by lucydodo over 1 year ago
Built with b5281129a95931b0f0697b5528aaadd8599f3f48
(Think of it as 37046611caa0abb337b14b30ce83cc9c752e22cb
)
DB Browser for SQLite Testing.dmg
d64cbe990e334fd4891940fe455d6fd4d728d47d720fea9d855d3e0655524b73
Published by chrisjlocke over 3 years ago
2022-10-23 update - We've added a native arm64 (eg M1/M2/etc) macOS download below, for people using Apple Silicon. It's the file named DB.Browser.for.SQLite-arm64-3.12.2.dmg
.
Original release text:
This is a minor maintenance release, primarily to update the internal certificates for
anonymous communication with the DBHub.io servers.
You don't need to upgrade unless you're using DBHub.io anonymously. If you're using DBHub.io
with your own client certificate, this upgrade won't really do much either. 😄
The changes in this over the 3.12.1 release include:
Published by deepsidhu1313 over 3 years ago
Travis CI build log: https://travis-ci.org/sqlitebrowser/sqlitebrowser/builds/769222434
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. 😄