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.

Verified User in Computer Software

Enterprise (> 1000 emp.)

1/23/2019

"Light and easy to use"

5/5

What do you like best about SQLite?

1. No configuration is required. This makes IT person life easy.

2.It is portable, which means it can go with you anywhere. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

1. Because it doesn't have a server, it is not possible to access through network.

2. User doesn't have a freedom to manage. Review collected by and hosted on G2.com.

Verified User in Oil & Energy

Mid-Market (51-1000 emp.)

1/10/2019

Business partner of the seller or seller's competitor, not included in G2 scores.

"Best for educational purpose"

4.5/5

What do you like best about SQLite?

The ease of use , UX and UI. Very relevant to the industry. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Nothing in particular. It is all good as of now. Review collected by and hosted on G2.com.

Verified User in Computer Software

Mid-Market (51-1000 emp.)

2/20/2019

"Best light weight database"

5/5

What do you like best about SQLite?

Easy to setup and integrates well with other tools Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Documentation should be improved and there is not much to dislike. Review collected by and hosted on G2.com.

P R.

Head of Software

Mid-Market (51-1000 emp.)

7/31/2018

Business partner of the seller or seller's competitor, not included in G2 scores.

"Indispensable tool for mobile development"

5/5

What do you like best about SQLite?

Lite - there's a reason it's called that. So tiny and lightweight a footprint that it always comes first when wanting a database solution for an offline database. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Very little - possibly Entity Framework's implementation is restrictive, but that's a Microsoft issue TBH. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

11/3/2018

"Powerful tool"

4/5

What do you like best about SQLite?

Quick and easily available tool to store data. Good to use for debugging and optimizing your code. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

It lacks built in data encryption and cannot be used in multi user database management system. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

You can use it if you are not really that comfortable with SQL server management studio. My first preference would always ebe SSMS. Review collected by and hosted on G2.com.

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

Used it for generating huge amount of data for further analytics with reports and dashboards. Review collected by and hosted on G2.com.

Ryan G.

Advanced Clinical Applications and Analytics Coordinator

Hospital & Health Care

Mid-Market (51-1000 emp.)

7/30/2018

"SQL Lite is perfect for mobile devices, quick/easy DB jobs"

4/5

What do you like best about SQLite?

SQL Lite essentially gives you the full functionality of standard SQL--with very little configuration. It's nice and compact, quick to install and will have you database exploring in no time. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

It does lack some of the depth of standard SQL however rich it is for a small compact version. I've had some issues with load times as well occasionally. Review collected by and hosted on G2.com.

Chris S.

Assistant Information Systems Specialist

Small-Business (50 or fewer emp.)

2/15/2018

"Easy to use and easy on resources server side "

5/5

What do you like best about SQLite?

It allows a lot of reads and writes simultaneously and when you have an entire office accessing your database at once, caching and parallel access is essential. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Loading UI elements on the screen takes a long time on older computers. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

One thing to consider when using SQLite, is when you draw tables on a GUI, it will take a considerable amount of time for on screen elements to load unless you choose to have all items load in parallel. This requires a more robust workstation video card, but items will load more efficiently Review collected by and hosted on G2.com.

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

Running SQLite has allowed the doctors office I set up to move from traditional filing to e-filing on computers. This saves a tremendous amount of time. The benefit of SQL compared to CSV tables is obvious. The only factor in efficiency is the server bottleneck. When you use CSV tables or other types of database access, many times only one person at a time can access the data. However SQL is scalable and multiple sessions are supported with incremental changes allowed. Review collected by and hosted on G2.com.

Suzanne M.

Enterprise (> 1000 emp.)

9/21/2018

"Great and easy to use!"

5/5

What do you like best about SQLite?

Easy to help customers with in the webhosting account. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Can't think of anything. We didn't have it originally when I was doing tech support for hostgator but its a great database tool. Review collected by and hosted on G2.com.

Ankit J.

Enterprise (> 1000 emp.)

4/27/2018

"Fast and Reliable"

4.5/5

What do you like best about SQLite?

A very powerful, embedded relational database management system. Best thing about SQLite is that when an application uses SQLite, the integration works with functional and direct calls made to a file holding the data rather than communicating through an interface of sorts Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Lack of possibility to tinker with for additional performance and No No user management for SQLite because of their use case. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Just make sure you use it just to learn SQL and not to deploy some application with this as it is light weighted with no user management. Review collected by and hosted on G2.com.

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

I practice SQL queries on SQLite as it is light weighted and does not require you to do necessary stuff and makes your life easy while learning. Review collected by and hosted on G2.com.

Verified User in Insurance

Enterprise (> 1000 emp.)

11/27/2018

"Compact and Simple Database Engine"

3/5

What do you like best about SQLite?

Even though it is not a full featured database engine, it supports majority of relational and sql standards. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Not all data types and joins are supported. Sometimes referential integrity is compromised when multiple users are making changes. Review collected by and hosted on G2.com.