SQLite
E36073
SQLite is a lightweight, self-contained, serverless SQL database engine widely embedded in applications, operating systems, and devices.
Aliases (1)
- sqlite3 ×1
Statements (58)
| Predicate | Object |
|---|---|
| instanceOf |
SQL database engine
→
embedded database → open-source software → relational database management system → |
| concurrencyModel |
file-level locking
→
|
| designGoal |
reliability
→
simplicity of integration → small footprint → |
| developer |
D. Richard Hipp
→
Hwaci → |
| fileFormat |
single cross-platform disk file
→
|
| hasAPI |
C API
→
command-line shell → |
| initialReleaseDate |
2000
→
|
| isEmbeddedIn |
applications
→
consumer devices → mobile apps → operating systems → web browsers → |
| isSelfContained |
true
→
|
| isServerless |
true
→
|
| isZeroConfiguration |
true
→
|
| license |
public domain
→
|
| programmingLanguage |
C
→
|
| storesDataIn |
single file per database
→
|
| supportsFeature |
ACID properties
→
B-tree indexes → JSON functions → WAL (write-ahead logging) → atomic commit and rollback → foreign keys → full-text search (FTS) extensions → transactions → triggers → views → |
| supportsPlatform |
Android
→
Linux → Windows → iOS → macOS → |
| supportsQueryLanguage |
SQL
→
|
| supportsSQLStandardSubset |
true
→
|
| supportsTransactions |
true
→
|
| typicalUseCase |
embedded devices data management
→
local data storage in applications → testing and prototyping → |
| usedBy |
Android
→
Dropbox client → Firefox → Google Chrome → Safari → Skype → Windows 10 → iOS → macOS → many embedded systems → |
| website |
https://www.sqlite.org/
→
|
| writtenIn |
C
→
|
Referenced by (8)
| Subject (surface form when different) | Predicate |
|---|---|
|
Django
→
Entity Framework → PHP → Vapor → |
supportsDatabase |
|
Data Control Language
→
|
implementedBy |
|
Python standard library
("sqlite3")
→
|
includesModule |
|
SQL
→
|
usedBySystem |
|
Flask-SQLAlchemy
→
|
worksWith |