Introducing G2.ai, the future of software buying.Try now
SQLite
Save to My Lists
Unclaimed
Unclaimed

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

MySQL
(1,636)
4.4 out of 5

Filter for Features

Database Features

Storage

172 reviewers of SQLite have provided feedback on this feature.
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

159 reviewers of SQLite have provided feedback on this feature.
67%
(Based on 159 reviews)

Security

As reported in 156 SQLite reviews.
69%
(Based on 156 reviews)

Data ManipulationView full feature definition

See feature definition
As reported in 171 SQLite reviews.
80%
(Based on 171 reviews)

Query Language

176 reviewers of SQLite have provided feedback on this feature.
83%
(Based on 176 reviews)

Support

Text Search

Based on 25 SQLite reviews. Provides support for international character sets and full text search.
81%
(Based on 25 reviews)

Data Types

Supports multiple data types like primitive, structured, document etc. This feature was mentioned in 29 SQLite reviews.
84%
(Based on 29 reviews)

Languages

As reported in 27 SQLite reviews. Supports multiple procedural programming languages like PL/PGSQL, Perl, Python etc.
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

As reported in 24 SQLite reviews. Allows permissions to be granted or revoked in the database, schema or table levels.
80%
(Based on 24 reviews)

Encryption

Built-in native encryption with enterprise key management. This feature was mentioned in 24 SQLite reviews.
76%
(Based on 24 reviews)

Authentication

Based on 26 SQLite reviews. Provides multi-factor authentication with certificates.
76%
(Based on 26 reviews)

Performance

Disaster Recovery

Based on 23 SQLite reviews. Provides data recovery functionality to protect and restore data in a database.
79%
(Based on 23 reviews)

Data Concurrency

As reported in 24 SQLite reviews. Allows multi-version concurrency control.
80%
(Based on 24 reviews)

Workload Management

Handles workloads, from single machines to data warehouses or web services with many concurrent users. This feature was mentioned in 24 SQLite reviews.
80%
(Based on 24 reviews)

Advanced Indexing

Based on 24 SQLite reviews. Allows users to quickly retrieve data through various types of indexing like B-tree, hash table etc.
82%
(Based on 24 reviews)

Query Optimizer

Helps interpret SQL queries and determine the fastest method of execution. 25 reviewers of SQLite have provided feedback on this feature.
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

Allows users to create, update and retrieve data in a database. 28 reviewers of SQLite have provided feedback on this feature.
88%
(Based on 28 reviews)

ACID - Complaint

As reported in 25 SQLite reviews. Adheres to ACID (atomicity, consistency, isolation, durability), a set of database transaction properties.
84%
(Based on 25 reviews)

Data Replication

As reported in 26 SQLite reviews. Provides log-based or/and trigger-based replication.
78%
(Based on 26 reviews)