(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
Beekeeper Studio Is A Modern, Easy To Use SQLite GUI Client
Beekeeper Studio is a modern and friendly SQLite GUI client.
Our users tell us that Beekeeper Studio is the most intuitive, and easy to use SQLite GUI client available.
Tried a few tools. Beekeeper was the only one that I found that felt right. Most had a very 1990’s feel to them — ⭐⭐⭐⭐⭐ Allan
SQLite GUI Client Features
Beekeeper Studio is designed primarily to be an easy to use database GUI. We really sweat the details to make the app as intuitive as possible.
SQLite SQL Editor
Beekeeper Studio’s query editor is powerful, but easy to use. To start writing SQL, just pop open a new tab and begin typing – just like in your regular text editor. Learn more.
Download for free >
SQLite Spreadsheet View
Open any table in a spreadsheet that makes it quick and easy to navigate, filter, edit, and delete your table data. Also included: clickable foreign keys, data export, and syntax-highlighted editors. Learn more
Download for free >
SQLite Schema Editor
Right click any table to modify it’s schema. Easily change column names, types, defaults, and nullability. Plus add relations and indexes, all without writing any SQL. Learn more
Download for free >
SQLite Data Import & Export
Take any table, view, or query result and export it to CSV, Excel, or JSON in two clicks. Plus import your own CSVs into SQLite in two clicks. Learn more
Download for free >
Beekeeper’s Team Workspaces let you easily work across multiple machines and share connections and queries with your colleagues. All data is encrypted at rest and in transit, so your information always stays secure. Learn more.
Download for free >
Beekeeper Studio was clean, smooth and just worked — ⭐⭐⭐⭐⭐ Mike
Even More GUI Features For SQLite
-
Modern and easy to use SQLite GUI client — We sweat the details. There are no ‘tabs within tabs’, cryptic buttons, or
old-school Java swing interfaces. - Double click to open — Open any SQLite file by double clicking on the database file. It’ll open directly in Beekeeper Studio ready for you to browse and query.
- Runtime Extensions — Beekeeper Studio supports SQLite runtime extensions, so you can add whatever functionality you need to your SQLite database, directly from Beekeeper Studio.
- Command line integration — Open a file from the terminal, and it will open in Beekeeper Studio, eg `open mydb.sqlite` in MacOS, or `xdg-open mydb.sqlite` in Linux.
- Tabbed Interface — Open a bunch of queries and tables all alongside each other.
- Open Multiple SQLite Connections At Once — give each connection a color, and run them all at once if you wish.
- Save SQL Queries For Later — Our built in data store lets you save queries for when you need them.
- SQLite Table Creation and Editing — We have a built-in, easy to use GUI interface.
- Edit SQLite Data — Edit database records in SQLite in-line with only a couple of clicks.
- SQLite SQL Auto Completion — A useful autocomplete editor that doesn’t get in your way.
- Pinned Tables — Keep your most-used tables and views at the top of the sidebar for easy reference.
- SQLite Run History — Beekeeper Studio keeps track of the SQL queries you run, so you can find the magical code from last week that ‘just worked’.
- Not Just for SQLite — Beekeeper Studio supports MySQL, PostgreSQL, MariaDB, SQLite, CockroachDB, Redshift, and SQL Server.
- Community Strength — Many features were built by our amazing community of contributors.
DB Browser for SQLite
Beekeeper Studio is a SQLite GUI that allows you to easily browse your SQLite DB with an intuitive spreadsheet-like UI. Easily make changes to data by simply clicking the cell, editing the value, then clicking save.
Beekeeper Studio also provides advanced features such as magic foreign key links. If a table contains a foreign key, click the ↗ button next to the foreign key and Beekeeper will open that record in a new tab ready for you to view.
Double Click To Open Any SQLite File
Once you’ve installed Beekeeper Studio you can open any SQLite file by double clicking on the database file in your file browser. It’ll open directly in Beekeeper Studio ready for you to browse and query.
This makes it quick and easy to browse and edit any number of SQLite files.
Open from the command line
You can also use your terminal to open a database in Beekeeper Studio quickly and easily.
-
MacOS
open ./path/to/example.db -
Linux
xdg-open ./path/to/example.db
DB Browser for SQLite Demo
A Truly Cross-Platform SQLite GUI Client
Beekeeper Studio has 100% feature parity across Linux, MacOS, and Windows. So no matter which operating system you work (or play) from, you can query and edit SQLite with all of our features, no compromises.
We use a cross-platform app development framework to make sure that you get the best SQLite GUI client experience, regardless of whether you use MacOS, Windows, or Linux.
Beekeeper Studio also works great on Chromebooks, Raspberry Pi 3+, and maybe even the odd toaster or fridge (if they run Linux).
Beekeeper Studio was perfect when I began using all three major OSes regularly. —
⭐⭐⭐⭐⭐ Jeff
Windows
Beekeeper Studio is available for Windows, so you can easily query, edit, and manage your SQLite databases. Beekeeper Studio’s Windows download is available from our download page as either an installer or a portable .exe file. Beekeeper Studio supports Windows 10+, more information is available in our Windows documentation.
MacOS
Beekeeper Studio integrates seamlessly into the MacOS environment for querying, editing, and managing SQLite. Beekeeper Studio’s MacOS app is available the downloads page. Beekeeper Studio supports both Intel and Apple silicon Macs. More information is available on our MacOS documentation page.
Linux
Beekeeper Studio’s SQLite GUI has full feature parity on Linux. Linux is a first-class OS to the Beekeeper Studio team, and we think it’s the best way to edit, query, and manage your SQLite database. Beekeeper Studio works great on all major distributions, including Ubuntu, Fedora, and Arch. You can get Beekeeper Studio’s linux client on our download page. Learn more on our Linux docs.
All Purchases Support Open Source
Beekeeper Studio is built by me, Matthew Rathbone and a small team of part-time developers. We build software we care about. We’re not part of a big corporation, and we don’t have a large investor in the background writing checks. Unlike many of our well-funded competitors, we make a large part of Beekeeper Studio open source, and we also publish a generous Community Edition. We’re on a mission to make good software available to everyone. Every purchase supports open source, and our mission.
I hope you enjoy using Beekeeper Studio as much as I enjoy making it.
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
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.
СКАЧАТЬ
Описание
Отзывы
Выберите вариант загрузки:
- скачать с сервера SoftPortal (для Windows 32-bit, msi-инсталлятор)
- скачать с сервера SoftPortal (для Windows 64-bit, msi-инсталлятор)
- скачать с официального сайта (для Windows 64-bit, msi-инсталлятор)
- скачать с официального сайта (для Windows 32-bit, msi-инсталлятор)
DB Browser for SQLite — это интуитивно понятный и мощный инструмент для работы с базами данных SQLite. Создавайте, редактируйте и анализируйте свои данные с легкостью благодаря этому удобному приложению. Поддерживается на различных операционных системах (полное описание…)
Рекомендуем популярное
HeidiSQL 9.5.0.5196
HeidiSQL — мощный инструмент для управления базами данных MySQL и Microsoft SQL…
DB Browser 3.12.2
DB Browser for SQLite — это интуитивно понятный и мощный инструмент для работы с базами данных SQLite….
EMS MySQL Manager Pro 4.1.2.1
EMS MySQL Manager — мощное и эффективное средство для администрирования сервера MySQL и управления его объектами…
dbForge Studio для MySQL 9.2.128
dbForge Studio для MySQL — бесплатный, профессиональный инструмент для разработчиков БД и…
DBeaver 24.2.4
Универсальное приложение для управления базами данных, позволяющее анализировать,…
DataNumen MDF Viewer 1.0.0.0
Инструмент для просмотра и восстановления данных из MDF-файлов баз данных SQL Server….