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.

Allyson I.

Web Developer (University Communications)

Higher Education

Small-Business (50 or fewer emp.)

9/10/2019

"SQLite is beneficial for those without a coding background"

4/5

What do you like best about SQLite?

I like how this product makes it easy for anyone to use sql. I used it to integrate a database into a website and it worked wonderfully. I am familiar with sql but a lot of people in my group weren’t and this was helpful for them. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

The software looks a little outdated. I think that you could make the interface prettier and have little information icons that you can hover that explain what each thing is. It would be nice to have an online version and not just the software you have to download. Review collected by and hosted on G2.com.

Marcio d.

Enterprise (> 1000 emp.)

7/16/2019

"Using SQLite in desktop applications"

2.5/5

What do you like best about SQLite?

Sqlite is very small database, with limited resources but, can be used to store internal configurations, replacing a XML file or txt configurations files, with great advantages.

You can use ANSI sql commands to search for data, making more easy this tasks.

The small size and his easy installation on any machin, make the SQLLite a good choice. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

One thing that i dislike was the frequent corruption files, when have a lot of inserts and deletions in database. We need keep a backup ready to use in this situations. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Avoid use sqlite with big amount data. have a high risk of crash in files Review collected by and hosted on G2.com.

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

I replace all XML config files in my system, putting inside the sqlite. Is more easy keep all configurations in a database, and make only one backup for all. Review collected by and hosted on G2.com.

Andy Larry R.

Informaticien études et développement

Small-Business (50 or fewer emp.)

5/20/2019

"Lightweight and powerfull embed database"

4/5

What do you like best about SQLite?

- Easy to setup and configure

- Really fast to setup and to maintain

- Very lightweight and usable for embedded applications

- Open source and free to use

- Very efficient and suitable for speed programming

- Universal relationnal database language (SQL) Review collected by and hosted on G2.com.

What do you dislike about SQLite?

- The database is store on file system which increase hacking risk

- Need more optimisation to work with application which use multithreaded tasks.

- Not suitabe for big data and datawarehousing (Business intelligence module) Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

- Best for data storage within mobile applications

- Really easy to use and no need to be an expert

- Really fast for mobile application data transactions

- I really recommend SQLite for anyone who want to build mobile application as fast as possible. Review collected by and hosted on G2.com.

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

- Data storage for embedded application such as Android apps or IoS apps.

- Local data storage for mobile application (offline data manipulation after remote data synchronization)

- Remote data synchronisation of web apps and mobile apps Review collected by and hosted on G2.com.

Mahesh K.

Software Engineer

Enterprise (> 1000 emp.)

1/15/2019

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

"Lite Database with awesome feature"

5/5

What do you like best about SQLite?

The best feature of sqlite which I like most is its very light weight with all the feature of RDMS (relational database management system) . This database is very easy to integrate with any application. It can be used with from small to heavy applications because of its nice features. SQLite is structured query based tool which support all the queries of relational database. It has schema based database.It is very easy to maintain database system. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

The things which i dislike in the sqlite is it have less support for any issue. It is not supported some function which we used in other RDMS systems like truncate that's why we have to use delete in the sqlite. In the addition it is not support database size more than 1 GB so we can't use for huge applications. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

As sqlite has great feature of RDMS I will recommend this tool to my all of friends & colleague so that they also can get benefits of sqlite which i got. Review collected by and hosted on G2.com.

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

In our organization we have multiple web & other desktop application and we have to maintain backend database so in this way sqlite help us the most. It resolved the many problems for backend database. It is more easy to maintain other than RDMS. Because of its great feature we switched to sqlite for our many applications. In addition it is very cost effective tool so that we can get this easily.

It have many benefits which help the our organization to perform in more effective way & faster our backend query system. Review collected by and hosted on G2.com.

Ali N.

Mr.

Mid-Market (51-1000 emp.)

7/26/2019

"very useful to create and manage databases"

3.5/5

What do you like best about SQLite?

It is very simple to share databases. Just copy one file to do so. This is what makes it easy for me to provide you with the essential SQL sample database. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

SQLite doesn’t support the date or timestamp data types. This is a disadvantage as many SQL puzzles, thus learning opportunities, are out of our reach in the beginning. Review collected by and hosted on G2.com.

Verified User in Animation

Small-Business (50 or fewer emp.)

5/22/2019

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

"Database server"

5/5

What do you like best about SQLite?

Sqlite database server with this application user can make any kind of application like website or mobile application. If user going to make mobile application and user can use this server and make database programmatic. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

This application will not work for high amount of value of data. Because it is not easy to handle big data amount. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

It is good application to use for mobile and website application. you can develop any kind of application and make your automatic mobile application database. Review collected by and hosted on G2.com.

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

I solved many problem with mobile application or website server. this had helped my site to make it done with fast. It good with process and make your application great. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

9/23/2019

"Simple And Stable "

4.5/5

What do you like best about SQLite?

Open source database used by applications due to its compact size, cross platform stability and server less functionality. Easy to integrate and easy to migrate is one of the best advantage of SQLite. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

As compare to object oriented DB its performance is quite back word. Review collected by and hosted on G2.com.

Verified User in Internet

Small-Business (50 or fewer emp.)

11/25/2019

"Awesome alternative for storing your data locally"

4.5/5

What do you like best about SQLite?

You don't have to have a server and active network connection in order to use sqlite Review collected by and hosted on G2.com.

What do you dislike about SQLite?

It is not optimised for advanced calculations and heavy i/o, but if you know that, you should implement something more advanced. Review collected by and hosted on G2.com.

Chintan D.

Small-Business (50 or fewer emp.)

8/30/2018

"Simple and Performant"

3.5/5

What do you like best about SQLite?

SQLite offers very simple database solution. It is very generic and switching to another system is relatively easier. It's very easy and painless to setup. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Simplicity comes at a cost of performance. It is not the most performant database. Review collected by and hosted on G2.com.

Evaristo C.

abogado

Small-Business (50 or fewer emp.)

1/28/2019

"Very bad performance"

0.5/5

What do you like best about SQLite?

is lite and do not consume much rosources of the device. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

1.- Is only compatible with android devices

2.- It does not have consistency with other type of data elements

3.- It does not display tables as a database manager , is more like a excel

4.- It does not have a query executor

5.- Only works on windows

6.- Is almost not infomation at all for this Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

if you must use the tool , beware that is going to be a big problem to read and write data outside the android aplication. For the people of SQLite , try to focus on the user , no matter is a It people tool , but does not have to be this problematic , you should reconsiderer the UI , the query language and finally the integration with diferents Operating Systems Review collected by and hosted on G2.com.

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

i'm developing an android aplication and was runing on a emulator but i want to see de data that was store in the device emulator but it was pretty dificult to read and obtain the data . I used because of hos low consuming requeistes and for trying a new tool Review collected by and hosted on G2.com.