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.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

12/15/2017

"SQLite the small and fast database engine for web and mobile applications"

5/5

What do you like best about SQLite?

SQLite is the fast ad small database, ideal for small or big application (web, mobile, server or desktop).

Don't require a server software and the DB file is portable to other platforms (Windows, UNIX, etc).

Most popular software use SQLite (eg. yum repositories, Firefox, Tenable, Android, etc.)

Cover most of SQL syntax and it's possible to create table, view, index, virtual table (eg. from a csv file or from a directory) and custom functions (via programming language).

SQLite is supported by PHP5, Perl, C, Tcl, C++, C#, Python, Rust, and more programming language. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

SQLite not offer built-in security facility (eg. login, ACL and encryption) Review collected by and hosted on G2.com.

Anand V.

Enterprise Information Technology - Communication - Architect | Consultant | Auditor | Trainer

Mid-Market (51-1000 emp.)

3/6/2021

"Excellent featured and scalable relational database"

5/5

What do you like best about SQLite?

Good tools for client/local storage for applications software.Also best used for embedded systems Review collected by and hosted on G2.com.

What do you dislike about SQLite?

There is nothing I dislike about the product Review collected by and hosted on G2.com.

Ilyas A.

Teaching Assistant

Small-Business (50 or fewer emp.)

11/28/2020

"Good but lightweight and is local"

4.5/5

What do you like best about SQLite?

It is very fast and requires very less space to actually store data. That is the reason why it is used in android. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

It cannot be used to sync with other apps or databases as it only works locally in the device Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Use Google Firebase instead. It will save a lot of the sync and connectivity issues. Review collected by and hosted on G2.com.

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

Benefit is that it is very fast because it's memory overhead is quite low and can be accessed by low memory/processor devices like mobile phones Review collected by and hosted on G2.com.

Verified User in Automotive

Small-Business (50 or fewer emp.)

4/20/2021

"Good for fast on the fly and client side mostly"

4/5

What do you like best about SQLite?

Lightweight and easy to use on multiple platforms Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Scalability. I can't use it across multiple servers as i would like without fuss. Review collected by and hosted on G2.com.

Nasrullah N.

Application Developer

Mid-Market (51-1000 emp.)

7/28/2020

"Light weight Database"

4/5

What do you like best about SQLite?

Great data storage Used for android development which is lighter and best use of queries to retrieve data the way we wanted Review collected by and hosted on G2.com.

What do you dislike about SQLite?

SQLite has become old while new DB has being introduced in the today’s world where SQLite usage has dropped in development Review collected by and hosted on G2.com.

Randall M.

Site Reliability Engineer

Enterprise (> 1000 emp.)

8/11/2020

"Great database for modeling and rapid development"

5/5

What do you like best about SQLite?

Already installed ready to use rapid stand up rip and tear down stores everything is local files Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Scaling can be difficult , security features are linited Review collected by and hosted on G2.com.

Mohit T.

Software Developer

Small-Business (50 or fewer emp.)

9/2/2019

"SQLite a complete architecture to store locally on mobile or small end devices"

4.5/5

What do you like best about SQLite?

One of the important thing in my point of view is that, its lightweight database as compare to other option available for small end system or mobile devices.

It gives better performance as well, means reading and writing from the database table is very swiftly possible with the SQLite Database, which is a good thing.

You don't have to worry about installation and other stuff regarding the configuration of database. It will configure we less headache.

One another important thing is that its portable from one device to other without any extra configuration or migration process. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

By the all the features and facility provided with SQLite is until is sufficient because its open source free version which already gives lot of things for developers.

The one thing which I want to show here is that they must increase its capacity from 2 GB to more. and also improve the HTTP request and response with the SQLite database. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Yes, I really recommended SQLite for using in mobile application as well as in Embedded system where storage facility is less but we have to store some permanent things, like settings or flags or etc.

It may help to sync important data when user comes under network coverage to give them better services. Review collected by and hosted on G2.com.

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

First thing I solve with the SQLite , get rid or storing large data related to application storage.

Another thing is that storing offline some content which is useful when travelling or user has low latency network coverage so he can offline some content.

Synchronization is another important factor comes when we are using such database. Review collected by and hosted on G2.com.

Sachin S.

UI/ UX Designer

Small-Business (50 or fewer emp.)

8/27/2019

"SQLite A way to sync mobile and Web"

4.5/5

What do you like best about SQLite?

SQLite allows to store data on mobile storage devices, which means we can store the data in more like SQL format in SQLite.

Local storage means that we can get more control on data in the same device as compare to getting data from some external source like from the server side. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

What I don't like in SQLite is that we can't store large amount of data in the database.

The reason to this we can't hold large amount of data because if we hold data then it may be loss because of the device storage capacity. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Yes I would be recommended when you want your application sync with your server database its good to have control over the device as well as the server.

Its nice to get the syncing process very easy with local mobile data and the with server based database

And the good thing about this is its totally free to use we don't have get the licence of it to use it. Implementation of SQLite is too easy and get the work done very conveniently. Review collected by and hosted on G2.com.

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

First it allows to sync the database remotely, it also useful to get the locally data over the server when we in contact with Internet.

It is also useful to store temporary settings till not uninstalling the application.

It gives facility to get rid of low network latency problem while we cant to do the communication with the network. Review collected by and hosted on G2.com.

Nadeeshani B.

Student

Mid-Market (51-1000 emp.)

8/3/2019

"The most reliable SQL database platform"

4.5/5

What do you like best about SQLite?

The most used database in the world. It is very easy to get to learn even though you are new to learning SQL databases.Gives you fast access if the storage is enough. It can run on any machine and very smaller amount of space is taken to install.Much more comfortable in learning SQL based operations with SQLite. The most efficient one is that its cross- platform. If you are a student and want to learn SQL relational database management SQLite gives the best experience. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

There is not much to dislike about it. Sometimes the space will not be enough for larger companies. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

I highly recommend to use SQLite if you are using a relational database for your projects. Review collected by and hosted on G2.com.

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

As a student studying in the database management field I almost used every database and among them SQLite gave me the best experience. Very easy to get into relational database and very fast when working. very easy and efficient to integrate with other IDEs. I Used SQLite for both my netbeans shopping mall management system project as well as my android mobile application. Review collected by and hosted on G2.com.

Román Josué d.

Data Scientist

Enterprise (> 1000 emp.)

5/18/2019

"SQLite is really light!"

4/5

What do you like best about SQLite?

I like to use SQLite for being able to use a relational database management system without requiring too much resources. The first time I got in contact with SQLlite was when I was developing an Android mobile application and wanted to know if it was possible to include a database there. I found out that you can use a SQLite database on an Android mobile app. It's pretty simple to use if you already know SQL, it's a very light database for the App (which is something desired for an app), and the setup is simple. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I don't like that the purpose is too narrow for this application to work only with small databases. However, this is understood and balanced, as being "lite" specifies the purpose of SQLlite. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

SQLite is a gread and solid choice for Android mobile developers if they want to use a "lite" SQL database with their application. Review collected by and hosted on G2.com.

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

Being able to access the power of SQL with a lite approach is great for mobile apps, apps which require low use of space, or low memory. Review collected by and hosted on G2.com.