SQLite Features
What are the features of SQLite?
Database Features
- Storage
- Availability
- Stability
- Scalability
- Security
- Data Manipulation
- Query Language
Support
- Data Types
- Languages
- Operating Systems
Security
- Database Locking
- Authentication
Management
- Data Schema
- Query Language
- Data Replication
Top Rated SQLite Alternatives
(4)
4.9 out of 5
Visit Website
Sponsored
SQLite Categories on G2
Filter for Features
Database Features
Storage | As reported in 172 SQLite reviews. | 81% (Based on 172 reviews) | |
Availability | 170 reviewers of SQLite have provided feedback on this feature. | 84% (Based on 170 reviews) | |
Stability | 174 reviewers of SQLite have provided feedback on this feature. | 83% (Based on 174 reviews) | |
Scalability | As reported in 159 SQLite reviews. | 67% (Based on 159 reviews) | |
Security | As reported in 156 SQLite reviews. | 69% (Based on 156 reviews) | |
Data Manipulation | See feature definition | This feature was mentioned in 171 SQLite reviews. | 80% (Based on 171 reviews) |
Query Language | As reported in 176 SQLite reviews. | 83% (Based on 176 reviews) |
Support
Text Search | As reported in 25 SQLite reviews. Provides support for international character sets and full text search. | 81% (Based on 25 reviews) | |
Data Types | Based on 29 SQLite reviews. Supports multiple data types like primitive, structured, document etc. | 84% (Based on 29 reviews) | |
Languages | Supports multiple procedural programming languages like PL/PGSQL, Perl, Python etc. This feature was mentioned in 27 SQLite reviews. | 83% (Based on 27 reviews) | |
Operating Systems | Based on 27 SQLite reviews. Available on multiple operating systems like Linux, Windows, MacOS etc. | 82% (Based on 27 reviews) |
Security
Database Locking | As reported in 25 SQLite reviews. Prevents other users and applications from accessing data while it is being updated to avoid data loss or update. | 77% (Based on 25 reviews) | |
Access Control | Allows permissions to be granted or revoked in the database, schema or table levels. 24 reviewers of SQLite have provided feedback on this feature. | 80% (Based on 24 reviews) | |
Encryption | Built-in native encryption with enterprise key management. 24 reviewers of SQLite have provided feedback on this feature. | 76% (Based on 24 reviews) | |
Authentication | Provides multi-factor authentication with certificates. 26 reviewers of SQLite have provided feedback on this feature. | 76% (Based on 26 reviews) |
Performance
Disaster Recovery | As reported in 23 SQLite reviews. Provides data recovery functionality to protect and restore data in a database. | 79% (Based on 23 reviews) | |
Data Concurrency | Based on 24 SQLite reviews. Allows multi-version concurrency control. | 80% (Based on 24 reviews) | |
Workload Management | As reported in 24 SQLite reviews. Handles workloads, from single machines to data warehouses or web services with many concurrent users. | 80% (Based on 24 reviews) | |
Advanced Indexing | Allows users to quickly retrieve data through various types of indexing like B-tree, hash table etc. 24 reviewers of SQLite have provided feedback on this feature. | 82% (Based on 24 reviews) | |
Query Optimizer | As reported in 25 SQLite reviews. Helps interpret SQL queries and determine the fastest method of execution. | 85% (Based on 25 reviews) |
Management
Data Schema | Data is organized as a set of tables with columns and rows like a table structure. This feature was mentioned in 26 SQLite reviews. | 89% (Based on 26 reviews) | |
Query Language | As reported in 28 SQLite reviews. Allows users to create, update and retrieve data in a database. | 88% (Based on 28 reviews) | |
ACID - Complaint | Based on 25 SQLite reviews. Adheres to ACID (atomicity, consistency, isolation, durability), a set of database transaction properties. | 84% (Based on 25 reviews) | |
Data Replication | Provides log-based or/and trigger-based replication. 26 reviewers of SQLite have provided feedback on this feature. | 78% (Based on 26 reviews) |
