SQLite

Definition

An embedded, file-based relational database that provides SQL, transactions, and constraints without a separate server process.

Compare with

• PostgreSQLdatabase systemAn open-source server-based relational database that accepts multiple connections and provides SQL, transactions, constraints, indexes, and operational recovery features.

Terms that compare with this term

• PostgreSQLdatabase systemAn open-source server-based relational database that accepts multiple connections and provides SQL, transactions, constraints, indexes, and operational recovery features.

Related notes

• SQL Basics
• SQLite — A Single-File DB for Local Apps
• MCP — Model Context Protocol

Related courses

• testcontainers
• Local SQLite
• IPC — command / event