It's been two months since this profile received a new review

SQLite Reviews & Product Details

SQLite is a C-language library that provides a self-contained, serverless, and zero-configuration SQL database engine. Renowned for its small footprint and high reliability, SQLite is the most widely deployed database engine globally, embedded in billions of devices and applications. Its cross-platform database file format ensures seamless data transfer across different systems, making it a preferred choice for developers seeking an efficient and dependable database solution. Key Features and Functionality: - Self-Contained and Serverless: Operates without a separate server process, reading and writing directly to disk files. - Zero-Configuration: Requires no setup or administration, facilitating easy integration into applications. - Full-Featured SQL Implementation: Supports advanced capabilities like partial indexes, indexes on expressions, JSON, common table expressions, and window functions. - Single-File Database: Stores the entire database, including multiple tables, indices, triggers, and views, in a single cross-platform disk file. - Scalability: Handles databases up to 281 terabytes and supports row sizes up to 1 gigabyte. - Compact Size: With all features enabled, the library size can be less than 900KiB, depending on the target platform and compiler optimization settings. - High Performance: In some cases, SQLite is faster than direct filesystem I/O. - Cross-Platform Compatibility: Supports various operating systems, including Android, iOS, Linux, Mac, and Windows. - Public Domain Source Code: The source code is in the public domain, allowing free use for any purpose. Primary Value and User Solutions: SQLite offers a lightweight, reliable, and easy-to-use database solution that eliminates the complexities associated with traditional database management systems. Its serverless architecture and zero-configuration setup make it ideal for applications where simplicity and efficiency are paramount. By storing data in a single file, SQLite simplifies data management and portability, addressing the needs of developers and organizations seeking a robust database engine without the overhead of a full-fledged RDBMS.

Seller

SQLite

Discussions

SQLite Community

Value at a Glance

Averages based on real user reviews.

Time to Implement

2 months

Return on Investment

13 months

View More Pricing Information

Top-Rated Alternatives

View All Alternatives

SQLite Integrations

(2)

Integration information sourced from real user reviews.

G2 reviews are authentic and verified.

Here's how.

Juan M.

Project Manager

Information Technology and Services

Small-Business (50 or fewer emp.)

9/10/2018

"Quick and reliable database without a server"

4.5/5

What do you like best about SQLite?

SQLite is a relational database system that allows you to have a database without the boilerplate of a complete database server. It has a lot of database features and well defining your database the performance can be good enough for your requirements. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

If you are looking for a real relational database system with multiple access for different sources, better do not use SQLite. This affirmation is even stronger if you are using your database in a Windows filesystem. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Always define well your tables, create indexes and primary keys. It will speed the performance of the access to the database. Review collected by and hosted on G2.com.

What problems is SQLite solving and how is that benefiting you?

We are using SQLite for a lot of applications that need to save relational data for itself: a communications driver, a system services and many other projects. Review collected by and hosted on G2.com.

Verified User in Computer & Network Security

Small-Business (50 or fewer emp.)

6/22/2019

"Decent for simple queery"

2/5

What do you like best about SQLite?

Simple sql implementation for basic queery Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Too basic, needs to be more intuitive for users Review collected by and hosted on G2.com.

Verified User in Computer Networking

Mid-Market (51-1000 emp.)

3/12/2019

"My best experience with SQLite is the deployment. SQLite is an embedded database."

3.5/5

What do you like best about SQLite?

the deployment. SQLite is an embedded database.

So much so, that to use it in a .NET application it is enough to reference a single assembly. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

The problems with the installation of SQL Express are leading me to consider the use of embedded databases for an application that I develop in my work. Review collected by and hosted on G2.com.

Matt B.

software developer/ IT consultant

Small-Business (50 or fewer emp.)

2/27/2019

"Very effective "

4/5

What do you like best about SQLite?

Works great for all the stores procedures we use on the websites search and exchange Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Something that many team members don't like is the exporting of data does not allows transfer accurately Review collected by and hosted on G2.com.

David Z.

Full Stack .Net Developer

Information Technology and Services

Small-Business (50 or fewer emp.)

2/28/2019

"Lightweigt, fast, easy to setup"

4.5/5

What do you like best about SQLite?

It's lightweigt, fast, easy to setup. Nice development tools available. Integrates with latest .NET technologies really nicely. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Unable to connect to database remotely in most situations. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

3/2/2019

"SQLite is a very light weighted database "

4.5/5

What do you like best about SQLite?

SQLite is very easy to learn.

Reading and writing operations are very fast for SQLite database.

It can be used with all programming languages without any compatibility issue.

Review collected by and hosted on G2.com.

What do you dislike about SQLite?

SQLite is used to handle low to medium traffic HTTP requests.

Database size is restricted to 2GB in most cases. Review collected by and hosted on G2.com.

Lee L.

IT Technical Support Specialist

Mid-Market (51-1000 emp.)

10/19/2018

"Works good for removing unwanted builtin Windows 10 applications"

5/5

What do you like best about SQLite?

I used this to remove unwanted builtin apps like xbox and MS Edge from my Windows 10 PC. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I cannot think of any reasons why to dislike this application. Review collected by and hosted on G2.com.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

8/12/2018

"Opensource small and easy to deploy databsae"

4.5/5

What do you like best about SQLite?

It is super easy to get up and running. All you need is a library for whatever language you are using to get up and moving using it. Doesn't require specific server installations or user accounts. You just need to have a library that supports it in whatever programming language you are using. It's very simple and easy to deploy. I can rotate databases very simply just by moving a file, which is great depending on your problem set. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

The biggest con is that you can't scale it or use it for anything complex. It stores everything in a single file, which can lead to slower write speeds, especially compared to more complex systems like MySQL, when you are using it for bigger things. That single file could get very large too, and be a problem if you are on a limited file system like say FAT32 (unlikely, but anything is possible). Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

If you need something that you can get up and running fast. Use between systems, and runs light, then it's the solution for you. Doesn't have much for security and the like, but for small applications it can work really well. Review collected by and hosted on G2.com.

What problems is SQLite solving and how is that benefiting you?

I'm using it for storing data gathered from the cryptocurrency market. It allows me to rotate the database super easy, and to have different data sets for testing against. Writing can be sluggish compared to storage in RAM or other database systems so you should only write when you need to. Review collected by and hosted on G2.com.

Verified User in Retail

Enterprise (> 1000 emp.)

3/15/2019

"SQLite review"

4.5/5

What do you like best about SQLite?

SQLite does not need to be "installed" for use, it's a very lightweight tool to access databse. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

We can't use SQLite in production because it doesn't support concurrency. Review collected by and hosted on G2.com.

Varun S.

Data Engineer

Computer Software

Enterprise (> 1000 emp.)

12/26/2018

"Sqllite "

3.5/5

What do you like best about SQLite?

Very lightweight file-based database. Can be installed on multiple servers as it's just a file. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

file lock when read. This has a limitation that whenever the DB is being accessed it's locked even for reads. Review collected by and hosted on G2.com.