SQLite Free Database Management System
Fast, Small, Highly Reliable and Open Source DBMS Software
SQLite database management system is built into most mobile phones and computers. It comes bundled inside countless other applications that we daily use.
Overview
SQLite DBMS is a Library of C-language that acts as a database engine. It is a small, fast, self-contained as well as highly-reliable and open source DBMS software. It is a built-in or embedded database engine, so it doesn’t require any configuration on your system. SQLite DBMS is available for different platforms like Windows (Win32, WinCE, WinRT) and also for UNIX (Linux, Mac OS-X, Android, iOS). No external dependencies are required for SQLite because it is self-contained. This SQLite DMBS is stored in a single cross-platform disk file.
SQLite is lightweight in terms of setup, database administration, and required resources. The SQLite open source database engine can be linked statically or dynamically as per the requirement of the application. It is the most widely deployed database engine. It can be faster than direct file system I/O, even its performance is good in low-quality environments. It is a complete database that contains views, multiple tables, and triggers in a single disk file. SQLite is server-less as it does not require a separate server process or system to operate like other RDMBS. SQLite transactions are fully ACID-compliant.
System Requirements
Following are the requirements to install SQLite on Ubuntu 18.04
- Ubuntu 18.04 server
- Access to a command-line/terminal window
- A non-root user with sudo permissions
- A basic firewall
Features
- Server-less Database engine
- Self-contained
- Requires zero configuration
- A single cross-platform disk file store complete SQLite database
- No external dependencies requires
- Available for different platforms
- Lightweight
- Highly reliable database engine
- Small in size
- ACID transactions
- Advance query planner
- Access storage files directly
- Simple and easy to use
- Free for use
- Compatible for high profile projects
- Embedded
- Trigger Support
Installation
Follow these steps to Install SQLite on Ubuntu 18.04:
- First update your local server’s package index by typing following command:
sudo apt update
- After updating, now upgrade your apt using below command:
sudo apt upgrade
- Now to install SQLite DBMS, type:
sudo apt install sqlite3
- Type the command below to ensure installation:
sqlite3 –version
- Now to install SQLite browser, run this command:
sudo apt install sqlitebrowser
- Now you can go to the Application Menu and type SQLite Browser in search bar and then click on database icon to start it.
