15 years helping British businesses
choose better software

What is SQLite?

Open source database engine used by applications due to its compact size, cross platform stability and serverless functionality.

Who Uses SQLite?

Large businesses.

SQLite Software - SQLite managing class library
SQLite Software - SQLite database browser
SQLite Software - SQLite startup page

Not sure about SQLite? Compare with a popular alternative

SQLite

SQLite

4.5 (116)
US$6,000.00
one-time
Free version
Free trial
18
No integrations found
4.5 (116)
4.5 (116)
3.6 (116)
VS.
Starting Price
Pricing Options
Features
Integrations
Ease of Use
Value for Money
Customer Service
No pricing found
Free version
Free trial
12
No integrations found
3.9 (190)
4.2 (190)
3.9 (190)
Green rating bars show the winning product based on the average rating and number of reviews.

Other great alternatives to SQLite

Microsoft Access
Top rated features
Access Controls/Permissions
Customizable Fields
Data Storage Management
Grasp Technologies
Top rated features
Ad hoc Reporting
Booking Management
Dashboard
MariaDB
Top rated features
Backup and Recovery
Data Storage Management
Multiple Programming Languages Supported
MySQL
Top rated features
Backup and Recovery
Relational Database Management
Secure Data Storage
Oracle Database
Top rated features
Access Controls/Permissions
Backup and Recovery
Data Storage Management
PostgreSQL
Top rated features
Access Controls/Permissions
Backup and Recovery
Data Storage Management
Alventis Database
Top rated features
No features have been rated by reviewers for this product.
Microsoft SQL Server
Top rated features
Backup and Recovery
Data Storage Management
Performance Analysis
Contineo
Top rated features
No features have been rated by reviewers for this product.

Reviews of SQLite

Average score

Overall
4.5
Ease of Use
4.5
Customer Service
3.6
Features
4.1
Value for Money
4.5

Reviews by company size (employees)

  • <50
  • 51-200
  • 201-1,000
  • >1,001

Find reviews by score

5
55%
4
37%
3
7%
2
1%
Stephen
Stephen
Lead Android Developer in Nigeria
Verified LinkedIn User
Computer Software, 11–50 Employees
Used the Software for: 2+ years
Reviewer Source

Perfect database tool for embedded software

5.0 5 years ago

Comments: I work a lot with SQLite as it is the primary medium of local storage in Android devices (and by extension, Android applications) which I work with on a daily basis, and SQLite is just perfect for the purpose it serves on these devices. It's lightweight so you don't have to worry most times about how much of the user's storage space your database is going to take up. There's not much difference between the standard SQL commands and those used in SQLite, and many have reported that SQLite is a good starting and training resource for SQL in general.

Pros:

Doesn't need a separate server. Lightweight and portable. Integrates most of the commands, functions and syntax of other SQL software. Optimized for use on devices that need to store data locally. Large user base and community (support).

Cons:

All operations are locked to a single process, so it's not suitable for large scale database operations (which is not what you should be doing locally on a device anyway).

Jacek
DevOps Engineer in Spain
Information Technology & Services, 11–50 Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

Power in the simplicity

5.0 last year

Comments: Works very well in simple scenarios! It might be a great choice for small applications that require low maintenance and easy setup

Pros:

It's very simple to use and lightweight. Typically does not require a separate server (it could run on the same server as a web application). It's quite handy that the database is contained in one file, which then can be backed up easily or transferred across machines. It's quite fast for certain uses.

Cons:

Compared to other RDBMSes, it's very simple - which means that it's lacking certain features when it comes to scalability - it performs well in simple scenarios, and in complex ones - it just won't (unless you are very lucky and it's e.g. a case when there is only a single connection).Moreover, it lacks certain security features like user management and access control.

Chaya
Chaya
Trainee Software Engineer in Sri Lanka
Verified LinkedIn User
Computer Software, 51–200 Employees
Used the Software for: 1+ year
Reviewer Source

SQLite - compatability at it's best level

3.0 5 years ago

Comments: SQLite has become more and more popular among the users because of its easy installation and easy accessing . As it is compatible with most of the programming languages and its light weight it is more popular among mobile application developers

Pros:

SQLite is a light weighted data base which could be embedded with any software. Due to the light weightage of the product the data base is more popular In mobile application development. With it’s light weight it is also fast. SQLite is almost 35% faster than any other file system. SQLite is easy to use and there is not special installation or configurations needed to be done in order to use the product. All user have to do is download the libraries and run them in the computer. It is compatible which is why the product can be used with many programming languages with out any issues. Users are given a chance to extend their data base in future by adding new tables or new columns to the existing tables which is a great help for the ongoing projects.

Cons:

SQLite is not a multi-user platform where the users can handle concurrent writes. There for SQLite is not good for intensive applications with rapid data logging. If the system has concurrent transactions where lot of users keep accessing the same set of data simultaneously then SQLite is not a good choice for the project. SQLite data bases are restricted to maximum of 2GB in most of the cases.

Verified Reviewer
Verified LinkedIn User
Computer Software, 501–1,000 Employees
Used the Software for: 1+ year
Reviewer Source

The best database management

5.0 3 months ago

Comments: I've been using SQLite to store databases and manage them easily. It's a fast and light tool, which helped me in several different cases.

Pros:

It's light (doesn't require much resources), fast, it's stable, cross-platform. It's a free and open-source software which helps a lot with saving money and making sure it's secure.

Cons:

It's not recommended for big databases, only for small ones.

Jonathan Alexander
Jonathan Alexander
IT infrastructure analyst in Dominican Republic
Verified LinkedIn User
Hospital & Health Care, 1,001–5,000 Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

An excellent database for mobile projects

4.0 2 years ago

Comments: I have used this database for the development of mobile application projects and for the prototyping of web pages, which makes it a very good database, easy and agile when manipulating data

Pros:

What I like most about this product or database is how easy it is to integrate with mobile projects in the creation of applications and its easy portability, as well as performance, agility and little space in its implementation that makes it unique when it comes to of mobile application projects

Cons:

That for very large projects it is not so robust handling so many transaction threads