--- title: "SQLite Reviews, Pros and Cons - 2026 Software Advice" description: "Reviews of SQLite. Learn how real users rate this software's ease-of-use, functionality, overall quality and customer support. Talk to our advisors to see if SQLite is a good fit for you!" source_url: "https://www.softwareadvice.com/database-management-systems/sqlite-profile/reviews/" page_type: "reviews" language: "en" --- 1 million+ businesses helped. Get advice Get Free Advice [Home](https://www.softwareadvice.com/) / [Database Software](https://www.softwareadvice.com/database-management-systems/) / [SQLite](https://www.softwareadvice.com/database-management-systems/sqlite-profile/) / SQLite Reviews Software Advice offers objective insights based on verified user reviews and independent product and market research. When our advisors match you to a software provider, we may earn a referral fee. [Overview](https://www.softwareadvice.com/database-management-systems/sqlite-profile/) Reviews [Alternatives](https://www.softwareadvice.com/database-management-systems/sqlite-profile/alternatives/) # SQLite User Reviews ## Reviews summary - Overall rating: 4.4/5 - Total reviews: 118 ### Secondary ratings - Ease of use: 4.4/5 - Customer support: 3.6/5 - Value for money: 4.5/5 - Functionality: 4.1/5 ### Rating distribution - 5 stars: 65 reviews (55%) - 4 stars: 43 reviews (36%) - 3 stars: 8 reviews (7%) - 2 stars: 2 reviews (2%) - 1 star: 0 reviews (0%) ### Most mentioned pros - The best i like is the supporting multiple languages like drupal and python - SQLite handles small data very easily. - What I appreciate best about SQLIte is how lightweight it is and how easily it can be used in Android applications. ### Most mentioned cons - Some security issues and occasionally non-loading user interface parts make me doubt its reliability - It's not recommended for big databases, only for small ones. - This is a lightweight database, so if you try to store too much data, you can run into some problems. ## SQLite customer reviews Showing reviews 1-25 of 118 (page 1). ### Easy to become a problem - Overall rating: 4/5 - Reviewer: Anderson M. - Verified reviewer: Yes - Industry: Information Technology and Services - Company size: 201-500 employees - Product usage: Used daily for less than 12 months - Reviewed: November 2018 - Review source details: This review was submitted organically. No incentive was offered On a Windows Forms app we used to query services thousand times for data that does not change so frequently. We also had to store some business information (imagine as storing a wizard progress) and that used to be handled using TXT files (and it was a mess). We changed to SQLite and it worked almost like a charm but as the app grew and we decided to create an architecture similar to Google Chrome (multiple processes) it became a major problem for all of them to both read and write at it (we had to create a proxy app to write). #### Ratings breakdown - Ease of use: 3/5 - Value for money: 5/5 - Customer support: 3/5 - Functionality: 2/5 #### Pros 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). #### Cons It's locking architecture enables only a single process to write at a time so building a more complex application may cause hard-to-solve problems. --- ### The best solution for small, pre-packaged databases - Overall rating: 5/5 - Reviewer: Ramindu D. - Verified reviewer: Yes - Industry: Computer Software - Company size: 10000+ employees - Product usage: Used weekly for more than 2 years - Reviewed: November 2019 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. We included SQLite alongside web and mobile applications where a small database was needed with minimum latency. Most commonly, this use case involved storing dynamic configuration values and user preferences. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 5/5 - Customer support: 2/5 - Functionality: 3/5 #### Pros SQLite is a great database solution when you have a small database that you need to package alongside an application, for example a database that stores user preferences. As it is local to the application, it bypasses issues you would have with other, larger database servers in terms of network latency. Its conformity (in the large part) to MySQL syntax and features make it easy to use as well. #### Cons While SQLite's lack of scaling features is forgivable (that wasn't what it was built for after all) some SQL features that are not implemented make it a hassle to write queries to SQLite databases in some instances. --- ### A useful, yet untidy tool - Overall rating: 2/5 - Reviewer: Verified Reviewer - Verified reviewer: Yes - Industry: Marketing and Advertising - Company size: 11-50 employees - Product usage: Used weekly for less than 6 months - Reviewed: July 2024 - Review source details: This review was submitted organically. No incentive was offered quick to deploy and simple to implement, although certain users may want to be aware of some UI and security concerns. #### Ratings breakdown - Ease of use: 2/5 - Value for money: 4/5 - Customer support: 3/5 - Functionality: 2/5 #### Pros Very simple to use and undoubtedly reduces the amount of physical memory used #### Cons Some security issues and occasionally non-loading user interface parts make me doubt its reliability --- ### A good choice for storing small and local data - Overall rating: 4/5 - Reviewer: Nera Joy C. - Verified reviewer: Yes - Product usage: Used daily for more than 2 years - Reviewed: June 2018 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 3/5 - Customer support: 3/5 - Functionality: 2/5 #### Pros I love how SQLite is so portable, and can be used in different platforms. I doesn't need any bulky installation for me to use. It is so lightweight and there is no learning curve when you came from MS SQL. #### Cons Maybe when opening a large sqlite file around 1GB above, it hangs up and sometimes fails to load. But maybe that's my fault because SQLite is not intended for storing large data. Good product anyway. --- ### A lightweight relational database management system especially for offline mobile applications and d - Overall rating: 5/5 - Reviewer: Rahul A. - Verified reviewer: Yes - Industry: Information Services - Company size: 11-50 employees - Product usage: Used weekly for less than 2 years - Reviewed: January 2019 - Review source details: This review was submitted organically. No incentive was offered We have used SQLite in developing many mobile apps, mostly Android App and as a database at back end we integrated this light weight DB system. The processing speed of queries is exceptionally fast. All the databases are working well. #### Ratings breakdown - Ease of use: 5/5 - Functionality: 5/5 #### Pros SQLite is object based relational query language which keeps and maintained the whole databases in a very light weight, usually within 500kb to 1mb size, depending on size of databases. This database system has everything which a standard databases must have like relationships, events, all operations, etc. SQLite is very helpful in building application for Mobiles which stores databases in locally. #### Cons 1. No dedicated server required. 2. Very light weight and easy to follow commands with knowledge. 3. Large community support makes learning this language even more fast and easy 4. Easy to keep backups as the whole database stored in single file. 5. Easy to implement and integrate. --- ### SQLite review - Overall rating: 5/5 - Reviewer: Dhruvil V. - Verified reviewer: Yes - Industry: Information Technology and Services - Company size: 11-50 employees - Product usage: Used daily for less than 12 months - Reviewed: January 2023 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. #### Ratings breakdown - Ease of use: 5/5 - Value for money: 4/5 - Customer support: 3/5 - Functionality: 5/5 #### Pros It is easy to use . We can easily manage and exicute data in it. #### Cons I don't dislike this software its perfect. --- ### Database manager very functional, fast and easy to use for different programming languages - Overall rating: 5/5 - Reviewer: Yngrid M. - Verified reviewer: Yes - Product usage: Used weekly for less than 2 years - Reviewed: July 2018 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. It is a public domain tool that when created with the C ++ language gives those who have experience in programming the facility to adapt it to their requirements, SQLite is independent of the platform. The operations are carried out very efficiently with a single library and a small memory #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Customer support: 3/5 - Functionality: 5/5 #### Pros This Database Manager is really very functional, transactions are fast and its simple interface makes it easy to use, you can work with different programming languages such as PHP and phyton. It is much less complex than other handlers such as Postgres or MySQL #### Cons It is not recommended for systems that use a large amount of data, rather for medium-sized applications or for websites whose number of transactions is very high. It also does not support systems under the client-server platform --- ### Exactly what the name says SQL lite - Overall rating: 4/5 - Reviewer: Kaleb-John L. - Verified reviewer: Yes - Industry: Computer Networking - Company size: 201-500 employees - Product usage: Used weekly for more than 2 years - Reviewed: June 2019 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. Whenever I need a database, SQLite is always a top option. Local storage is needed in most projects and the ability to use SQLite on almost any platform in almost any language means I always have the ability to execute the project with ease. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 4/5 - Functionality: 4/5 #### Pros SQLite is a go to for when I need a quick lite weight database. It provides the ability to create local storage with the ability to integrate into most programming languages. It uses the familiar SQL structure and doesn't require any administration. #### Cons There are some areas where it deviates from using SQL language, but it is usually easily fixed by a quick Google search. --- ### Good but Limited Use - Overall rating: 3/5 - Reviewer: Wechuli P. - Verified reviewer: Yes - Industry: Computer Software - Company size: 1001-5000 employees - Product usage: Used weekly for more than 2 years - Reviewed: March 2020 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. I use it to quickly test applications that need some form of data storage without needing to install database software. #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Customer support: 1/5 - Functionality: 3/5 #### Pros - Very lightweight database products that you can quickly set up to without needing to install complicated tooling so can be used in mobile forms or embedded devices. #### Cons - Does not support the full features of SQL - SQLite does not have support for multi-client concurrency access and can't be used in applications that need this. - Validation of data to input fields is limited --- ### To store small data perfect solution - Overall rating: 5/5 - Reviewer: Ashok G. - Verified reviewer: Yes - Company size: 11-50 employees - Product usage: Used daily for less than 2 years - Reviewed: April 2018 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. #### Ratings breakdown - Ease of use: 5/5 - Value for money: 4/5 - Customer support: 4/5 - Functionality: 3/5 #### Pros 1. It is free 2. Easy to set up and connect 3. Multiple person can use simultaneously which we cann't do in CSV #### Cons 1. Integration with some other tools is not so much easy 2. Loading time for existing tables is little high 3. No stored procedure can be written --- ### My SQLite Experience - Overall rating: 5/5 - Reviewer: Semih D. - Verified reviewer: Yes - Industry: Program Development - Company size: Self-Employed - Product usage: Used daily for less than 2 years - Reviewed: May 2023 - Review source details: This review was submitted organically. No incentive was offered Its average in my opinion. The data management are good but complicated #### Ratings breakdown - Ease of use: 3/5 - Value for money: 5/5 - Customer support: 4/5 - Functionality: 5/5 #### Pros The using of tools, tables and manage datas #### Cons The less functions compare other programs(etc. SSMS) #### Reasons for switching to SQLite Because my customers want it --- ### A standard for testing - Overall rating: 5/5 - Reviewer: Gareth N. - Verified reviewer: Yes - Industry: Computer Software - Company size: 11-50 employees - Product usage: Used daily for more than 2 years - Reviewed: September 2019 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. SQLite allows us to setup and test all our database structures, it's quick and easy to get going and it stays out of your way. Most of the time you'll forget that it's even part of your tech stack. #### Ratings breakdown - Ease of use: 4/5 - Functionality: 4/5 #### Pros I like that SQLite for the most part stays out of your way. As soon as you have your desired config set up, you can transfer it with ease to most other projects and it just works. We use SQLite for testing purposes as it speeds up the entire process. You can either spin a local instance up or have it run in-memory to speed up your tests. The fact that it's usage is so ubiquitous, finding help or answers online isn't an issue at all. #### Cons If I had to fault it at something, there is an edge case with how it builds your database structure, especially with how it handles foreign keys. It's easily handled by adjusting your test setup structure. That's the only hiccup we ever had and resolved with ease. --- ### Great choice if you use it correctly - Overall rating: 4/5 - Reviewer: George S. - Verified reviewer: Yes - Industry: Computer Software - Company size: 2-10 employees - Product usage: Used daily for more than 2 years - Reviewed: August 2019 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 4/5 - Functionality: 4/5 #### Pros SQLite is a fantastic database for resource-constraint systems or for those cases where full-blown SQL client-server system is not required. SQLite has been probably implemented for any platform. It even exists for microcontrollers. When used properly, SQLite makes programmers life easy. #### Cons There is nothing that I dislike about SQLite. --- ### Best Lightweight Relational Database for Small Applications and Websites. - Overall rating: 5/5 - Reviewer: Prince J. - Verified reviewer: Yes - Industry: Computer Software - Company size: 2-10 employees - Product usage: Used daily for more than 2 years - Reviewed: June 2021 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. We always use SQLite as our database when building software and web application prototypes and when deploying basic websites and apps that are not data-intensive. #### Ratings breakdown - Ease of use: 5/5 - Value for money: 1/5 - Customer support: 1/5 - Functionality: 4/5 #### Pros SQLite does not run on a server like MySQL but is part of the end application thus making data storage and retrieval very fast. #### Cons It is not reliable when deploying it with applications with multi-user access to database. With websites, SQLite can only handle sites with low to medium traffic. --- ### Self-contained - Overall rating: 5/5 - Reviewer: Mahonri G. - Verified reviewer: Yes - Industry: Railroad Manufacture - Company size: 201-500 employees - Product usage: Used daily for less than 2 years - Reviewed: December 2021 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. Reliable #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Functionality: 5/5 #### Pros This software is fast, reliable, and very useful for small and big projects. It's user-friendly and fast to learn. I like that it is an open-source SQL database engine. SQLite is very convenient because is an embedded and lightweight database engine and its tools are very easy to use. #### Cons SQLite is not a fit for large applications, it has its limitations. One of the reasons is that when you run a large amount of data, the speed of the queries could be slow --- ### Great tool to have lightweight data bases. - Overall rating: 5/5 - Reviewer: Luis Miguel R. - Verified reviewer: Yes - Industry: Computer Software - Company size: 10000+ employees - Product usage: Used daily for less than 2 years - Reviewed: August 2019 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. I was a part of team developing micro-services in python, and we used SQL Lite to store persistent information on each microservice. It is a great option because the setup it's really simple. #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Customer support: 5/5 - Functionality: 5/5 #### Pros * Really easy to install. * It has compatibility with different operating systems. * It can be used in many programming languages. * The command line is easy to use. #### Cons * It's a light weight database if you are trying to save too much data you will face some problems. --- ### A must for BI - Overall rating: 4/5 - Reviewer: Verified Reviewer - Verified reviewer: Yes - Industry: Hospitality - Company size: 11-50 employees - Product usage: Used weekly for less than 2 years - Reviewed: December 2018 - Review source details: This review was submitted organically. No incentive was offered Used SQLite for querying a relational database at work. Once you learn the basic syntax, it becomes fairly easy to use. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 4/5 - Customer support: 3/5 - Functionality: 4/5 #### Pros Once you figure out syntax, there is no better language for writing queries to a relational database. SQL is the measuring stick #### Cons Like any language, there is a learning curve (albeit not as bad as most others) --- ### SQLite is a comprehensive open source platform - Overall rating: 5/5 - Reviewer: Ali Emre Ç. - Verified reviewer: Yes - Industry: Computer Software - Company size: 2-10 employees - Product usage: Used daily for less than 12 months - Reviewed: November 2022 - Review source details: This review was submitted organically. No incentive was offered #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Customer support: 5/5 - Functionality: 5/5 #### Pros SQLite offers a highly advance database management solution with its open source structure. #### Cons There needs to be a better customer support behind SQLite platform. --- ### A very efficient way to store certain kinds of data. - Overall rating: 5/5 - Reviewer: Verified Reviewer - Verified reviewer: Yes - Industry: Information Technology and Services - Company size: 11-50 employees - Product usage: Used daily for less than 2 years - Reviewed: April 2019 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. We use it for storing certain data. #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Customer support: 5/5 - Functionality: 5/5 #### Pros You get all the benefits of using sql statements without having to set up a sql server online. #### Cons SQL syntax varies between the different versions of sql so the syntax you are familiar with may or may not be available in sqlite. --- ### Database small and effective - Overall rating: 5/5 - Reviewer: Marco R. - Verified reviewer: Yes - Company size: 1001-5000 employees - Product usage: Used monthly for more than 2 years - Reviewed: May 2018 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. If you need a small and robust DB it is the right choice #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Customer support: 3/5 - Functionality: 5/5 #### Pros Given its size, it is almost an obligatory choice for small databases to be distributed, for example through an app. The latest releases have also made it very robust. #### Cons From the name it is clear that the database is not designed to accommodate large amounts of data, so we need to evaluate the adoption well. --- ### Good way of storing your app data - Overall rating: 4/5 - Reviewer: Filip N. - Verified reviewer: Yes - Industry: Information Technology and Services - Company size: 10000+ employees - Product usage: Used weekly for less than 2 years - Reviewed: September 2020 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. I'm extremely satisfied with the SQLite. I've used it to store my web app data, and it has been performing flawless ever since. #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Customer support: 3/5 - Functionality: 4/5 #### Pros It has great integrated features that are compatible with multiple languages. Ease of access and connection to the SQLite database are a big plus when working with data. #### Cons It has some limitations when it comes to the size of the data your'e working with. It's not designed to store and manipulate large sets/chunks of data (big data). --- ### Good software, needs a bit of knowledge - Overall rating: 4/5 - Reviewer: Verified Reviewer - Verified reviewer: Yes - Company size: 11-50 employees - Product usage: Used weekly for less than 12 months - Reviewed: April 2018 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. #### Ratings breakdown - Ease of use: 3/5 - Functionality: 5/5 #### Pros Free, powerful and comprehensive bit of software which manages and helps to look after our SQL databases #### Cons It does take a little while to get used to the software and to get to know the features, there are more features than meets the eye. --- ### Small, Fast And Efficient RDBMS - Overall rating: 4/5 - Reviewer: Ali O. - Verified reviewer: Yes - Industry: Information Technology and Services - Company size: 11-50 employees - Product usage: Used weekly for more than 2 years - Reviewed: May 2019 - Review source details: This review was submitted organically. No incentive was offered #### Ratings breakdown - Ease of use: 4/5 - Value for money: 4/5 - Customer support: 4/5 - Functionality: 4/5 #### Pros SQLite is a great RDBM solution if you need a database for embedded devices, IoT, websites or cache management. It is small, fast and efficient. It doesn't require any setup or administration. It provides easy to use APIs. #### Cons if what you need is a client-server database, it's not for you. --- ### Lightweight and easy to use. - Overall rating: 5/5 - Reviewer: Dennis N. - Verified reviewer: Yes - Industry: Information Technology and Services - Company size: 51-200 employees - Product usage: Used daily for less than 12 months - Reviewed: April 2019 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. Perfect for small project and easy to setup. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 5/5 - Functionality: 5/5 #### Pros It's really well design and easy to connect to database, and best of all it is free. #### Cons It's not really good for large databases it can be quite slow, but perfect for small projects. --- ### SQLite is fantastic for small databasing projects - Overall rating: 5/5 - Reviewer: Dan H. - Verified reviewer: Yes - Industry: Hospital & Health Care - Product usage: Used monthly for less than 2 years - Reviewed: May 2018 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 5/5 - Customer support: 3/5 - Functionality: 4/5 #### Pros It's easy-to-use, well-supported and best of all does not require an external service running. It also can be adopted cross-platform with ease. #### Cons The only bad things I have to say about it are inherent in the design it's not a full-featured query databasing query language, but then, it's not trying to be. ## More reviews [Next reviews](https://www.softwareadvice.com/database-management-systems/sqlite-profile/reviews/?page=2) --- SQLite Reviews, Pros and Cons - 2026 Software Advice