SQLite
E36073
SQLite is a lightweight, self-contained, serverless SQL database engine widely embedded in applications, operating systems, and devices.
All labels observed (2)
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
ⓘ
surface form:
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 ⓘ Mozilla Firefox ⓘ
surface form:
Firefox
Google Chrome ⓘ Safari ⓘ Skype ⓘ Windows 10 ⓘ iOS ⓘ macOS ⓘ many embedded systems ⓘ |
| website | https://www.sqlite.org/ ⓘ |
| writtenIn | C ⓘ |
Referenced by (28)
Full triples — surface form annotated when it differs from this entity's canonical label.
subject surface form:
Vapor
this entity surface form:
sqlite3