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.

SQLite Reviews (260)

View 1 Video Reviews

G2 reviews are authentic and verified.

Here's how.

Vilok L.

Assistant System Engineer

Enterprise (> 1000 emp.)

8/30/2019

"SQLite review"

5/5

What do you like best about SQLite?

The best thing is it is lightweight ,no network access and it is standalone database Review collected by and hosted on G2.com.

What do you dislike about SQLite?

The security features are not well equiped Review collected by and hosted on G2.com.

Alan I.

Gerente de Consultoria ABAP

Small-Business (50 or fewer emp.)

1/18/2019

"I try to use it but is almost imposible"

1.5/5

What do you like best about SQLite?

More than a like is the need to use it , was a database from another software i was trying and has a type of file than only aceppt this IDE , to install is pretty simple and super lite , has a free version and that would be the best of this. Does not consume much disk space so can be install in almost any server o machine. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

This is the first time a dislike a lot a software , sorry for the users of this but my opinion is base on my expirence because as i said , the database file a try to open was only manage by this, but i was terrible to work , to see just a table has to go over 3 screens and does not show al the data , make a query was really weird to do , was almos like working with excel . Is not compatible with more complex data types Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

If you have to use it like me , use it just as last resort , was a pretty bad expirence , i think the developer team should get more practical with this software Review collected by and hosted on G2.com.

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

Just to open a mobile aplication database , no more no less, the benefits are that is really lite , and fast instalation , and was the provider choise to use this tool instead of other more efficient but is not the best for the job. Review collected by and hosted on G2.com.

Rahul A.

Full Stack Web Developer

Information Services

Small-Business (50 or fewer emp.)

1/18/2019

"SQLite is a great relational database management system for electronic devices like cell phones, etc"

5/5

What do you like best about SQLite?

SQLite creates complex databases in the form of a single file with a size of hardly 500-700kb even though the database is too large. As compare to SQL server or any other RD system SQLite is lightweight and easy to implement and connect, as per my consideration.

SQLite file manages all data in the form of object data-type. All the tables, relationships, events, data, and everything is stored and managed in one single file.

As per my recommendation, SQLite is best option for portable devices for storing and accessing offline database. Devices like cell phones, video recorders, wifi routers, etc those need some database. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I have no dislikes as of now for this product Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

SQLite gets integrated to any development environment with ease if having proper knowledge. From a large community support online it is very easy to learn. Use this light weight database system for offline devices and applications. Review collected by and hosted on G2.com.

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

It helps in database solutions for many applications especially for mobile applications. We have developed many Android apps which uses SQLite as a database system. The great ability of relationships between entities is also helping in managing the database dynamically, a very important part of any Relational database out there, so SQLite has everything in a small bundle.

Secondly, we won't require any online server or dedicated server to keep and manage databases, yes in case of backups are use cloud storage but that is totally optional. Review collected by and hosted on G2.com.

Brad R.

Database Administrator

Mid-Market (51-1000 emp.)

1/17/2019

"Lightweight, Low Cost, and Easy to Use"

5/5

What do you like best about SQLite?

One of my favorite things about SQLite is the community behind it. The fantastic SQLite team provides incredibly solid docs and examples. The SQL syntax support is excellent and more importantly, well documented. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Honestly, there's not much to dislike about SQLite. Older versions had some quirks that required strange workarounds (like not being able to alter a table, so you had to clone it, drop it, and create a new one - it was weird). But in recent years, things are in great shape. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

SQLite is an excellent choice for a fast and stable database, especially in a local, single-user environment. There are projects out there to enable network use as well, but it really shines as a local database. Review collected by and hosted on G2.com.

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

We have an ancient AS/400 that we still use for just a few functions (it's being phased out, but that takes time). Some people in our business office and human resources department need to run reports on that data, but those reports require dozens and dozens of queries, which can get very bogged down with a web front end to the AS/400. So we pull that data into a local SQLite database on each user's computer and run the reports locally - it's blazingly fast. Plus, I can build a custom desktop UI that's very easy for each person to use. Review collected by and hosted on G2.com.

Verified User in Banking

Enterprise (> 1000 emp.)

3/27/2019

"Best Portable Database"

4.5/5

What do you like best about SQLite?

SQLite is known for being lightweight, robust and reliable at the same time. Since it is serverless, you don't need to install it or keep separate space for it. It's a standalone relational database which is ideal for mobile platforms whether IOS or Andriod. The syntax or query language of SQLite is quite easy to understand and you can go through their docs or online portals to find many examples and tutorials for the same. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I think most of the people face this problem that it is not a multi-user database application which restricts it to a single user writing at a time. It also lacks some of the basic functionality that other competitor software provides like different Joins and Stored Procedures call. It is primarily used in our development cycle but it's not well suited to handle Enterprise level databases. Review collected by and hosted on G2.com.

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

We use it for all our development projects where the data is not that huge and a strict Timeout period is not applied to the database call. It gives us the data in a structured form in tables and that too in a size under 1 Mb. It doesn't require any space or server for installation. So, saves a lot of physical space and CPU resources. Review collected by and hosted on G2.com.

Aanu B.

Assistant Consultant

Small-Business (50 or fewer emp.)

6/27/2019

"Good lightweight database management system"

4.5/5

What do you like best about SQLite?

- Good for lightweight databases that do not require a full-fledged server (like android) Review collected by and hosted on G2.com.

What do you dislike about SQLite?

- Since it runs on a single computer, it does not have full functionality that most databases have (like indexing or handling large data sets) Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Small-Business (50 or fewer emp.)

9/11/2019

"One of the best database app."

4.5/5

What do you like best about SQLite?

SQL lite one of the best server for use globally and user can use this server free globally.

SQL lite provides a secure database platform for everyone. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Sql lite not supported the maximum programming language, like php wordpress. Review collected by and hosted on G2.com.

Michael C.

Test Engineer Intern

Hospital & Health Care

Small-Business (50 or fewer emp.)

5/17/2019

"Great relational database"

5/5

What do you like best about SQLite?

This is a great relational database that suits most needs for a database. Response times are fast and integrating is a breeze. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

There's nothing to dislike about SQLite aside from its pronunciation, which is SQL Lite (or sequel lite). Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Consider other SQL apps as well such as PostGreSQL and MySQL. Review collected by and hosted on G2.com.

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

I no longer have to create a new data structure for each data storage problem. A relational database solves most data storage issues for most computer systems. Review collected by and hosted on G2.com.

Verified User in Banking

Mid-Market (51-1000 emp.)

9/23/2019

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

"My review for sqlite"

4.5/5

What do you like best about SQLite?

It execute the query very fast. All the major. Functionality are available.. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

As such I don't dislike anything about sql lite Review collected by and hosted on G2.com.

Apurv D.

Engineering Manager

Information Technology and Services

Enterprise (> 1000 emp.)

12/7/2018

"SQLite - Easy, Light Weight and Reliable way to Store Data"

4/5

What do you like best about SQLite?

1. As Sqlite is serverless tool, It requires no effort for setup and configuration.

2. It is very simple and so easy to learn.

3. It is supported on mobile OS as well. For iOS and Android application local data storage, SQLite is the best option.

4. As it makes only one file, it is really easy to port from one platform to other. This specially helps to test your product across different mobile platforms.

5. It has excellent documentation and community support. Most of the time, you can solve the problem on the tip of finger.

6. Now a days, many tools with great GUI available which makes it even easier to work with. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

1. It has not sufficient types to handle decimal numbers. Sometimes you may have precision loss.

2. It is designed for single user and small scale applications. So for enterprise grade application, it is not suitable.

3. Store procedures are not supported.

4. No built in support to encrypt data which causes security issues (however many open source wrappers available to encrypt data stored in SQLite file). Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

If the size of data is limited and is not suppose to be grow after certain level, SQLite is great. It is a De facto standard of storage for Mobile application. So, for iOS and Android applications, I highly recommend SQLite to persist data. Review collected by and hosted on G2.com.

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

We use Sqlite mainly to develop mobile applications. When mobile applications need to store relational data into local device itself, SQLite is the best choice. iOS has its native wrapper called Core-Data which also provides simpler way to store data on SQLite database. In a way where server and enterprise features are not required (specially for research and basic data analysis is required) , we use SQLite. Review collected by and hosted on G2.com.