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.

Carlos F.

Mid-Market (51-1000 emp.)

10/10/2018

"SQLite"

4/5

What do you like best about SQLite?

Light and fast for small developments Review collected by and hosted on G2.com.

What do you dislike about SQLite?

It lacks many functions that other languages have. Review collected by and hosted on G2.com.

Verified User in Health, Wellness and Fitness

Small-Business (50 or fewer emp.)

12/12/2018

"Very easy to use and effective"

5/5

What do you like best about SQLite?

I like how it is very easy to use and deploy Review collected by and hosted on G2.com.

What do you dislike about SQLite?

It is very hard to find other other APIs that open its filetype Review collected by and hosted on G2.com.

Diana P.

System Engineer

Management Consulting

Mid-Market (51-1000 emp.)

1/21/2018

"I like SQLite"

4/5

What do you like best about SQLite?

I like SQLite because it is easy to install it and easy to use it. The updates are also easy to install without losing my old progress. It is compatible with my python. With the base information that I had about SQL, I could make many decent tasks with SQLite. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I don't have a profound learning of the database programming and is hard for me to tell you about bad things. At the moment I don’t have bad experiences with SQLite. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

You don’t need a technical background in SQL language for this tool. Review collected by and hosted on G2.com.

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

I utilized SQLite for some big projects in my company. I sorted out many separate information like tables and columns I made the relations to each other utilizing python and SQLite. The result was a great database. My company got a fluid database and it’s working without gaps.

Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

1/3/2018

"If you a Android developer then SQLite would be the route to take. "

5/5

What do you like best about SQLite?

For starting on Android Platform, SQLite would be the best for any kind of storage whether it is images, urls, data entry etc. As the name suggests, it is a lite version of the actual SQL which we have learnt right from our engineering days. However it is pretty vast for any kind of storage you looking for in your application. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

SQLite was the traditional method for storing data using relational database. Now that we have many different database formats like NOSQL, PostGress, even for Android we now make use of Realm database as it has similar operations like SQLite but much more robust and easier to implement. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

If you starting fresh on Android then go the SQLite route...once you become pretty efficient, you can them move to further simplified databases like Realm Review collected by and hosted on G2.com.

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

We had to build a banking application for use by one of the Fortune 500 companies who have billions of accounts under their hood and since we had to store huge lot of data, SQLite was the one which we happened to implement and we were easily able to scale that to millions of customers. Review collected by and hosted on G2.com.

Laura E.

Analista - programadora

Small-Business (50 or fewer emp.)

7/30/2018

"Review SQLite"

3/5

What do you like best about SQLite?

The best thing is that it is a free and portable program, perfect for any small program. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

To make larger programs, it becomes somewhat tight when making the queries. Review collected by and hosted on G2.com.

Nexus W.

Web Developer

Internet

Small-Business (50 or fewer emp.)

7/30/2018

"Convenient portable functionality that works with a number of use cases"

4.5/5

What do you like best about SQLite?

SqlLite is easy to use, portable and performant. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

SQLite is not for every use case, and has limits. Although fast, it can not be used by more than one user at a time. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Small-Business (50 or fewer emp.)

11/29/2018

"A strong system to build with "

3.5/5

What do you like best about SQLite?

The price and features you get with it , along with the easy install Review collected by and hosted on G2.com.

What do you dislike about SQLite?

The support when some obscure issues happened Review collected by and hosted on G2.com.

Andrew F.

Company Owner

Defense & Space

Small-Business (50 or fewer emp.)

1/11/2018

"Becoming the de facto built-in RDBMS solution for in-app storage needs. "

5/5

What do you like best about SQLite?

SQLLite is a robust, one file solution. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Based on its usecase nothing to dislike. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

If you’re looking at using SQLite then you know why you want to use it. It’s robust enough to be relied upon for what it is. It does not support multiple connections but this is basically a infinitely better solution over using the Jet driver.

Good for mock testing, localized microservice storage and local app storage. Review collected by and hosted on G2.com.

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

In-App Structures Storage.

Comes preinstalled on almost all modern Operating Systems. Windows 10 and OS X now ship with it. And it’s easy enough to embed if needed. The only down side is the likelihood and needing to compile it yourself is sometimes high. But it’s a single source file if SSL isn’t used. It’s easily embedable and makes for a robust Loca User/Session storage mechanism. Would not use for mission critical data storage. Review collected by and hosted on G2.com.

Daniela C.

System Engineer

Information Technology and Services

Enterprise (> 1000 emp.)

12/23/2017

"The best tool for your mobile apps"

4.5/5

What do you like best about SQLite?

SQLite is anything but difficult to introduce and utilize. There is likely no better database for tenderfoots to begin finding out about running and utilizing a database. This likewise settles on it a brilliant decision for persevering information in an improvement domain. The speedy setup and convenience shield it from being a blocker for setting up an advancement situation. SQLite has a phenomenal documentation. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

It isn't appropriate to expansive scale applications. It is intended for lightweight frameworks, not for big business applications, or applications that need to scale essentially. It additionally does not have a few highlights of the bigger scale databases like MySQL including security, consents, and sort highlights. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Realize what you require from a diligent information source. On the off chance that you are searching for something lightweight and simple to utilize, this is an incredible choice. Review collected by and hosted on G2.com.

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

I have utilized SQLite to endure information being developed conditions where I am not as worried about execution or highlight issues. It works awesome for this reason since you can get steup up rapidly, and get into the real advancement work. Review collected by and hosted on G2.com.

Verified User in Higher Education

Enterprise (> 1000 emp.)

6/12/2018

"Relatively easy to use even for first-timers"

4.5/5

What do you like best about SQLite?

I like the options SQLite gives to allow for command line interface as well as the different platforms supported (ie., Windows, Mac and Linux). Also because of its “lite”ness I can analyze rather large datasets and files efficiently. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Like all programming, there is a learning curve requirement for using SQL, however it is not a huge drawback. I do wish there was more documentation to help with commands Review collected by and hosted on G2.com.