SQLite

RATING:

4.45

(104)

About SQLite

SQLite is a license-based software library that provides businesses with a serverless and self-contained SQL database management system. The embedded database engine allows developers to manage multiple tables, triggers, indices and views of data within a single disk file and store additional files in a rollback journal for future purposes. Key features of SQLite include foreign key support, error and warning log, database analyzer, full-text search and JSON integration. The library comes with built-in scalar SQL functions, which lets administrators manage date and time strings, language expressions such as syntax, constants, if-then-else cases and between or like comparisons in databases. Additionally, users can also attach multiple databases into a single databa...

Awards and Recognition

FrontRunner 2021
Software Advice's FrontRunners report ranks top products based based on user reviews, which helps businesses find the right software.

SQLite Pricing

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

Starting price: 

$2,000.00 one time

Free trial: 

Not Available

Free version: 

Not Available

SQLite file formats
Slide 1 of 2

SQLite Reviews

Overall Rating

4.45

Ratings Breakdown

Secondary Ratings

Ease-of-use

4.5

Customer Support

3.5

Value for money

4.5

Functionality

4

Showing 1 - 5 of 103 reviews

User Profile

Ramindu

Verified reviewer

Company size: 10,000+ employees

Industry: Computer Software

Time used: More than 2 years

Review Source: Capterra 

This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.

EASE OF USE

4

VALUE FOR MONEY

5

CUSTOMER SUPPORT

2

FUNCTIONALITY

3

November 2019

The best solution for small, pre-packaged databases

We included SQLite alongside web and mobile applications where a small database was needed with minimum latency. Most commonly, this use case involved storing dynamic configuration values and user preferences.

Pros

SQLite is a great database solution when you have a small database that you need to package alongside an application, for example a database that stores user preferences. As it is local to the application, it bypasses issues you would have with other, larger database servers in terms of network latency. Its conformity (in the large part) to MySQL syntax and features make it easy to use as well.

Cons

While SQLite's lack of scaling features is forgivable (that wasn't what it was built for after all) some SQL features that are not implemented make it a hassle to write queries to SQLite databases in some instances.

User Profile

Anderson

Verified reviewer

Company size: 201-500 employees

Industry: Information Technology and Services

Time used: Less than 12 months

Review Source: Capterra 

This review was submitted organically. No incentive was offered

EASE OF USE

3

VALUE FOR MONEY

5

CUSTOMER SUPPORT

3

FUNCTIONALITY

2

November 2018

Easy to become a problem

On a Windows Forms app we used to query services thousand times for data that does not change so frequently. We also had to store some business information (imagine as storing a wizard progress) and that used to be handled using TXT files (and it was a mess). We changed to SQLite and it worked almost like a charm but as the app grew and we decided to create an architecture similar to Google Chrome (multiple processes) it became a major problem for all of them to both read and write at it (we had to create a proxy app to write).

Pros

Integrates nicely with .NET (specially Windows Forms) applications, it's really easy to use (specially if you're already familiar with SQL Server) and deployment is really easy (copy/paste required files).

Cons

It's locking architecture enables only a single process to write at a time so building a more complex application may cause hard-to-solve problems.

User Profile

Wechuli

Verified reviewer

Company size: 1,001-5,000 employees

Industry: Computer Software

Time used: More than 2 years

Review Source: Capterra 

This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.

EASE OF USE

5

VALUE FOR MONEY

5

CUSTOMER SUPPORT

1

FUNCTIONALITY

3

March 2020

Good but Limited Use

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

User Profile

Nera Joy

Verified reviewer

Time used: More than 2 years

Review Source: Capterra 

This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.

EASE OF USE

4

VALUE FOR MONEY

3

CUSTOMER SUPPORT

3

FUNCTIONALITY

2

June 2018

A good choice for storing small and local data

Pros

I love how SQLite is so portable, and can be used in different platforms. I doesn't need any bulky installation for me to use. It is so lightweight and there is no learning curve when you came from MS SQL.

Cons

Maybe when opening a large sqlite file around 1GB above, it hangs up and sometimes fails to load. But maybe that's my fault because SQLite is not intended for storing large data. Good product anyway.

Steve

Company size: 11-50 employees

Industry: Electrical/Electronic Manufacturing

Time used: More than 2 years

Review Source: Capterra 

This review was submitted organically. No incentive was offered

EASE OF USE

4

FUNCTIONALITY

4

June 2022

Very good local database.

Pros

We use it in our software when we need little local database. The API with c# is very easy to learn. I recommand this if you need local database.

Cons

There is no data viewer include. You need to find an alternative.

Popular SQLite Comparisons