DB Browser for SQLite -.zip (no installer) for 64-bit 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. Nightly builds often fix bugs reported after the last release. Our latest release (3.12.0) for macOS: DB Browser for SQLite. 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. The download version of DB Browser for SQLite for Mac is 3.12. The download was scanned for viruses by our system. We also recommend you check the files before installation. DB Browser for SQLite antivirus. Visit these links to examine major changes in all DbVisualizer versions ever released, specific details for each version, and information how to evaluate the DbVisualizer Pro edition.
The only surest and seamless way to handle SQLite databases on computers is by means of DB Browser for SQLite. Db Browser For SQLite is an open-source tool which is completely free to use.
Db Browser for SQLite creates databases which are compatible with SQLite. The “.db” database extension created by this software is completely compatible with SQLite. You should never change the .db extension, use it as it is for all your SQLite database manipulations.
This tutorial illustrates everything you need to know about Db Browser For SQLite. I will show you how to create databases, how to create tables, how to delete records (rows) in a table and everything else you need to know in order to get going.
You might have heard of browser extensions which claim to manage SQLite databases, but trust me, none of those can beat the DB Browser for SQLite.
I have personally worked with Db Browser for SQLite on a JavaFX mega project. The overall performance of this software is commendable. Being a free software Db Browser for SQLite deserve praises.
There so many advantages of using Db Browser for SQLite, I will, however, provide a list of the main advantages.
- Db Browser For SQLite is Completely Free
- It’s a very Light Weight Software, ready to be handled by all types of machines
- It can be used, by both Developers and End Users. You don’t need to be a developer to use Db Browser for SQLite, everything concerning SQLite Management is done fully by this software.
- Everything is Done on a Graphical User Interface. No SQL code required in tables or records manipulations.
- Imports/Exports your databases and tables from/to CSV file
- Import and export databases from/to SQL dump files
- Import and export records as text
It’s almost impossible to finish all its advantages.
Creating a new database on the Db Browser for SQLite involves nothing more complex than just clicking File > New Database. Provide a relevant name for your database and boom, you are done.
To connect to an SQLite database, just click File > Open Database. Connecting to a database with SQLite Database for SQLite is the same as opening an existing database.
As soon as you finish creating a new database, a popup window will show, prompting you to create a new table, you can, however, create a new table by clicking Create Table from the left corner on the Software as shown in the screenshot below
A new Popup window will show, prompting you to fill fields (columns) to your table. To create a new field on your table, just click Add Field as shown in the screenshot below.
You can add as many fields as you wish. When you add a new field, please select relevant datatype for your field. For example, field firstName should be a text. SQLite supports at least 5 types of data types:
- INTEGER
- TEXT
- BLOB
- REAL
- NUMERIC
Sqlite Browser Download For Windows
Click Ok to save your table.
The list of tables on your database can be viewed on the Database Structure section of Db Browser for SQLite as shown on the image below. To view fields on your table you can expand the table on the same section.
Rember to write changes every time you are done manipulating your database. To save or write changes, click on File > Writer Changes from the menu bar. Db SQLite does not save changes automatically.
From the screenshot above, we have two tables in our database, i.e. Admin and users. You can browse your tables and view records (rows) by click Browse Data. You’ll need to select the table you want to view its records.
You can select the table you want to view its records. On the other hand, you can add and delete records from a table. To add a new record (row) to your table, kindly click on Add Record button. To delete a certain record, kindly select the row you want to delete and click Delete Record button.
Every time you make changes to a table such as adding or deleting records or even modifying, you must click on File > Write Changes. Db Browser for SQLite does not save these data automatically, you will have to save them manually. This is important because it improves the software’s performance.
Sometimes you may make a mistake while naming your table or while adding fields to a table. Fortunately, Db Browser for SQLite provides an easier way to modify or drop your tables. Modifying your table lets you rename your table as well as renaming or adding new fields to already existing table.
To Modify or drop your table, right-click on your table on the database structure page, then select Modify Table or Delete Table as shown in the image below.
After everything is done, Write Changes to database from the File > Write Changes.
My name is Benson Karue, I was Software Engineer Telenet Co LTD before I quit and joined YouTube and Udemy as an instructor. I have real-world software experience and have a Bachelor’s degree in Mathematics and Computer Science with 6+ years of coding experience and winning several competitions and coding challenges.
I am familiar with C, C++, C#, Objective-C, Java, Swift, Android, iOS, Windows mobile, J2ME, Blackberry, HTML5, CSS3, JavaScript, Jquery, AJAX, Node.js, PHP, Ruby, Python, Scala, Groovy, PhoneGap JSP, JSF, EJB, Struts, Hibernate and Spring MVC, Flat Design along with databases such as MySQL, Oracle, SQLServer, SQLite and many other technologies and frameworks
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! :D
2017-09-08 - Removed the continuous AppImage builds for Linux due to problems with the upload script.
Screenshot
Db Browser For Windows
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
Install Db Browser For Sqlite
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:
Windows
Windows releases can be downloaded here:
Note - If for some reason the standard Windows release doesn't workfor you (eg it gives an error), try a nightly build. They often fix bugsreported after the last release. :D
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:
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:
Sqlite Browser Download For Windows 10
$ 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, @deepsidhu1313provides a PPA with our latest release here:
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 (untilLaunchpad 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:
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
Db Browser For Sqlite Windows
On others you'll need to compile it yourself using the (simple) instructionsin 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
Sqlitestudio Vs Sqlite Browser
or this:
# pkg install sqlitebrowser
Developer mailing list
For development related discussion about DB4S and DBHub.io:
Follow us on Twitter: https://twitter.com/sqlitebrowser
Website
Old project pages
Releases
Sqlite Browser Windows 10
- 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 LicenseVersion 2, as well as the GNU General Public License Version 3 or later.
You can modify or redistribute it under the conditions of theselicenses.