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.

David F.

Guest Scientist Los Alamos National Laboratory

Information Technology and Services

Enterprise (> 1000 emp.)

12/27/2017

"Simple SQL application"

3.5/5

What do you like best about SQLite?

small footprint, easy to use. It provides most of what is needed for a simple SQL interface. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Doesn't implement enough SQL commands. so some SQL commands can't be used. Review collected by and hosted on G2.com.

Verified User in Higher Education

Small-Business (50 or fewer emp.)

7/31/2017

"Small, fast, and easy to use database"

4/5

What do you like best about SQLite?

SQLite's most attractive feature is that the database is contained within a single file, so it's very easy to set up and test against, as well as migrating to other machines or platforms. It's also a surprisingly fast database, especially for queries. Finally, it has an excellent Python interface for integration into programs. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

SQLite lacks many fancy features of bigger database engines, such as stored procedures. It also doesn't handle concurrent writes very well (although reads are OK), so it wouldn't be a good choice on a heavily used website, for example. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

SQLite.org has a great page about the features and limitations of the product to see if it's right for you. However, it's quite easy to migrate data between SQLite and other engines (PostgreSQL or MySQL) so it's worth trying even if you're not sure about it. Review collected by and hosted on G2.com.

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

Some problems are solved quite naturally using SQL, so we store data in a local SQLite database and perform queries against it. The data are generally static for long periods so we're more concerned about handling concurrent reads rather than concurrent writes. Moreover, the query speeds in our experience are as good as PostgreSQL or MySQL without the management overhead of a full RDMS. Review collected by and hosted on G2.com.

Verified User in Computer Software

Mid-Market (51-1000 emp.)

4/4/2018

"Easy to use"

5/5

What do you like best about SQLite?

Very simple and can be learnt in a short period Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Better ui can enable a more friendly experience Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

12/21/2017

"Very useful for mobile development"

4/5

What do you like best about SQLite?

Very powerful can create views and triggers Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Nothing as such. More in terms of writting stored procedures and functions if possible Review collected by and hosted on G2.com.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

11/30/2017

"Used in conjunction with visual studio and works great. "

4.5/5

What do you like best about SQLite?

It became part of the package when developing websites. Allowed for quick connectivity without needing to load up a separate server. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Set up for me repeatedly produced errors. Finding a solution took a fair amount of time. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Highly recommended for use with visual studio Review collected by and hosted on G2.com.

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

I have used this when developing websites, it is a ideal solution when running on a single device. Doesn't require a server running in background draining resources. Review collected by and hosted on G2.com.

Verified User in Retail

Small-Business (50 or fewer emp.)

1/10/2018

"Lightweight and quick"

4.5/5

What do you like best about SQLite?

I prefer lite so alternatives like mongodb and postgre. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I love using CLI but I'm not s huge fan of SQLite CLI. Review collected by and hosted on G2.com.

Verified User in Financial Services

Small-Business (50 or fewer emp.)

1/13/2018

"Good for a singleton application "

1.5/5

What do you like best about SQLite?

SQLite is easy to use and powerful when embedded in applications Review collected by and hosted on G2.com.

What do you dislike about SQLite?

There are very limited options for scaling Review collected by and hosted on G2.com.

Leonardo S.

Junior Developer

Transportation/Trucking/Railroad

Small-Business (50 or fewer emp.)

10/28/2017

"Simple, small and efficient"

5/5

What do you like best about SQLite?

The simplicity of having a database of easy access and locomotion since all this is done through a single file. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Problems of performance, I use for big project e it's is slow for big projects. Review collected by and hosted on G2.com.