Sample SQLite files

SQLite is an entire SQL database in a single file, with no server. Below are sample .sqlite databases — from a single table to a relational schema with foreign keys, indexes and views — to download

Sample file: Simple SQLite: one users table with data
Simple SQLite: one users table with data
8 Kb
↓
Sample file: Relational SQLite: customers, products, orders (foreign keys)
Relational SQLite: customers, products, orders (foreign keys)
36 Kb
↓
Sample file: Storage classes: NULL, INTEGER, REAL, TEXT, BLOB
Storage classes: NULL, INTEGER, REAL, TEXT, BLOB
8 Kb
↓
Sample file: Large SQLite: a 100,000-row table
Large SQLite: a 100,000-row table
1.9 Mb
↓
Sample file: Empty SQLite: two tables, zero rows
Empty SQLite: two tables, zero rows
12 Kb
↓

🧠 How SQLite works

SQLite is an entire database in a single file, with no separate server. The file is split into fixed-size pages (pages); the internal sqlite_master table holds the schema, while data and indexes live in a B-tree structure. The first 16 bytes of the file are the signature. One library reads the file on any OS.

🗄️ One file no server 📄 pages fixed size 🌳 B-tree tables + indexes 🗝️ sqlite_master DB schema 💾 .sqlite ready file