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.

Suraj D.

Embedded Software Engineer

Enterprise (> 1000 emp.)

12/7/2017

"Database for small storage purposes"

4.5/5

What do you like best about SQLite?

The best thing is light weight, Not too much big footprint. This can easily utilized in small memory projects. Like embedded system applications are good fit for it.

I like the best all SQL queries are valid in it. You will feel like working in SQL. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I had interface with C++ so i don't like the long connection strings. If hard to debug , keep track of the open and to close the all open connections,, otherwise can be different behavior. Review collected by and hosted on G2.com.

Verified User in Higher Education

Enterprise (> 1000 emp.)

7/31/2018

"Optimal DBMS "

4.5/5

What do you like best about SQLite?

Easy to use, secure and fast. SQLite is the most popular database engine. ACID properties are critical for transactions. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Rigid structure, unlike MongoDB which is flexible and unstructured. Review collected by and hosted on G2.com.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

12/27/2017

"The perfect solution for reliable unit tests"

5/5

What do you like best about SQLite?

SQLite is hands down, the simplest databse engine in the market. It is definitely not scalable but an essential tool in the software development process. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

The lack of visual development tools may make it hard for newcomers but it is still simple enough compared to the alternatives. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

There are for sure many use cases for SQLite, but make no mistake, as a tool for unit testing is where it shines. Give it a chance and replace all you database and sql query mocks for real database interaction in your unit tests and you will be able to measure the increase in your software quality. Review collected by and hosted on G2.com.

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

We use SQLite exhaustively for unit testing the data layer of a very large codebase and it has proven to be the best choice. The overhead is minimum and the benefits are enormous compared to other techniques, such as mocking or using stubs. Not having to rely on an external DB component, gives us faster deploy times and streamline our continuous integration efforts. Review collected by and hosted on G2.com.

Verified User in Chemicals

Enterprise (> 1000 emp.)

12/28/2017

"Can't Beat Free But Tread Lightly"

3.5/5

What do you like best about SQLite?

That it's free and small to implement. Great for mobile development and has a large user case and community. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

That it can't support Stored Procedures and can be very difficult if you are going to have multiple processes accessing your data at once you are going to have a bad time. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

If you are considering SQLite for mobile development then I would stop considering and pull the trigger. It's similar to SQL and the feature is pretty great for a free alternative. Review collected by and hosted on G2.com.

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

The business problems I solved with SQLite are that I have a database I can use, for free when developing brand new mobile apps. It's very similar to SQL, which I use commercially, and supports enough features that it is a no brainer to use. There really any benefits other then I have a go to when starting a new mobile app that requires a database backend. Review collected by and hosted on G2.com.

Verified User in Commercial Real Estate

Mid-Market (51-1000 emp.)

8/11/2018

"The light database"

4/5

What do you like best about SQLite?

It is the best option for mobile applications. Very easy to use, portable, and very lightweight. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

If you want to do something very complex, you might need another option. Review collected by and hosted on G2.com.

Misagh N.

Biochemistry PhD student and Research Assistant in Computational and Systems Biology

Higher Education

Enterprise (> 1000 emp.)

9/19/2017

"Easy to use and powerful"

5/5

What do you like best about SQLite?

What I like about SQLite is the simplicity of installation process and usage. It integrates easily with my python. With the minimum knowledge that I had about SQL systems, I could easily complete two nice projects with SQLite. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I don't have a deep knowledge of the database software packages and therefore am not qualified to tell what could be better. But from what I experienced, I didn't have any specific difficulty with anything in SQLite software. Review collected by and hosted on G2.com.

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

I used SQLite for two smaller projects in my PhD. I organized many separate data tables of that had relations to one another using python and SQLite. The outcome was super nice, because I could quickly filter through large sets of data and specify a certain relationship and make a subset fulfilling that requirement. Some of these tasks could take a day on my desktop, while using SQLite It could be as fast as minutes. Review collected by and hosted on G2.com.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

7/30/2018

"SQL that works on most of operation systems"

4/5

What do you like best about SQLite?

Easy to install at almost all of devices with different operation systems Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Sometimes is a problem to find current version and SQLite updates with bug fixes Review collected by and hosted on G2.com.

Verified User in Financial Services

Mid-Market (51-1000 emp.)

7/31/2018

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

"Integrates Well"

5/5

What do you like best about SQLite?

I love how easy the product is to use with python Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Storage isnt awesome. Otherwise great product. Review collected by and hosted on G2.com.

Tanim I.

Design Physicist

Research

Enterprise (> 1000 emp.)

1/9/2018

"SQLite can do easy database stuff easily"

5/5

What do you like best about SQLite?

It just works, it's a simple file-based database. The python plugins to SQLite are very high quality. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I can think of nothing I dislike. Sometimes even sqlite is overkill. A JSON file would be sufficient for many of my use cases. Review collected by and hosted on G2.com.