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.

Verified User in Higher Education

Enterprise (> 1000 emp.)

1/18/2017

"SQLite from a beginner's perspective"

4.5/5

What do you like best about SQLite?

SQLite is fairly intuitive to use. It has all the functionality that I require but without overwhelming me. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Not much - overall I am very happy with SQLite. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

I am fairly new to databases, but this software meets all my needs currently. It interfaces well with Python, which is extremely helpful. As I learn to use the software more, I hope to leverage it better. Review collected by and hosted on G2.com.

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

I am trying to manage large datasets better. I am also trying add machine learning to our team and this software is very useful. We are hoping to better understand patterns among our customers that predict future outcomes. Ideally, we will be able to anticipate and head off future problems. This software will/should help us manage these large datasets. Review collected by and hosted on G2.com.

Verified User in Accounting

Mid-Market (51-1000 emp.)

11/8/2017

"sqllite"

1.5/5

What do you like best about SQLite?

sqllite allows for faster query execution Review collected by and hosted on G2.com.

What do you dislike about SQLite?

the user interface needs to be more engaging Review collected by and hosted on G2.com.

Hakim B.

PhD Student

Higher Education

Small-Business (50 or fewer emp.)

3/29/2017

"Sqlite a lighter alternative to MySQL and PostgreSQL"

3.5/5

What do you like best about SQLite?

The Size of the Sqlite database is so small, and so easy to integrate. This makes it portable, and adequate for devices with relatively small memory size (phones). Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Sqlite is obviously not made for a high-traffic application (parallel transactions executed in parallel). Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Sqlite is particularly for a small application (especially if you're planning to deploy it on a device that's not too much powerful, i.e. phones, Raspberry Pi). Review collected by and hosted on G2.com.

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

Small Flask webapps I've developed in the past, where the database used was Sqlite. Review collected by and hosted on G2.com.

Verified User in Retail

Enterprise (> 1000 emp.)

10/20/2016

"SQLite is really light and efficient"

4/5

What do you like best about SQLite?

First of all it is freeware.one of the widely accepted software and used by big giant companies.

It has all the features of sql database but very much compact.

Moreover it is good when you are or the device is on low memory capacity. It still performs well but as you give it more memory it performs better.

ACID transaction is one of the key feature. It is capable of server less function and supports cross platform file format. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

There are few bugs and issues that we face sometimes. We log in defects with the product support team and get it resolved.

I like SQLite for it's feature and easy to use programming methods.

Queries are pretty simple and easy to connect to the database connection. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

It is a robust software which is freely available with lots of functionality and all big companies like facebook, google already use it. So there is no need for any further recommendation and the product is highly compatible and efficient. Review collected by and hosted on G2.com.

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

My company used SQLite as their SQL database engine.

It takes very less amount of space. No platform constraints and easy to use software.

Freeware software hence does not have to pay a lot for the initial test.

Easy training materials are available. Helpful vendor support system. Review collected by and hosted on G2.com.

Verified User in Research

Mid-Market (51-1000 emp.)

8/30/2017

"SQL Lite"

5/5

What do you like best about SQLite?

Easy to use features! User friendly and logical Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Color contrast in program could be better Review collected by and hosted on G2.com.

Scott K.

Small-Business (50 or fewer emp.)

7/26/2016

"excellent uses for sqlite where you don't need full sql daemon, such as vpopmail with postfix"

5/5

What do you like best about SQLite?

It's a very lightweight sql database program where the database is more or less a binary file where you're able to create/drop tables, insert/update/delete data, view full schemas to understand the table structure.

It's extremely easy to use and probably the best SQL application for a beginner to learn with - then moving up towards more complex databases will be a lot easier for them to grasp and work on. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

When I had implemented it on my postfix installation for virtual mailboxes, doing changes to the sqlite database wouldn't pick up via postfix until postfix was reloaded. That was a little weird to see and can be a bit tedious unless you were to automate such a process.

For the applications that I'm using sqlite for primarily, they are all lightweight and/or used due to keep other databases such as MySQL open with more connections and be able to process more advanced queries. Just for the reason that SQLite does exactly what I'm wanting to use it for, dislikes are far and few. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

There's other databases one could use that are also very fast, however in terms of resources and efficiency, sqlite is probably one of the easier and better solutions to implement wherever you may end up having a bit of a traffic surge that could overwhelm a traditional [not properly tuned] database to be problematic, whereas sqlite should just continue to function smoothly. Review collected by and hosted on G2.com.

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

It's a great lightweight, small database that can be implemented for so many applications. Virtual user accounts are an extremely easy way to be managed via sqlite and it also helps even the beginner learn the SQL language a bit easier as it isn't very complicated. Then such users can graduate to better databases that are much faster.

The business problems we've solved with it would be virtual accounts for security purposes. One could alternatively jail things, however sqlite virtual accounts seem to be popular and easy to do. Review collected by and hosted on G2.com.

Verified User in Nanotechnology

Small-Business (50 or fewer emp.)

11/10/2016

"Easy to use powerful client side Database"

3.5/5

What do you like best about SQLite?

Stores data in a optimum way. Its a relational database so it is much easier to manage large amount of data easily. Data insertion and retrieval is very quick with no time lag. Large amount of data is also retrieved very fast. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

There is no proper data type for storing date. We had to workaround in which we store the dates as string. Indexes are not present in this database. It could have been much better if indexes would have been there. Review collected by and hosted on G2.com.

Kielse N.

Development Team Manager

Computer Games

Mid-Market (51-1000 emp.)

7/19/2016

"Excellent for tiny databases"

5/5

What do you like best about SQLite?

It is really easy to start using SQLite. You can follow several tutorials and probably you will find a tutorial explaining how to use it with the program language that your are creating your software/solution. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

Is not that I dislike, but people sometimes should think if the best solution is to use SQLite. For example, in a client/server solution, maybe, will be better to use a client/server database. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

If you need to save a small database in the client application is really good. Receive the data using network and just save and read using SQL commands. Is excellent for off-line applications as well. You will love it. Review collected by and hosted on G2.com.

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

Receiving useful data to run clients on mobile apps. Creating local SQLite and sending some changes to server using our own protocol. Review collected by and hosted on G2.com.

Michael T.

Model

Entertainment

Mid-Market (51-1000 emp.)

5/17/2016

"Lightweight, fast and reliable"

5/5

What do you like best about SQLite?

SQLite is an amazing solution if you're looking for speed, reliability, common and well known syntax, ease of setup for your application. It is one of the best file based relational data bases out there. It helps creating a portable application a breeze especially if you are working on a port of a desktop application. You most likely have to do zero to none code refactoring. Our team has made a mistake of trying out alternative file-based databases (non-relational) and it was a horrible experience, we've grown so accustom to the SQL syntax and way of storing data that I can not imagine using anything else. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

I don't think I came around any bugs or issues with SQLite, I'm more than happy using it on web, desktop and mobile applications. Performance gains are always welcome though. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

Most of the applications and devices you use on a daily basis are powered by SQLite in one way or another. I can not recommend it enough for your own projects, be it small or large. Even enterprise level applications can benefit from storing some sort of data away from the main database. If you are doing everything right and are good at doing query caching you will be greatly amazed by SQLite's performance. Review collected by and hosted on G2.com.

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

Smaller web or portable applications are all running on SQLite, as well as our mobile apps. If you need local or offline storage look no further, especially if you are willing to go an extra mile with back-end optimizations such as query caching, etc. you will be amazed by how fast even the heaviest or worst written queries are. Review collected by and hosted on G2.com.

Le T.

Technical Manager

Information Technology and Services

Small-Business (50 or fewer emp.)

5/26/2016

"Good database for mobile app"

5/5

What do you like best about SQLite?

I develop many mobile apps, and often work with SQLite.

It is convenience to work with SQLite to save my in-app data.

It is lightweight, fast, smooth.

It is powerful. I can easy filter data, search & sort. Review collected by and hosted on G2.com.

What do you dislike about SQLite?

No I like it, and very happy with SQLite for apps.

i don't use SQLite for website for desktop app because I think it is too small for those types of app. Review collected by and hosted on G2.com.

Recommendations to others considering SQLite:

SQLite is a mut-have in your mobile app to save data, loading data and finding -sorting data, including filter saved data in it. Review collected by and hosted on G2.com.

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

Mobile app development.

Easy to save data, linking data, and finding, sorting data.

Everything I need to work with data can be easy do with SQLite Review collected by and hosted on G2.com.

Trending Discussions related to SQLite

Where can i find better documentation for SQLite? Any tutorials?

Jithilabout 5 years ago

Is SQLite free to use?

Guestabout 3 years ago

View all Discussions

Pricing Insights

Averages based on real user reviews.

Time to Implement

2 months

Return on Investment

13 months

Average Discount

15%

View More Pricing Information

SQLite Comparisons

Microsoft Access

4/5

(849)

Compare Now

MariaDB

4.4/5

(224)

Compare Now

firebase

4.5/5

(296)

Compare Now

SQLite Features

Database Features

Storage

Availability

Stability

Support

Data Types

Languages

Operating Systems

Security

Database Locking

Authentication

Management

Data Schema

Query Language

Data Replication

View More Features

Categories on G2

Relational Databases

Explore More

Which performance management software do big tech firms use

Most efficient ID verification software for ecommerce sites

Re-claim your company’s G2 profile

4.3 out of 5 stars

SQLite Reviews & Product Details

Value at a Glance

Time to Implement

Return on Investment

Top-Rated Alternatives

SQLite Integrations

Have you used SQLite before?

SQLite Reviews (259)

SQLite Reviews (259)

Review Summary

Pros & Cons

Filter Reviews

Where can i find better documentation for SQLite? Any tutorials?

Is SQLite free to use?

Pricing Insights

Time to Implement

Return on Investment

Average Discount

SQLite Features

Categories on G2

Explore More