(Please consider sponsoring us on Patreon 😄)
Windows
Our latest release (3.13.1) for Windows:
- DB Browser for SQLite — Standard installer for 32-bit Windows
- DB Browser for SQLite — .zip (no installer) for 32-bit Windows
- DB Browser for SQLite — Standard installer for 64-bit Windows
- DB Browser for SQLite — .zip (no installer) for 64-bit Windows
Free code signing provided by SignPath.io, certificate by SignPath Foundation.
Windows PortableApp
Our latest release (3.13.1) for Windows:
- DB Browser for SQLite — PortableApp
Note — If for any reason the standard Windows release does not work
(e.g. gives an error), try a nightly build (below).
Nightly builds often fix bugs reported after the last release. 😄
macOS
Our latest release (3.13.1) for macOS:
- DB Browser for SQLite (Universal)
Homebrew
If you prefer using Homebrew for macOS, our latest release can be installed via:
brew install db-browser-for-sqlite
Nightly builds
Download nightly builds for Windows, macOS, and Linux are here:
- https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/nightly
Linux
Our latest release is available as an AppImage, Snap packages, and distribution specific packages:
AppImage
- DB.Browser.for.SQLite-v3.13.1-x86.64-v2.AppImage
Remember to change its permission bits to be executable before you run it. 😄
Snap packages
Snap Release build
snap install sqlitebrowser
Snap Nightly builds
snap install sqlitebrowser --devmode
Other distribution specific instructions:
Arch Linux
Arch Linux provides an up to date version
Install with the following command:
sudo pacman -S sqlitebrowser
Fedora
Install for Fedora (i386 and x86_64) by issuing the following command:
sudo dnf install sqlitebrowser
openSUSE
sudo zypper install sqlitebrowser
Debian
Note that Debian focuses more on stability rather than newest features. Therefore packages will typically contain some older version, compared to the latest release.
Update the cache using:
sudo apt-get update
Install the package using:
sudo apt-get install sqlitebrowser
Ubuntu and Derivatives
Stable release
For Ubuntu and derivatives, @deepsidhu1313
provides a PPA with the latest release here:
- https://launchpad.net/~linuxgndu/+archive/ubuntu/sqlitebrowser
To add this ppa just type in these commands in terminal:
sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser
Then update the cache using:
sudo apt-get update
Install the package using:
sudo apt-get install sqlitebrowser
Ubuntu 14.04.X, 15.04.X, 15.10.X and 16.04.X are supported for now (until
Launchpad decides to discontinue building for any series).
Ubuntu Precise (12.04) and Utopic (14.10) are not supported:
- Precise does not have a new enough Qt package in its repository by default,
which is a dependency - Launchpad does not support Utopic any more, which has reached its End of
Life
Nightly builds
Nightly builds are available here:
- https://launchpad.net/~linuxgndu/+archive/ubuntu/sqlitebrowser-testing
To add this ppa, type these commands into the terminal:
sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser-testing
Then update the cache using:
sudo apt-get update
Install the package using:
sudo apt-get install sqlitebrowser
Other Linux
On others, compile DB4S using the instructions
in BUILDING.md.
FreeBSD
DB Browser for SQLite works well on FreeBSD, and there is a port for it (thanks
to lbartoletti 😄). DB4S can be installed
using either this command:
make -C /usr/ports/databases/sqlitebrowser install
or this command:
pkg install sqlitebrowser
nightly
build(deps): bump awalsh128/cache-apt-pkgs-action from 1.4.3 to 1.5.0…
continuous
build(deps): bump awalsh128/cache-apt-pkgs-action from 1.4.3 to 1.5.0…
DB Browser for SQLite v3.13.1
This is a new release with several improvements over the v3.13.0 release from three months ago. 🚀
As a special mention, SQLean has a new time extension! Check out the following link for more information: https://github.com/nalgeon/sqlean/blob/main/docs/time.md
Thanks to everyone for being part of our Community!
Related Discussion: https://github.com/sqlitebrowser/sqlitebrowser/discussions/3775
Changelog
Added
- Add links to the wiki as help for many dialogs (7af1256, b5abc86)
Changed
- Change the default to install a shortcut to the Start menu when installing on Windows (623bec6)
- Improve icon image for links in ‘Help’ menu (#3693, 027c6a8)
- Pragma names and values can now be translated (#3697, bf62f3a, ad00ad4)
- Remove trailing characters when copying a single cell (#3735, 20f481a)
- Update AppImage binary to use the latest SQLCipher library (#3744, 21ba2d0)
- When editing the DB cells, expanded queries with parameters are included in the SQL Log (ac3209f)
Fixed
-
ExtendedTableWidget
- Fix an issue that prevented autocomplete from working in some race conditions (#2567, #3706)
- Use Tab to close autocomplete popup and move to next item (3aff8c9)
- Troubleshoot ‘Copy as SQL’ action on a cell results in string being copied (#1952, 1ebe7bf)
-
Global
- Fix «Argument Missing» error in Korean translation (#3635, #3692, cd518de)
- Fix an issue that caused apps to crash on some older versions of macOS (#3691)
- Fix an issue when freezing after stopping a pragma (#3742, 15a9620)
- Fix an issue with outputting the wrong version on macOS
- Troubleshooting poor HiDPI support on Windows (#3684)
- Troubleshoot SQL queries containing VACUUM that run incorrectly (#3723, 51784aa)
-
MainWindow
- Fix an issue when selecting queries containing multi-byte strings (#3731, f89097c)
-
TableBrowser
- Fix a bug where the first row was not adjusted (#3767, ad690e7)
-
etc
- Fix misleading links to Qt license information (8361aa5)
- Replace ‘http’ with ‘https’ in the ‘AboutDialog’ and ‘MainWindow’ (9832a52)
- Translation
- German (#3749, 8e38bf0)
- Indonesian (#3756, 6100595)
- Japanese (#3755, e0f6aea)
- Korean (7bbfcf9)
- Simplified Chinese (#3761, 9eb0a5a)
- Spanish (ac33918)
Dependent library version information for each OS
| — | Qt | SQLCipher | SQLite | SQLean |
|---|---|---|---|---|
| AppImage | 5.12.8 | 4.6.1 | Not applicable | Not applicable |
| macOS | 5.15.13 | 4.6.1 | Not applicable | 0.27.1 |
| Windows | 5.15.2 | 4.6.1 | 3.46.1 | 0.27.1 |
SHA256SUMS
- DB.Browser.for.SQLite-v3.13.1-win32.msi
- e0b9f86d3da4d8d800e144295487e43de306c1bd27f14dccfe41e904736f25f7
- DB.Browser.for.SQLite-v3.13.1-win32.zip
- 917ad2fa8d36e3bfa3fc85b11a34a8c18d189fbc2289f5a0d3bf41de8a288edc
- DB.Browser.for.SQLite-v3.13.1-win64.msi
- d023d54b3a5db10c7e896089bb3dbe6e7f4bc4eaa9bbecb34ca414be5970f688
- DB.Browser.for.SQLite-v3.13.1-win64.zip
- 22375e275ec42d96de1d3b8e9ea4ed86d2a3505c4d0ffcbd1af67aa4003e5e4d
- DB.Browser.for.SQLite-v3.13.1-x86.64-v2.AppImage
- c2fd0c27c84777747527e1b28deccc824bc88eeb47f36a9575bf1ba0a5a38453
- DB.Browser.for.SQLite-v3.13.1.dmg
- a641cfbfcc2ce609f07de44a35134dab53485ecc18e6d9afa297b514d74bd75e
- SQLiteDatabaseBrowserPortable_3.13.1.paf.exe
- dee51170538a2e5bffdd281c96680e1856d0b7440f5042c1a127db3b5e193ccb
[TEMPORARY] DB Browser for SQLite with SQLite 3.48.0
Warning
This build is a temporary release.
Note
Please note that the SQLite version is displayed as 3.48.0,
but it differs from the actual 3.48.0 version that will be released in the future.
A bug has been identified in the latest stable version of SQLite (3.47.0) that prevents proper use of database files with UTF-L(B)E encoding. This issue has been resolved in the latest master branch of SQLite, which has not yet been officially released. Therefore, we are distributing this temporary version for users to use until the new stable version of SQLite that includes this fix is released.
For more details, please refer to https://sqlite.org/src/info/af7173a10ec6, issue #3714, and the comments on PR #3792.
If you have additional feedback or questions, please open an issue or a discussion. Contact: @lucydodo
SHA256SUM
334910f5d0821921a89b1fc7f15daf2cddec85d23c219db75fc9657b1992ab71 DB.Browser.for.SQLCipher-dev-656651a-x86.64.AppImage
cf56b0efceb74a77bd0882bbf48bce1b221339b6a11ff8e539ce0459a36e3277 DB.Browser.for.SQLCipher-dev-656651a.dmg
3d7b8ee50212439010362ec47baa7cda0413b61b592a2f0781c8dcffc3c25688 DB.Browser.for.SQLite-dev-656651a-win32.msi
998a576db6e23e4db5e2dc4f94079abb469f9aea64fa67c1da56dd6499c2d67b DB.Browser.for.SQLite-dev-656651a-win32.zip
d51d85f2202942910f54e564f1038b96bce7e612b6ae423ccf5b71bd34f5cd24 DB.Browser.for.SQLite-dev-656651a-win64.msi
2dd3d867e16149e56d02328d85869dd883f743a4a21cc74cdbf5e8aa803d3878 DB.Browser.for.SQLite-dev-656651a-win64.zip
ed3e2bdce4b78be48669589cb54e9a780a530f00814e9e6fed7215ea29961f8e DB.Browser.for.SQLite-dev-656651a-x86.64.AppImage
173d7bacf0156f7ad8f9e3217ada08a318ebb80339b3a0cb693e7b83063e4fd5 DB.Browser.for.SQLite-dev-656651a.dmg
DB Browser for SQLite v3.13.1 RC2
We’re accepting translation contributions. If you’re interested, please check out the following issue: #3747
Added
- Add links to the wiki as help for many dialogs (7af1256, b5abc86)
Changed
- Improve icon image for links in ‘Help’ menu (#3693, 027c6a8)
- Pragma names and values can now be translated (#3697, bf62f3a, ad00ad4)
- Remove trailing characters when copying a single cell (#3735, 20f481a)
- Update AppImage binary to use the latest SQLCipher library (#3744, 21ba2d0)
- When editing the DB cells, expanded queries with parameters are included in the SQL Log (ac3209f)
Fixed
ExtendedTableWidget
- Troubleshoot ‘Copy as SQL’ action on a cell results in string being copied (#1952, 1ebe7bf)
Global
- Fix «Argument Missing» error in Korean translation (#3635, #3692, cd518de)
- Fix a bug that prevented autocomplete from working in some race conditions (#2567, #3706)
- Fix an issue that caused apps to crash on some older versions of macOS (#3691)
- Fix an issue with outputting the wrong version on macOS
- Fix an issue when selecting queries containing multi-byte strings (#3731, f89097c)
- Troubleshooting poor HiDPI support on Windows (#3684)
etc.
- Fix misleading links to Qt license information (8361aa5)
- Replace ‘http’ with ‘https’ in the ‘AboutDialog’ and ‘MainWindow’ (9832a52)
The highlighted changes refer to modifications made since RC1.
DB Browser for SQLite v3.13.1 RC1
Added
- Add links to the wiki as help for many dialogs (7af1256, b5abc86)
Changed
- Pragma names and values can now be translated (#3697, bf62f3a, ad00ad4)
- When editing the DB cells, expanded queries with parameters are included in the SQL Log (ac3209f)
Fixed
ExtendedTableWidget
- Troubleshoot ‘Copy as SQL’ action on a cell results in string being copied (#1952, 1ebe7bf)
Global
- Fix «Argument Missing» error in Korean translation (#3635, #3692, cd518de)
- Fix a bug that prevented autocomplete from working in some race conditions (#2567, #3706)
- Fix an issue that caused apps to crash on some older versions of macOS (#3691)
- Fix an issue with outputting the wrong version on macOS
- Troubleshooting poor HiDPI support on Windows (#3684)
etc.
- Fix misleading links to Qt license information (8361aa5)
- Replace ‘http’ with ‘https’ in the ‘AboutDialog’ and ‘MainWindow’ (9832a52)
DB Browser for SQLite 3.13.0
Related Discussion: https://github.com/sqlitebrowser/sqlitebrowser/discussions/3689
Caution
An issue has been reported where the app fails to launch on macOS Catalina (10.15.x).
We will be tracking and resolving the issue. For more information, see issue #3691
We are very excited to release a new stable version after almost three years. 🚀
It’s been a while since we’ve released a new stable version, so there are a lot of changes, see the release notes below for more details.
Table of Contents
- Table of Contents
- Highlights on user-visible changes
- SQLite update and improved support
- New Built-in Extension: sqlean (#3517, 0561d3f, be10d1a)
- Docked Data Browsers (1e1e87e, c96c393, 28ae7417, c40fb07b, c33b8be8)
- Other improvements in Data Browser
- Database Cell Editor
- Better support for HiDPI and new scalable icons #2485
- Dark and light style
- Import and export
- File menu
- Display formats
- New and improved keyboard shortcuts
- Clipboard
- Improvements in project files
- Undo operation #3428
- Edit Table dialog
- Execute SQL
- Plot
- Preferences
- Console messages
- Translations #3452
- And many other minor improvements and bug fixes
- Merged pull requests
- New Contributors
- SHA256SUM
- Highlights on user-visible changes
Highlights on user-visible changes
SQLite update and improved support
- SQLite version updated to 3.46.0 in Windows binary distributions.
- SQLCipher updated to versions:
- macOS and Windows: version 4.6.0 (based on SQLite 3.45.3)
- Linux AppImage: version 3.4.1 (based on SQLite 3.15.2)
- Support for the
STRICTtables (da28fdc, 42b7a37) - Support for the
RETURNING(6f6113c, #2854) - Support for the new math functions (4e79093, #2631)
- Support for IS (NOT) DISTINCT FROM expressions (5c57622)
- Attach database by URI (9356d00)
New Built-in Extension: sqlean (#3517, 0561d3f, be10d1a)
sqlean: All the Missing SQLite Functions
This new built-in extension bring together several commonly known SQLite extensions neatly packaged into one domain module.
Check out their repository for further information: https://www.github.com/nalgeon/sqlean
Also, this inclusion of this awesome extension was made possible by the generosity of the original author, @nalgeon
We’d like to take this opportunity to thank him.
Docked Data Browsers (1e1e87e, c96c393, 28ae741, c40fb07, c33b8be)
Press the new button at the left of the toolbar in the «Browse Data» to get a new tab where you can browse a second table.
By default, the tab title follows the table name, but it can also be renamed to set a permanent name, using the contextual menu of the tab title.
You can drag this new tab by the title bar, or use the buttons at the right to detach this dock and make it an independent window.
Or you can drag the docked window inside the original Data Browser to drop it using different layouts.
This will allow you to compare two tables or different sections of the same tables side by side.
Moreover, when opening a related record by pressing Ctrl+Shift+Click on a foreign key cell, the other table will be opened now in a new tab.
Specifying multiple tables using the -t/—table parameter on the command line now opens all of them in different tabs. (ab682a3)
Other improvements in Data Browser
The table shows a visual hint for keys in its column header: primary keys are underscored, foreign keys are in italics (b6c5024).
Sort order indicators have been swapped to be in line with the majority of applications (03ce140).
Columns can be frozen when scrolling horizontally (a15f81b)
Database Cell Editor
A new «Evaluation» mode can be selected in the Database Cell Editor (9a70af7)
Any input in this mode will be interpreted as an SQLite expression,
and the result of the evaluation will be inserted in the corresponding cell when pressing «Apply».
Note another minor improvement in the Cell Editor: it now shows the current row and column number being edited.
A new prompt is shown for saving any modified data when abandoning the cell editor (8f5c17e)
The image mode now has zoom controls and can be adjusted with the mouse wheel (d3c69ad, d62ccb1, 8bc9d33, f749f38, 23a597b)
Better support for HiDPI and new scalable icons #2485
DB Browser for SQLite has now better display in High DPI monitors, including the use of scalable icons from the Paste SVG icon set by Michael Burckley under a Creative Commons Attribution Share Alike 4.0 license. This will allow better display in High DPI monitors.
Dark and light style
The dark style has been updated and a new light style has been added (2a830e5)
Import and export
CSV data can be imported now from the clipboard. (9d87b96)
CSV files can also be imported from the command line, passing necessary arguments to drive the correct import. If just a CSV file is passed as single argument in the command line, the data is imported into an in-memory database. This can work as a quick glance of CSV data, alternative to what you can do with inferior data management tools, a.k.a. your favorite spreadsheet 😄 (cfa4dee, 09aaacc, f75a358, 36c5b1b, 6bdacf6).
There’s a new option to use system locale conventions for interpreting numbers in the CSV file (f9314b6).
Data in Browser and Execute SQL can now be exported as JSON (a5cc259, e225dc1)
File menu
Added new «Save Database As…» action for saving in-memory databases and saving database files to another
file name. (c8cd858)
Recent Files are now accessible in a new menu, can be cleared (ec6ff6a), and the maximum number of entries can be changed in Preferences (#2373)
Display formats
- New display formats: binary GUID to text (e51aa2e); SpatiaLite to SVG (#2767)
- Columns where a display format is in place have a different background and foreground, which can be customized in preferences (9a3ebd1)
New and improved keyboard shortcuts
| Shortcut | Action | Related |
|————————————|————————————————————————————————|—…
Read more
DB Browser for SQLite 3.12.2
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:
- Fix saving the list of extensions in the Preferences dialog (bd0e1feead6bb446f8a703338aa9893bf281e5b4)
- Corrected a typo in the French translation (3bbd4ee271f98301476143749f7bf4abed052efe)
- Updated the included SQLite and SQLCipher libraries to their latest release (SQLite 3.35.5, SQLCipher 4.4.3)
- Updated the «public» certificate, used for communicating with DBHub.io anonymously (d85953c291b5f0bb467e2c12dfa4438f997d4f28)
SHA256SUMS
- DB.Browser.for.SQLite-3.12.2-win32.msi
- 2b87a0ca1b14f436f2dc2cbfaa380249e754c3c87c81b6648a513f75d3c73368
- DB.Browser.for.SQLite-3.12.2-win32.zip
- 9344bcd50865663674f11c1d8297c0d2b4a4f7ced0a459c9e71e89382549454f
- DB.Browser.for.SQLite-3.12.2-win64.msi
- 723d601f125b0d2402d9ea191e4b310345ec52f76b61e117bf49004a2ff9b8ae
- DB.Browser.for.SQLite-3.12.2-win64.zip
- 559edc274a2823264e886159eaa36332fd5af1f2f4b86ba2a5ef485b6420ab54
- DB.Browser.for.SQLite-3.12.2.dmg
- 546d57b6c88c2be7517759c016c0bf0313dfcc14adfcb43967f3c5d24657f366
- DB.Browser.for.SQLite-arm64-3.12.2.dmg
- 0c2076e4479cb9db5c85123cfe9750641f92566694ff9f6c99906321a2c424e8
- SQLiteDatabaseBrowserPortable_3.12.2_English.paf.exe
- a597b791949c260e31908d00bde474cbb4b16d55120be92ee6e0d7c08be56809
- DB_Browser_for_SQLite-v3.12.2-x86_64.AppImage
- ea14c7439f7e666f3e9d8cbffe9048134b87db3e2d7bf65f4146b0649536de5c
DB Browser for SQLite 3.12.1
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:
Enhancements
- Completely reworked interface for accessing DBHub.io
- Add .Net DateTime.Ticks to list of supported display formats (#2378)
- Add more options for setting font sizes (#2306)
- New predefined settings for simplified window layout (#2307)
Bug fixes
- Fix loading of project files with empty filter values (#2288)
- Fix initial table view when using the -t / —table command line option (#2113)
- Add status message when opening a file from the recent file list (4dfe4f7)
- Make sure to not show «NULL» for empty but non-NULL values in the Edit dialog (#2204)
- Fix plot being drawn before all data is loaded (#2286)
- Restore original default for having condition format in filter line (f28ecc0)
- Fix default font in the format toolbar (c4b2ffc)
- Improve binary detection for cases starting by chance by a BOM (#2197)
- Make sure the order of the statements in the SQL log is correct (05db901)
- Fix executing selected SQL text when there are multi-byte characters (#2311)
- Fix executing SQL queries with compound operators (#2316)
- Fix SQL import of files with BOM (#2323)
- Also update schema when clicking the Refresh button in Browse Data tab (16c3d8d)
- Select column in table results when column header is pressed (#2343)
- Tweak the output wording for command line options (#1069)
- Remove the default property of the cancel button in the «Fetching data…» dialog (#2383)
- Fix not being saved and not applied when modifying database cells in Windows external program (f2d8f79)
- Fix incorrect display of SQL calltips containing non-US-ASCII characters (9f7851b)
- Fix to ‘Window Layout’ options work properly (#2435)
Building and packaging
- Fix CMake warning during compilation (115aa00)
- snap: Add environment variables to set Qt theme (7b5d652)
- Updated to OpenSSL 1.1.1h for the Windows and macOS builds
Platform specific
- No longer force Light theme on macOS when «Follow the desktop style» is chosen (508118f)
- Keep registry key consistent on Windows (#2328)
- Allow use of integrated graphics card instead of high performance graphics card in macOS (#2377)
- Use native path separators in Preferences dialog (f38b829)
- Added message box for informative command line arguments for Windows (#1069)
Translations
- Remove all translations of key shortcuts (0070a15)
- Update of the Korean translation (#2329, 82accb2)
- Update of the Spanish translation (551a420)
- Update of the Japanese translation (#2407)
- Update of the French translation (2803da3)
- Update of the Arabic translation (1dfa70c)
- Fixes in the Spanish translation (4791b99, 5d85ca1, 454fd4a)
- Fixes in the French translation (90d33c6, 0375206)
- Update of the German translation (#2415)
- Update of the Italian translation (#2419)
- Update of the Portuguese translation (#2418)
- Update of the Chinese translation (#2421)
- Add of the Dutch translation (#2424)
SHA256SUMS
- DB.Browser.for.SQLite-3.12.1-win32-v2.msi
- 6fb72e41cf867e34d1fffdd5b544dc317fbbd25e3c4e56986d62de0c0e46da06
- DB.Browser.for.SQLite-3.12.1-win32.zip
- c12223a20c4b6e08d086e0d1f54ab0cba9b11b83698ed94f0bdf7728ac67e2f3
- DB.Browser.for.SQLite-3.12.1-win64-v2.msi
- 512f68ff998564b6a297ee0910563bd97808ce292bf09a840f097faea9be577e
- DB.Browser.for.SQLite-3.12.1-win64.zip
- 3dd4ccb07f5aabe86b8b12a2544169f9dc15c371f1655ce4072da5a0bd2d2ae3
- DB.Browser.for.SQLite-3.12.1-v2.dmg
- 45c8789dc77461299a0aeb9eaae2d089086e76eebae31b45b7a0ee48c1c9e898
- SQLiteDatabaseBrowserPortable_3.12.1_English.paf.exe
- 7a0d4bebbafc1d781fb615ba9d699ede07cf6444a8444c56f58a9cd318baf6ca
DB Browser for SQLite 3.12.1 Release Candidate 1
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:
Enhancements
- Completely reworked interface for accessing DBHub.io
- Add .Net DateTime.Ticks to list of supported display formats (#2378)
- Add more options for setting font sizes (#2306)
- New predefined settings for simplified window layout (#2307)
Bug fixes
- Fix loading of project files with empty filter values (#2288)
- Fix initial table view when using the -t / —table command line option (#2113)
- Add status message when opening a file from the recent file list (4dfe4f7)
- Make sure to not show «NULL» for empty but non-NULL values in the Edit dialog (#2204)
- Fix plot being drawn before all data is loaded (#2286)
- Restore original default for having condition format in filter line (f28ecc0)
- Fix default font in the format toolbar (c4b2ffc)
- Improve binary detection for cases starting by chance by a BOM (#2197)
- Make sure the order of the statements in the SQL log is correct (05db901)
- Fix executing selected SQL text when there are multi-byte characters (#2311)
- Fix executing SQL queries with compound operators (#2316)
- Fix SQL import of files with BOM (#2323)
- Also update schema when clicking the Refresh button in Browse Data tab (16c3d8d)
- Select column in table results when column header is pressed (#2343)
- Tweak the output wording for command line options (#1069)
- Remove the default property of the cancel button in the «Fetching data…» dialog (#2383)
Building and packaging
- Fix CMake warning during compilation (115aa00)
- snap: Add environment variables to set Qt theme (7b5d652)
Platform specific
- No longer force Light theme on macOS when «Follow the desktop style» is chosen (508118f)
- Keep registry key consistent on Windows (#2328)
- Allow use of integrated graphics card instead of high performance graphics card in macOS (#2377)
- Use native path separators in Preferences dialog (f38b829)
- Added message box for informative command line arguments for Windows (#1069)
Translations
- Remove all translations of key shortcuts (0070a15)
- Update of the Korean translation (#2329, 82accb2)
- Update of the Spanish translation (551a420)
- Update of the Japanese translation (#2407)
- Update of the French translation (2803da3)
- Update of the Arabic translation (1dfa70c)
- Fixes in the Spanish translation (4791b99, 5d85ca1, 454fd4a)
- Fixes in the French translation (90d33c6, 0375206)
SHA256SUMS
- DB.Browser.for.SQLite-3.12.1-rc1-win32.msi
- 403cb37170550ff761ed5a7d24bbf75461d8a7b3e841d3265b858f23fe6142f6
- DB.Browser.for.SQLite-3.12.1-rc1-win32.zip
- c2cfa37a4a3a081fdacd6dcf704240b3019949e4bd8b3f3a5d302f4effdfe03c
- DB.Browser.for.SQLite-3.12.1-rc1-win64.msi
- 463f0f710fa491ad49efcf00f138e4c3fe1764be8a6dd39c424f6fc242447337
- DB.Browser.for.SQLite-3.12.1-rc1-win64.zip
- 884b69d7e463dc416d1d57e804dfbdad6c434c4c3697ee1f66b5f093e6267b43
- DB.Browser.for.SQLite-3.12.1-rc1.dmg
- 74462728b6fd9a79a0f097f4e07d30182f9b09e1ed35ab07db448314fbc95e38
News
2017-09-28 — Added PortableApp version of 3.10.1. Thanks John. 
2017-09-20 — DB Browser for SQLite 3.10.1 has been released! 
2017-09-08 — Removed the continuous AppImage builds for Linux due to problems with the upload script.
Screenshot
What it is
DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.
It is for users and developers wanting to create databases, search, and edit data. It uses a familiar spreadsheet-like interface, and you don’t need to learn complicated SQL commands.
Controls and wizards are available for users to:
- Create and compact database files
- Create, define, modify and delete tables
- Create, define and delete indexes
- Browse, edit, add and delete records
- Search records
- Import and export records as text
- Import and export tables from/to CSV files
- Import and export databases from/to SQL dump files
- Issue SQL queries and inspect the results
- Examine a log of all SQL commands issued by the application
What it is not
This program is not a visual shell for the sqlite command line tool. It does not require familiarity with SQL commands. It is a tool to be used both by developers and by end users, and it must remain as simple to use as possible in order to achieve its goals.
Nightly builds
Nightly builds for Windows and OSX can be downloaded here:
- https://nightlies.sqlitebrowser.org/latest
Windows
Windows releases can be downloaded here:
- https://github.com/sqlitebrowser/sqlitebrowser/releases
Note — If for some reason the standard Windows release doesn’t work
for you (eg it gives an error), try a nightly build. They often fix bugs
reported after the last release.
MacOS X / macOS
DB Browser for SQLite works well on MacOS X / macOS.
- OSX 10.8 (Mountain Lion) — 10.13 (High Sierra) are tested and known to work
OSX releases can be downloaded here:
- https://github.com/sqlitebrowser/sqlitebrowser/releases
Or installed via Homebrew Cask:
brew cask install db-browser-for-sqlite
Linux
DB Browser for SQLite works well on Linux.
Arch Linux
Arch Linux provides a package through pacman.
Fedora
For Fedora (i386 and x86_64) you can install by issuing:
$ sudo dnf install sqlitebrowser
Debian
Note that Debian focuses more on stability rather than newest features. Therefore packages will typically contain some older (but well tested) version, compared to the latest release.
Update the cache using:
sudo apt-get update
Install the package using:
sudo apt-get install sqlitebrowser
Ubuntu and Derivatives
Stable release
For Ubuntu and derivaties, @deepsidhu1313
provides a PPA with our latest release here:
- https://launchpad.net/~linuxgndu/+archive/ubuntu/sqlitebrowser
To add this ppa just type in these commands in terminal:
sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser
Then update the cache using:
sudo apt-get update
Install the package using:
sudo apt-get install sqlitebrowser
Ubuntu 14.04.X, 15.04.X, 15.10.X and 16.04.X are supported for now (until
Launchpad decides to discontinue building for any series).
Ubuntu Precise (12.04) and Utopic (14.10) are not supported:
- Precise doesn’t have a new enough Qt package in its repository by default,
which is a dependency - Launchpad doesn’t support Utopic any more, as that has reached its End of
Life
Nightly builds
Nightly builds are available here:
- https://launchpad.net/~linuxgndu/+archive/ubuntu/sqlitebrowser-testing
To add this ppa just type in these commands in terminal:
sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser-testing
Then update the cache using:
sudo apt-get update
Install the package using:
sudo apt-get install sqlitebrowser
Other Linux
On others you’ll need to compile it yourself using the (simple) instructions
in BUILDING.md.
FreeBSD
DB Browser for SQLite works well on FreeBSD, and there is a port for it (thanks to lbartoletti).
It can be installed using either this:
# make -C /usr/ports/databases/sqlitebrowser install
or this:
# pkg install sqlitebrowser
Developer mailing list
For development related discussion about DB4S and DBHub.io:
- https://lists.sqlitebrowser.org/mailman/listinfo/db4s-dev
Follow us on Twitter: https://twitter.com/sqlitebrowser
Website
- http://sqlitebrowser.org
Old project pages
- http://sqlitebrowser.sourceforge.net
- https://sourceforge.net/projects/sqlitebrowser
Releases
- Version 3.10.1 released — 2017-09-20
- Version 3.10.0 released — 2017-08-20
- Version 3.9.1 released — 2016-10-03
- Version 3.9.0 released — 2016-08-24
- Version 3.8.0 released — 2015-12-25
- Version 3.7.0 released — 2015-06-14
- Version 3.6.0 released — 2015-04-27
- Version 3.5.1 released — 2015-02-08
- Version 3.5.0 released — 2015-01-31
- Version 3.4.0 released — 2014-10-29
- Version 3.3.1 released — 2014-08-31 — Project renamed from «SQLite Database Browser»
- Version 3.3.0 released — 2014-08-24
- Version 3.2.0 released — 2014-07-06
- Version 3.1.0 released — 2014-05-17
- Version 3.0.3 released — 2014-04-28
- Version 3.0.2 released — 2014-02-12
- Version 3.0.1 released — 2013-12-02
- Version 3.0 released — 2013-09-15
- Version 3.0rc1 released — 2013-09-09 — Project now on GitHub
- Version 2.0b1 released — 2009-12-10 — Based on Qt4.6
- Version 1.2 released — 2005-04-05
- Version 1.1 released — 2004-07-20
- Version 1.01 released — 2003-10-02
- Version 1.0 released to public domain — 2003-08-19
History
This program was developed originally by Mauricio Piacentini (@piacentini) from Tabuleiro Producoes, as the Arca Database Browser. The original version was used as a free companion tool to the Arca Database Xtra, a commercial product that embeds SQLite databases with some additional extensions to handle compressed and binary data.
The original code was trimmed and adjusted to be compatible with standard SQLite 2.x databases. The resulting program was renamed SQLite Database Browser, and released into the Public Domain by Mauricio. Icons were contributed by Raquel Ravanini, also from Tabuleiro. Jens Miltner (@jmiltner) contributed the code to support SQLite 3.x databases for the 1.2 release.
Pete Morgan (@daffodil) created an initial project on GitHub with the code in 2012, where several contributors fixed and improved pieces over the years. René Peinthor (@rp-) and Martin Kleusberg (@MKleusberg) then became involved, and have been the main driving force from that point. Justin Clift (@justinclift) helps out with testing on OSX, and started the new github.com/sqlitebrowser organisation on GitHub.
John T. Haller, of PortableApps.com fame, created the new logo. He based it on the Tango icon set (public domain).
In August 2014, the project was renamed to «Database Browser for SQLite» at the request of Richard Hipp (creator of SQLite), as the previous name was creating unintended support issues.
In September 2014, the project was renamed to «DB Browser for SQLite», to avoid confusion with an existing application called «Database Browser».
License
DB Browser for SQLite is bi-licensed under the Mozilla Public License
Version 2, as well as the GNU General Public License Version 3 or later.
You can modify or redistribute it under the conditions of these
licenses.
СКАЧАТЬ
Описание
Отзывы
Выберите вариант загрузки:
- скачать с сервера SoftPortal (для Windows 32-bit, msi-инсталлятор)
- скачать с сервера SoftPortal (для Windows 64-bit, msi-инсталлятор)
- скачать с официального сайта (для Windows 64-bit, msi-инсталлятор)
- скачать с официального сайта (для Windows 32-bit, msi-инсталлятор)
DB Browser for SQLite — это интуитивно понятный и мощный инструмент для работы с базами данных SQLite. Создавайте, редактируйте и анализируйте свои данные с легкостью благодаря этому удобному приложению. Поддерживается на различных операционных системах (полное описание…)
Рекомендуем популярное
DB Browser 3.12.2
DB Browser for SQLite — это интуитивно понятный и мощный инструмент для работы с базами данных SQLite….
DBeaver 24.2.4
Универсальное приложение для управления базами данных, позволяющее анализировать,…
DB Navigator for DBF 2.0.0.21
DBNavigator for DBF — это утилита для работы с файлами баз данных. Используя этот продукт, вы можете…
dbForge Studio для MySQL 9.2.128
dbForge Studio для MySQL — бесплатный, профессиональный инструмент для разработчиков БД и…
HeidiSQL 9.5.0.5196
HeidiSQL — мощный инструмент для управления базами данных MySQL и Microsoft SQL…
Database .NET 35.5.8689
Database .NET — бесплатный портативный инструмент для управления различными СУБД, с поддержкой…
Turso lets you build and work locally with a SQLite file, and then push it globally to the edge when ready.
SQLite has been around for decades, and it’s a popular choice for developers who need a lightweight, serverless database that can be embedded inside their applications. Since SQLite has been around for a long time, it also means there are plenty of GUIs available to pick from.
In this article, we’ll take a look at the best free SQLite GUIs that you can use to create, edit, and manage your SQLite databases.
#DB Browser for SQLite
The most popular and well-known GUI is most certainly DB Browser for SQLite.
It is a free, visual, open-source tool that allows you to create, design, and edit SQLite databases. It also works on Windows, macOS, and Linux.
#Beekeeper Studio
Beekeeper Studio is a free, open-source SQL editor and database manager that supports SQLite.
You can use Beekeeper Studio to connect to your SQLite database, run queries with auto-complete, pin frequently used queries, and even save your results to a CSV or JSON files.
#DBeaver
DBeaver is popular cross-platform database tool for developers and database administrators. It’s free, open-source, works on Windows, macOS, Linux, and support SQLite.
#Sqlime
Sqlime is an online SQLite playground that runs in the browser. You can use Sqlime to connect to local or remote SQLite databases.
You can even generate links to share your database with others, or ask AI to help you write SQL queries.
#SQLite Viewer
If you’re looking for something that runs in the browser, and has a familiar UI feeling, then SQLite Viewer is a great choice. It’s a free, open-source, and cross-platform SQLite database browser that runs in the browser.
SQLite Viewer also boasts a number of features that make it easy to find what you’re looking for with full text search, and the ability to filter and sort your data.
#Deploy your SQLite database with Turso
First create an account, and install the Turso CLI.
Now using the database file you created with one of the top 5 free SQLite GUIs, you can push it to the edge with Turso:
turso db create [database-name] --from-file ./path/to/file.db
The CLI will upload the SQLite file, and create a database with the name you provided. If you want to replicate the database to multiple edge locations, you can add additional locations to your group of databases using the CLI — learn more.