SQLite

Definitions

1. A self-contained, serverless, zero-configuration relational database engine stored as a single file on disk. It is the most widely deployed database in the world — embedded in every smartphone, browser, and most operating systems — and supports full SQL with ACID transactions, making it ideal for local storage, testing, and applications that don't need client-server architecture.

   In plain English: A lightweight database that lives in a single file on your computer, with no server needed, used by virtually every phone and browser.

   Example: "For the mobile app we just use SQLite — it's a single file, no server to manage, and it handles millions of rows just fine."

Related Terms

• Query
• DuckDB
• Left Join
• MySQL
• PostgreSQL
• Primary Key
• Query Builder
• Raw SQL
• RDBMS