┌─ FILE ANALYSIS ──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────── ┐
│ DEVELOPER : D. Richard Hipp
│ CATEGORY : Data
│ MIME TYPE : application/x-sqlite3
│ MAGIC BYTES : 53514C69746520666F726D61742033
└ ──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────── ┘
What is a SQLite file?
SQLite is a self-contained, serverless, zero-configuration database engine that stores an entire database in a single file. It’s the most deployed database engine in the world, used in every smartphone, most web browsers, and countless applications.
How to open SQLite files
- DB Browser for SQLite (Windows, macOS, Linux) — Free
- DBeaver (Windows, macOS, Linux) — Free, universal
- sqlite3 (CLI) — Built-in on macOS/Linux
- SQLiteStudio (Windows, macOS, Linux) — Free
- Python —
import sqlite3built-in module
Technical specifications
| Property | Value |
|---|---|
| Type | Embedded relational database |
| ACID | Full ACID compliance |
| Max Database Size | 281 TB |
| Max Row Size | 1 GB |
| Concurrent Reads | Unlimited |
| SQL Standard | Most of SQL-92 |
Common use cases
- Mobile apps: iOS Core Data, Android Room
- Web browsers: Chrome, Firefox, Safari local storage
- IoT devices: Embedded data storage
- Testing: In-memory database for unit tests