SQLite – Embedded Database

SQLite is a self-contained, serverless SQL database engine. Used by millions of applications worldwide, it provides a complete database solution in a single file without requiring a separate server process.

Key Features

• Serverless: No configuration or setup
• Single File: Complete database in one file
• Zero-Config: Works out of the box
• ACID Compliant: Full transaction support
• Cross-Platform: Runs everywhere

Installation

Install SQLite on Ubuntu:

sudo apt update
sudo apt install sqlite3

Usage Examples

SQLite operations:

# Create/open database
sqlite3 mydb.sqlite

# Create table
CREATE TABLE users (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL,
    email TEXT UNIQUE
);

# Insert data
INSERT INTO users (name, email) VALUES ('John', 'john@example.com');

# Query data
SELECT * FROM users WHERE name LIKE '%John%';

# Export to SQL
.output backup.sql
.dump

Benefits

SQLite provides SQL database power without complexity. Its zero-configuration nature makes it perfect for applications, mobile apps, and embedded systems.

Download SQLite