SQLITE File Documentation

Overview

Feature Value
Format Type Relational Database File
Default File Extension .sqlite, .db, .sqlite3, .db3
MIME Type application/x-sqlite3
Primary Usage Storing and manipulating structured data
Developer SQLite Consortium
First Released 2000
Data Storage Model SQL-based
ACID Compliance Yes
Concurrency Model Multiversion Concurrency Control (MVCC)
Encryption Support through extensions (not native)
Maximum Database Size 140 TB
Maximum Number of Tables No explicit limit (limited by maximum database size)
Maximum Number of Columns 2000 per table
Maximum Row Size 1 GB
SQL Compliance Level Partial SQL92 (SQL2) standard compliance
Indexes Supported
Transactions Atomic, Consistent, Isolated, Durable (ACID)
Extension Mechanism Loadable extensions
Storage Mechanism Single-file, disk-based
Operating System Compatibility Multi-platform (Windows, Linux, macOS, more)