SQLite

4.5 (116)
Write a Review!
Open-source database engine to store and modify data

About SQLite

SQLite is an open-source database engine designed to help organizations store, retrieve, and modify data across web browsers, iOS and Android mobile devices, Dropbox, Skype, and other applications. The platform includes a C-language library, which allows users to implement compact, self-reliant, and secure transactional database engines for server and client-side data processing.

The application file format functionality in SQLite enables businesses to manage a variety of operations including data exchange, autosave, backup, and content revision for multiple systems. It also provides media cataloging, editing suites, and financial analysis tools. SQLite offers a host of features including file archiving, enterprise data cache, multi-column indexes, nested transactions, virtual tables, and more. It includes cross-platform functionality, which allows different systems to transfer, encode, and decode various data formats such as text, large binary blobs, and small numeric or Boolean values.

Administrators can utilize SQLite to handle operations across numerous devices including set-top boxes, remote sensors, cameras, game consoles, watches, automobiles, machine tools, and kitchen appliances. It can also be used as a server-side database, letting developers store data, process client requests, gather results, and filter and analyze information.


Images

SQLite Software - SQLite database browser
SQLite Software - SQLite startup page
SQLite Software - SQLite managing class library
View 4 more
SQLite video
SQLite Software - SQLite database browser
SQLite Software - SQLite startup page
SQLite Software - SQLite managing class library

Not sure about SQLite? Compare with a popular alternative

SQLite

4.5 (116)
VS.
Most reviewed

Starting Price

US$6,000.00
one-time
No pricing found

Pricing Options

Free version
Free trial
Free version
Free trial

Features

18
12

Integrations

No integrations found
No integrations found

Ease of Use

4.5 (116)
3.9 (190)

Value for Money

4.5 (116)
4.2 (190)

Customer Service

3.6 (116)
3.9 (190)
Green rating bars show the winning product based on the average rating and number of reviews.

Alternatives

Microsoft Access

4.4
#1 Alternative to SQLite
Microsoft Access is a database management system that provides intuitive application development tools to create...

MariaDB

4.7
#2 Alternative to SQLite
MariaDB is the database for all, supporting any workload, in any cloud, at any scale. Try MariaDB now.

MySQL

4.6
#3 Alternative to SQLite
MySQL is a relational database management system (RDBMS) designed to help businesses record, update, and manage data...

Grasp Technologies

4.6
#4 Alternative to SQLite
Grasp Technologies offers a suite of data management and virtual payment solutions. It helps users transform data from...

Reviews

Overall rating

4.5 /5
(116)
Value for Money
4.5/5
Features
4.1/5
Ease of Use
4.5/5
Customer Support
3.6/5

Already have SQLite?

Software buyers need your help! Product reviews help the rest of us make great decisions.

Showing 5 reviews of 116
Umut
Overall rating
  • Industry: Entertainment
  • Company size: 11–50 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 7.0 /10

Fast Embedded database

Reviewed on 20/08/2020

Pros

Compact
Fast
Easy to use
Preinstalled in most platform

Cons

Do not support nosql features
Do not support multi client

merve
Overall rating
  • Industry: Education Management
  • Company size: 51–200 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

Excellent option for quick and light needs.

Reviewed on 30/10/2022

What I appreciate best about SQLIte is how lightweight it is and how easily it can be used in...

What I appreciate best about SQLIte is how lightweight it is and how easily it can be used in Android applications. It appears to be designed to function on tiny devices with a minimal footprint. It is also open source. Because no server configuration is necessary, installation and setup take very little time.

Pros

SQLite was an excellent choice for us when we wanted to store a database for a basic utility that we were developing. The performance appeared to be excellent, and it was really steady.

Cons

It is not completely functional with all capabilities unless you purchase a professional version, which comes at a cost.

Wechuli
Wechuli
Overall rating
  • Industry: Computer Software
  • Company size: 1,001–5,000 Employees
  • Used Weekly for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 6.0 /10

Good but Limited Use

Reviewed on 14/03/2020

I use it to quickly test applications that need some form of data storage without needing to...

I use it to quickly test applications that need some form of data storage without needing to install database software.

Pros

- Very lightweight database products that you can quickly set up to without needing to install complicated tooling so can be used in mobile forms or embedded devices.

Cons

- Does not support the full features of SQL
- SQLite does not have support for multi-client concurrency access and can't be used in applications that need this.
- Validation of data to input fields is limited

Verified Reviewer
Overall rating
  • Industry: Telecommunications
  • Company size: 11–50 Employees
  • Used Daily for 1+ year
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

No server required, used for standalone application and less configuration

Reviewed on 25/04/2019

We are using SQLite for java and android application. SQLite is use for small and mid level...

We are using SQLite for java and android application. SQLite is use for small and mid level organization as well because its cost affordable for any one. There is no required to back up every time because SQLite make a file for backup .

Pros

SQLite is very faster then other database as performance wise. we are using SQLite for mobile application and desktop application. Mose imp feature i like in SQLite is at the time of deployment on production it not required any space. SQLite is lightweight. select query is very faster in standalone application.

Cons

There is no reporting functionality in SQLite. At the time of multiple insert query perform in queue that its goes slow for some time. There is administration in SQLite,so its very difficult to manage for multiple user.

Verified Reviewer
Overall rating
  • Industry: Computer Software
  • Company size: 11–50 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Likelihood to recommend 10.0 /10

The perfect landscape to train and test SQL

Reviewed on 06/03/2019

Integrates well with SQL learning tool. Followed many guides in my quest to learn SQL and almost...

Integrates well with SQL learning tool. Followed many guides in my quest to learn SQL and almost all suggested SQLite. This is mostly for training and testing.

Pros

About as simple as it gets -- as the name suggests. Made learning SQL easy knowing I wouldn't be affecting my own database.

Cons

I truly enjoyed using the product although I never use it anymore. It sits dormant on my computer now that I have a grasp of SQL.

Showing 5 reviews of 116 Read all reviews

SQLite FAQs

Below are some frequently asked questions for SQLite.

SQLite offers the following pricing plans:

  • Starting from: US$6,000.00/one-time
  • Free Trial: Not Available

SQLite is available as an open-source application along with one-time fees, details of which are outlined below: SQLite License - $6000 one time fee SQLite Encryption Extension (SEE) - $2000 one time fee Compressed And Encrypted Read-Only Database (CEROD) - $2000 one time fee The ZIPVFS Read/Write Compressed Database Extension - $4000 one time fee

SQLite has the following typical customers:

2–10, 11–50, 51–200, 201–500, 501–1,000, 1,001–5,000

SQLite supports the following languages:

English

SQLite supports the following devices:

We do not have any information about what integrations SQLite has

SQLite offers the following support options:

Email/Help Desk, FAQs/Forum, Knowledge Base, Chat

Related categories

See all software categories found for SQLite.