SQLite Database
SQLite is a self-contained, serverless relational database stored in a single file. It is the most widely deployed database engine in the world, embedded in every smartphone, browser, and many applications. SQLite requires no configuration, no server, and supports full SQL.
MIME Type
application/vnd.sqlite3
Type
Binary
Compression
Lossless
Advantages
- + Zero configuration — just a file, no server needed
- + Most deployed database in the world (billions of instances)
- + Cross-platform binary format — works on every OS
- + Full ACID transactions and SQL support
Disadvantages
- − Not designed for high-concurrency write workloads
- − No built-in user authentication or access control
- − Single-writer model — only one write transaction at a time
When to Use .SQLITE
Use SQLite for mobile apps, desktop applications, testing, prototyping, and any situation where a full database server is unnecessary.
Technical Details
A SQLite file is a cross-platform binary format with B-tree storage for tables and indexes. It supports transactions (ACID), triggers, views, and most SQL-92 features. The entire engine is a single C library.
History
D. Richard Hipp created SQLite in 2000 for the U.S. Navy as a zero-config embedded database. It is in the public domain and is now used in iOS, Android, Chrome, Firefox, and billions of other devices.