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 Online Media

Small-Business (50 or fewer emp.)

1/25/2019

"SQLite is a Lightweight Databse"

4.5/5

What do you like best about SQLite?

SQLite is easy to use if you are already familiar with SQL. It's deployment is fairly easy. Like the name suggests, it is very light weight, and works best for storing small particularly local data that mimics your large SQL databases. It is free. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

It crashes if you go beyond its storage capacity. You can only use SQLite for small to mid-sized applications. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

The software is free, and that is the biggest benefit. However, ensure you a aware of the storage capacity. SQLite works only with limited amounts of data. It is a light weight software but provides you with the capability of popular SQL databases such as MySQL, and SQL Server. Review collected by and hosted on G2.com.

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

SQLite works great as the backend for simple mobile application or websites. Review collected by and hosted on G2.com.

Dianne W.

ICT Professional

Small-Business (50 or fewer emp.)

4/29/2019

"SQlite is embeddable relational database management system."

4.5/5

What do you like best about SQLite?

SQLite is a very light weighted database and its Read and write operations are very fast for SQLite database. Its portable and accessible through a wide variety of third-party tools. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

SQLite is used to handle low to medium traffic HTTP requests. and the Database size is restricted to 2GB in most cases. Review collected by and hosted on G2.com.

Verified User in Financial Services

Enterprise (> 1000 emp.)

4/23/2019

"Lite but complete"

4.5/5

What do you like best about SQLite?

As the name says, it is liter version of a complete RDBMS with almost all the features. This can be integrated with a variety of ETL tools with ease. Organizing data is very easy across the organization globally. Customer support is excellent and available to answer if there are any issues. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Previous version had few bugs which are now rectified in the latest version. Stored procedures part is kind of tricky with SQLite. Review collected by and hosted on G2.com.

Verified User in Banking

Enterprise (> 1000 emp.)

2/7/2019

""SQLite Great Start to your business!""

4/5

What do you like best about SQLite?

Integrates nicely with .NET (specially Windows Forms) applications, it's really easy to use (specially if you're already familiar with SQL Server) and deployment is really easy (copy/paste required files). Review collected by and hosted on G2.com.

What do you dislike about SQLite?

one more difficulty of software is of knowledge of the SQL language, since there are very complicated queries that I must do and sometimes the tool remains frozen and I have had to restart my machine Review collected by and hosted on G2.com.

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

It's more suited for a start up on a budget since it presents a very good solution for data storage, maintenance and allows database engineers to structure the tables more efficiently and with scalability in mind.

I would say it's less appropriate for bigger companies and firms with a more lax budget. I currently use Microsoft SQL Server management studio and the main reason why we use it is because of its security. Review collected by and hosted on G2.com.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

8/28/2019

"Very Helpful for review my data stored"

3.5/5

What do you like best about SQLite?

The way it handling the data for user to check and review Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I dis not find much flaws in this , if there i will update Review collected by and hosted on G2.com.

Marc C.

Senior Deployment Engineer | Full Stack Engineer

Telecommunications

Mid-Market (51-1000 emp.)

11/16/2018

"SQLite for Android"

5/5

What do you like best about SQLite?

I love SQLite! It's so easy to use and there are tons of information online you can search if you get stuck since it's a pretty common database for mobile phone app development. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I actually cannot think of anything, but i guess i wish there's a GUI to view the data and dont have to code everything just to query something. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

If you want to have a very lightweight, free database when doing mobile phone applications, this is my go to database. You wont go wrong on this one, you have so much information from the internet which can get you going whenever you get stuck. Review collected by and hosted on G2.com.

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

It's a free way to store information in a mobile application. Specially if your'e just starting off and dont have much funds to go big, SQLite is a perfect database and it's so lightweight. Review collected by and hosted on G2.com.

Verified User in Design

Mid-Market (51-1000 emp.)

4/2/2019

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

"developer"

5/5

What do you like best about SQLite?

SQLite is fast, as well as its centralization is awesome. Actually, it is sometimes easily accessible through variety of third party tools which makes SQLite best for me. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

some particular functions are removed which I seriously do not like about SQLite. These functions include, right join, drop column. Also, SQLite is not supported by multi client concurrency. So, omitting all of these makes what I donot like about SQLite Review collected by and hosted on G2.com.

Krishna P.

Blogger

Computer Software

Small-Business (50 or fewer emp.)

2/4/2019

"Simple and light"

4.5/5

What do you like best about SQLite?

It's awsmm and light, really like the way it can integrate. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Documentation can be little better and can add inspiration from nosql database Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

As mentioned above, you have a good market of microservices. You can approch popular framework and create your direct plugin with them, so that it can easily implemented with them and you will get more contributer and users to use Review collected by and hosted on G2.com.

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

Like simple integration with spring framework where I don't want MySQL to be installed. Main advantage it's like mobility. It can easily ship with applications. But I am afraid spring framework e2 storage could take over Review collected by and hosted on G2.com.

Verified User in E-Learning

Enterprise (> 1000 emp.)

7/30/2019

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

"Light weight database and easy to use"

3.5/5

What do you like best about SQLite?

Light weighted process and easy to maintain table and SQL query Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Sqlite should be improved like room database . Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Enterprise (> 1000 emp.)

1/3/2019

"Would like to learn more on SQLite as a part of my project work"

4.5/5

What do you like best about SQLite?

SQLite is a DB engine and the most excited piece of this tool is like this tool is built on C language. This tool has a very good feature to work in mobile applications like us in Pega Platform. The coolest part of this tool is like it is an Open source to public and is free to everyone to use for any purpose. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I don't see any such dislikes for me in this tool. Probably I may have to work in deep on this tool to know more about the limitations of this tool. For now, I am a beginner on this tool and still I need more expertise on this to make a comment on it. Review collected by and hosted on G2.com.

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

In our mobile application, Pega is using this SQLite DB calls to make a connection and fetch the data from the DB tables in our Javascript code. To meet our biz requirement without any performance issues in mobile, we need to follow Pega directions and moreover Pega is using this tool internally in their product. With this DB call settings from Pega, we are fetching and populating the data on UI quickly and biz is happy with this approach. Review collected by and hosted on G2.com.