SQLITE3 File Documentation

Overview

Feature Value
File Format Type SQLite 3 Database File
File Extension .sqlite3, .sqlite, .db
MIME Type application/x-sqlite3
Primary Usage Database Storage
Database Structure Single File
Concurrency Model Multiversion Concurrency Control (MVCC)
ACID Compliance Yes
SQL Support Partial SQL92 Standard
Encryption Support With Extensions
Maximum Database Size 140 TB (Petabytes with large page sizes)
Maximum Number of Tables Unlimited (limited by file size)
Maximum Columns per Table 2000
Maximum Row Size 1 GB
Data Types Supported NULL, INTEGER, REAL, TEXT, BLOB
Indexes Yes, including unique indices
Foreign Key Support Yes
Transactional Support Yes
Operating System Compatibility Cross-Platform
Programming Language Written In C
Embeddable Yes
Default File Storage Format Binary
Developer D. Richard Hipp
Release Year 2000