SQLite is a compact, cross platform, self-contained relational database management system that is available in the public domain. SQLite is included in macOS and Mac OS X by default. It is located in the /usr/bin directory and called sqlite3.
Using SQLite, users can create file-based databases that can be transported across machines, platforms, etc. The only thing needed to then view or edit these databases is the SQLite command line program, or another tool capable of communicating with SQLite.
SQLite databases can be created by using the sqlite3 program in /usr/bin. To get to this program, you can open up a terminal window (Applications -> Utilities -> Terminal) and then type the following followed by the enter / return key to change your directory to the /usr/bin location:
Download the latest version of DB Browser for SQLite for Mac for free. Read 1 user reviews and compare with similar apps on MacUpdate. DB Browser for SQLite – is an open-source tool to manage database files compatible with SQLite. In this tutorial, you have learned how to download and install SQLite. Download DB Browser for SQLite - Create and edit SQlite databases, explore their content, as well as write and execute SQL queries and view the results with this reliable tool.
cd /usr/bin/After changing directory to /usr/bin with the above command, type the following command followed by the enter / return key to start the sqlite command line interface:
sqlite3To create a new SQLite table via the command line interface, type the following followed by the enter / return key:
create table department(dept_no int, dept_name varchar(25));To insert data into the newly created department table, type the following:
insert into department values (1, 'Sales');To view the data in an SQLite table, a select SQL query can be executed. Below is an example:

select * from department;You can exit the command line program by holding the control button and typing z.
Listed below is a screenshot of the Mac terminal showing the commands executed above:
Creating and editing databases is cumbersome using the command line program, so a graphical tool like RazorSQL that is capable of communicating with SQLite makes it much easier to manage your SQLite databases.
RazorSQL is available from here
https://razorsql.com/download.html
With RazorSQL, users can create new or edit existing SQLite databases. It also provides an SQLite browser for showing all tables, views, triggers, etc. and an SQL editor for writing queries and statements to execute against the SQLite database and many more features.
Navicat for SQLite is a feature-packed SQLite GUI that aims to help database administrators create, organize, access and share information in an efficient and secure manner, while also making it possible to sync data via a native cloud storage service. Intuitive interface that has a streamlined, modern.
(Please consider sponsoring us on Patreon 😄)
Our latest release (3.12.0) for Windows:
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. 😄
Our latest release (3.12.0) for macOS:


If you prefer using Homebrew for macOS, our latest release can be installed via Homebrew Cask:
Download nightly builds for Windows and macOS here:
DB Browser for SQLite works well on Linux.
Arch Linux provides a package through pacman.
Install for Fedora (i386 and x86_64) by issuing the following command:
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:
Install the package using:
For Ubuntu and derivaties, @deepsidhu1313provides a PPA with the latest release here:
To add this ppa just type in these commands in terminal:
Then update the cache using:
Install the package using:
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:
Nightly builds are available here:
To add this ppa, type these commands into the terminal:
Then update the cache using:
Install the package using:
On others, compile DB4S using the instructionsin BUILDING.md.
DB Browser for SQLite works well on FreeBSD, and there is a port for it (thanksto lbartoletti 😄). DB4S can be installedusing either this command:
or this command:
Main soft
| Name | Version | Type | download | size |
| LiteManager Windows | 4.9 | Pro/Free | download | 40 MB |
| LiteManager Android | 4.9 | Free | LiteManager.apk | 9 MB |
| LiteManager Mac OS | 4.9 | Free | 18 MB | |
| LiteManager iOS | 4.9 | Free | 25.7 MB | |
| LiteManager Linux x64 | 4.9 | Free | LiteManager Linux | 6 MB |

QuickSupport without installation
| Name | Version | Type | download | size |
| ROMServer.exe | 4.9 | Server for remote user | 3 MB | |
| ROMViewer.exe | 4.9 | Viewer without installation | download | 3.5 MB |
| ROMServer.exe | 4.9 | Server without administrator rights | download | 2.5 MB |
| LMNoIpServer.exe | 4.9 | NOIP (ID router) | download | 2 MB |
| LMNoIpServer.exe x64 | 4.9 | NOIP (ID router) x64 | download | 3 MB |
Warning: Do not accept help from unknown callers.
Microsoft, or your ISP will never call and ask you to download LiteManager.
Please be attentive and never grant access to people you don't know personally or whom you don't trust.
Previous versions
| Name | Version | Type | download | size |
| LiteManager | 4.8 | Pro/Free | download | 34 MB |
Other soft
| Name | Version | Type | download | size |
| Eyes relaxing and focusing | 3 | Free | download | 1 MB |
| Cowboy with keyboard | 3 | Free | download | 3 MB |