Statements (172)
| Predicate | Object |
|---|---|
| gptkbp:instance_of |
gptkb:Data
|
| gptkbp:acidity |
gptkb:Yes
|
| gptkbp:application |
No
|
| gptkbp:community_support |
Active community
Extensive documentation Various third-party tools available |
| gptkbp:creator |
gptkb:Richard_Hipp
|
| gptkbp:data_type |
INTEGER
BLOB TEXT nan REAL |
| gptkbp:developed_by |
gptkb:Richard_Hipp
gptkb:D._Richard_Hipp |
| gptkbp:development |
gptkb:2000
|
| gptkbp:features |
gptkb:Command_Line_Interface
Cross-platform Compact size data integrity Read-only mode community support data types data visualization tools error handling extensibility lightweight performance optimization portability user-defined functions full-text search Cross-platform compatibility Serverless cross-platform compatibility data compression schema management user community encryption support self-contained Transactional transaction control Multi-threading support Concurrency support Extensions support open-source development API support multi-threading support extensive testing JSON support logging and auditing Data security features No external dependencies Self-contained serverless Lightweight architecture User-defined functions support Data import/export capabilities Backup and restore capabilities Data types support Data analysis support Performance optimization features Triggers support Views support backup and restore capabilities fast performance Data visualization support Error handling support Data migration support active maintenance Zero-configuration foreign key support Full-text search support data export/import Transactions support Data validation support triggers and views zero-configuration Foreign key support Integration with programming languages Backup API support Built-in functions support Command-line interface support Custom collations support Custom virtual tables support Data archiving support Data compression support Data integrity support Data recovery support Data reporting support Data sharing support Data synchronization support Data transformation support Data type affinity support Database encryption support Database versioning support Error codes support In-memory databases support Portable database files Row-level locking support SQL functions support Schema support Temporary tables support |
| gptkbp:file_format |
single file
Single file database SQLite database file (.sqlite) SQLite database file |
| gptkbp:first_released |
gptkb:2000
|
| gptkbp:has_color |
gptkb:Yes
|
| gptkbp:has_documentation |
https://www.sqlite.org/docs.html
|
| gptkbp:has_relationship_with |
gptkb:Yes
|
| https://www.w3.org/2000/01/rdf-schema#label |
SQLite
|
| gptkbp:is_integrated_with |
gptkb:Linux
gptkb:Android gptkb:i_OS gptkb:mac_OS gptkb:Windows Browsers like Firefox and Chrome |
| gptkbp:is_often_used_in |
Data analysis
Application file format Data storage for mobile apps Local data storage for web apps Testing and prototyping |
| gptkbp:language |
gptkb:SQL
|
| gptkbp:latest_version |
3.42.0
3.39.2 Latest version as of 2023 is 3.39.2 |
| gptkbp:license |
Public Domain
Public domain |
| gptkbp:maximum_columns |
gptkb:2000
|
| gptkbp:maximum_database_size |
140 terabytes
|
| gptkbp:maximum_row_size |
1 billion bytes
|
| gptkbp:performance |
Fast for read operations
Good for small to medium-sized databases Limited concurrency |
| gptkbp:platform |
Cross-platform
cross-platform |
| gptkbp:release_date |
2023-10-01
2000-08-17 |
| gptkbp:repository |
https://www.sqlite.org
|
| gptkbp:security |
Encryption available through extensions
File-based security No built-in user management |
| gptkbp:supports |
gptkb:SQL
gptkb:Views ACID transactions Indexes SQL syntax Triggers Foreign keys Full-text search (FTS) JSON1 extension |
| gptkbp:supports_joins |
gptkb:Yes
|
| gptkbp:supports_subqueries |
gptkb:Yes
|
| gptkbp:supports_user_defined_functions |
gptkb:Yes
|
| gptkbp:trigger_type |
gptkb:Yes
|
| gptkbp:type_of |
gptkb:Yes
|
| gptkbp:used_in |
gptkb:Embedded_Systems
gptkb:mobile_applications Mobile Applications Embedded systems Web Browsers Web browsers Mobile applications data analysis tools desktop applications embedded systems web browsers |
| gptkbp:uses |
gptkb:SQL
|
| gptkbp:view |
gptkb:Yes
|
| gptkbp:written_by |
gptkb:Richard_Hipp
|
| gptkbp:written_in |
gptkb:C
|
| gptkbp:bfsParent |
gptkb:cloud_computing
|
| gptkbp:bfsLayer |
3
|