--- title: SQLite Reviews meta_title: 'SQLite Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 262 reviews by the users' company size, role or industry to find out how SQLite works for a business like yours. aggregate_rating: rating_value: 4.3 review_count: 262 scale: '5' date_modified: '2026-08-09' parent_category: name: Database Software url: https://www.g2.com/categories/database-software --- # SQLite Reviews **Vendor:** SQLite **Category:** [Relational Databases](https://www.g2.com/categories/relational-databases) **Average Rating:** 4.3/5.0 **Total Reviews:** 262 ## About SQLite 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. ## SQLite Pros & Cons **What users like:** - Users appreciate the **setup ease** of SQLite, finding it quick, lightweight, and perfect for mobile applications. (2 reviews) - Users praise the **ease of use** of SQLite, highlighting its lightweight nature and quick setup for mobile apps. (1 reviews) - Users appreciate the **impressive management system** of SQLite, enhancing their overall experience and productivity. (1 reviews) - Users love the **speed and lightweight nature** of SQLite, making it ideal for mobile applications without heavy setup. (1 reviews) - Users find the **user interface and management system impressive** , enhancing their overall experience with SQLite. (1 reviews) **What users dislike:** - Users find SQLite's **difficult learning curve** challenging, particularly for managing large traffic and user accounts. (1 reviews) - Users find **feature limitations** in SQLite, especially concerning the administrative side compared to alternatives like MSSQL. (1 reviews) - Users find **limited database support** inconvenient for high traffic and miss built-in user accounts like MySQL offers. (1 reviews) ## SQLite Reviews ### 1. SQLite: Lightweight, Fast, and Easy to Embed in Any App. **Rating:** 5.0/5.0 stars **Reviewed by:** Eusuf K. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** June 01, 2026 **What do you like best about SQLite?** SQLite is nice because it’s small and easy to use. You don’t need to setup a big server, it just works inside your app. The database is just one file, so moving or sharing it is simple. It’s also fast for many tasks since there’s no network stuff slowing it down. Some people like it because: 1. No complicated install, it runs right away. 2. One file makes it portable. 3. Works reliable even with big data. 4. Often quicker than bigger databases. 5. Free to use 6. SQL is easy to understand, there are lots of blogs present to learn. 7. AI is not present nor needed 8. Integrates well into any sql compatible app. It’s not perfect for every case, but for many apps it’s more than enough. **What do you dislike about SQLite?** It is sometimes slow in cases where the data is too big. **What problems is SQLite solving and how is that benefiting you?** Embedding it into my small apps, which eliminate the need of starting a dedicated sql container. ### 2. Simple, Lightweight, and Portable—SQLite Makes Databases Easy **Rating:** 4.5/5.0 stars **Reviewed by:** Kodam S. | Operations support asssitant, Enterprise (> 1000 emp.) **Reviewed Date:** April 08, 2026 **What do you like best about SQLite?** What I like most about SQLite is how simple and lightweight it is to work with. It doesn’t require any server installation, so everything runs smoothly within the application itself, which I find very convenient. I also appreciate how easy it is to get started. With minimal setup, you can create and manage databases right away, and because it uses standard SQL, it’s straightforward to learn and understand. Another big advantage is its portability. Since the entire database is stored in a single file, it’s easy to transfer, share, or back up whenever you need to. **What do you dislike about SQLite?** One limitation I’ve noticed with SQLite is that it doesn’t perform well in situations where multiple users are trying to write data at the same time. It’s better suited for lighter workloads rather than heavy concurrent usage. I’ve also observed that it doesn’t offer some of the advanced capabilities you’d find in larger database systems, such as detailed access controls or built-in scalability features. **What problems is SQLite solving and how is that benefiting you?** From my point of view, SQLite addresses the need for a database that is quick to use without the complications of setting up a full server-based system. One key problem it solves is time-consuming installation and maintenance. Unlike traditional databases, it works immediately without configuration, which makes it very practical when I need a fast and simple solution. Another advantage is its easy portability. Since everything is stored in a single file, I can move or share the database effortlessly across different systems. ### 3. Lightweight and Fast for Small Tasks, but Not Ideal for Heavy Traffic **Rating:** 4.0/5.0 stars **Reviewed by:** MAHANTESH S H. | Lead Cybersecurity, Enterprise (> 1000 emp.) **Reviewed Date:** October 14, 2025 **What do you like best about SQLite?** It is lightwiegt less MB size, it is fast easy to use, copy, move, no big setup required. Usefull for mobile apps **What do you dislike about SQLite?** It is not very convenient for big traffic, doesn't have built in user accounts like mysql **What problems is SQLite solving and how is that benefiting you?** The main problem it solves is simple setup, save data without need of a database server, works in offline mode, it is portable. ### 4. Great serverless relational database **Rating:** 4.0/5.0 stars **Reviewed by:** ARYAN S. | Enterprise (> 1000 emp.) **Reviewed Date:** May 05, 2023 **What do you like best about SQLite?** I like how SQLite is serverless relational database, It is really easy to integrate into web apps and REST APIs as compared to other relational databases, It also provides all the basic functionality that can be expected out of a relational database **What do you dislike about SQLite?** I feel like SQLite is not suitable for large scale applications as it does not have access to a network and has a limited database size, and it is not suitable for handling high traffic requests **What problems is SQLite solving and how is that benefiting you?** SQLite is a really good serverless alternative to SQL databases, while it might not be suitable for large scale applications due to its limited database size but it works great for internal applications that do not expect high request traffic ### 5. Small databases for big functionality **Rating:** 4.5/5.0 stars **Reviewed by:** Ivan A. | Investigador División Building Technologies, Enterprise (> 1000 emp.) **Reviewed Date:** August 16, 2023 **What do you like best about SQLite?** It is easy to deploy and does not consume much system resources which is very good for databases in small embedded systems such as Raspberry Pi. **What do you dislike about SQLite?** It does not provide as many fuctionalities as MySQL for example. **What problems is SQLite solving and how is that benefiting you?** Deploying databases to store sensor data on small embedded devices such as Raspberry Pi ### 6. Recommended software for data research **Rating:** 4.0/5.0 stars **Reviewed by:** Aniket T. | Business Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** October 19, 2022 **What do you like best about SQLite?** Easy to use if you are familiar with database structure. It gives you exact Information which can be required for further study or analysis. I find it helpful than putty software. **What do you dislike about SQLite?** Interface can be improved. New commands can be introduced. Sometimes it take time to load the data when you submit the Sql query, there is lagging issues. Resposiveness can be improved. **What problems is SQLite solving and how is that benefiting you?** I find historical data and analyse as per business requirement.I check the required data for analysis using sql lite. I can see increase in my productivity with usage of sql lite. ### 7. Best database to use - Fast and easy **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** February 27, 2022 **What do you like best about SQLite?** It is fast and I can say easy to install in existing and new projects. It supports many cross-platforms as well like iOS, Android, MAC, windows as well. SQLite is fully open source and developers can modify it according to their use. SQLite database can be used for small to large scale projects. **What do you dislike about SQLite?** In many case SQLite wont support Relational database feature. If a application which scale-out very fast, for that type of project we need to use carefully **What problems is SQLite solving and how is that benefiting you?** One SQLite database structure can be used by one or many other platforms like iOS, Android, even python as well. Many third-party ORM's and data layers are available in the market for SQLite, which make developer life easy. and it saves development time. It supports JSON and CSV files. SQLite can work with in-memory data or external files. ### 8. sql lite review **Rating:** 3.5/5.0 stars **Reviewed by:** Ankit S. | Technology lead, Enterprise (> 1000 emp.) **Reviewed Date:** January 25, 2022 **What do you like best about SQLite?** User interface is the best to understand input and output. I must say its best to have it in your development skills, project deliverables. Most of the insights can be extracted as its simple to use. **What do you dislike about SQLite?** Too much window at a time confuses to search. I am not very fond of multiple windows or tabs within a product as this makes me more distracted rather than concnentreted on the one work at a time. **Recommendations to others considering SQLite:** Its a good to have the product, easy to use, better user experience, good stability features, and is simple to understand. **What problems is SQLite solving and how is that benefiting you?** Analyzing the data more frequently and consistently so that some insight can be inferred. ### 9. Real experience SQL Lite database transaction with file transaction **Rating:** 4.0/5.0 stars **Reviewed by:** Rajesh K. | Senior Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** April 19, 2022 **What do you like best about SQLite?** Lightweight data transactions with local storage. **What do you dislike about SQLite?** Some of data save and with delimiters transactions too complicated **Recommendations to others considering SQLite:** Export data type with data filtering delimiters. **What problems is SQLite solving and how is that benefiting you?** Local storage with low-level memory consumption. ### 10. Good for the small database **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** March 25, 2022 **What do you like best about SQLite?** Easy to setup and use also it is lightweight and it has same commands as of mySQL **What do you dislike about SQLite?** Good for light database if database size is big enough it starts showing latency as compared to other db out there **What problems is SQLite solving and how is that benefiting you?** I am using it for creating software for small purpose use and also for testing those software. ### 11. Pretty simple SQL app **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** December 14, 2021 **What do you like best about SQLite?** I liked how easy it was to set up and connect to my company's database. Also pretty easy as far as access controls for different employees. Overall navigation is nice and not hard to start new projects to query things **What do you dislike about SQLite?** Sometimes it was really hard to understand error messages if things were typed wrong. And it was hard to pinpoint issues to troubleshoot them. Slowed down quite a bit if I had too many projects opened **What problems is SQLite solving and how is that benefiting you?** Being able to cross reference data, utilize queries to create similarities or find particular clients to see certain trends that would be helpful for the company bro target. ### 12. Great database for modeling and rapid development **Rating:** 5.0/5.0 stars **Reviewed by:** Randall M. | Site Reliability Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** August 11, 2020 **What do you like best about SQLite?** Already installed ready to use rapid stand up rip and tear down stores everything is local files **What do you dislike about SQLite?** Scaling can be difficult , security features are linited **What problems is SQLite solving and how is that benefiting you?** Developing applications to require database backend but don’t want to deal with the complexities of also have to understand a post grass or any of the more traditional databases ### 13. SQLite is really light! **Rating:** 4.0/5.0 stars **Reviewed by:** Román Josué d. | Data Scientist, Enterprise (> 1000 emp.) **Reviewed Date:** May 18, 2019 **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. **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. **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. **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. ### 14. Using SQLite in desktop applications **Rating:** 2.5/5.0 stars **Reviewed by:** Marcio d. | Mr, Enterprise (> 1000 emp.) **Reviewed Date:** July 16, 2019 **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. **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. **Recommendations to others considering SQLite:** Avoid use sqlite with big amount data. have a high risk of crash in files **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. ### 15. Lite Database with awesome feature **Rating:** 5.0/5.0 stars **Reviewed by:** Mahesh K. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** January 15, 2019 **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. **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. **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. **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. ### 16. SQLite review **Rating:** 5.0/5.0 stars **Reviewed by:** Vilok L. | Assistant System Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** August 30, 2019 **What do you like best about SQLite?** The best thing is it is lightweight ,no network access and it is standalone database **What do you dislike about SQLite?** The security features are not well equiped **Recommendations to others considering SQLite:** Highly recommend **What problems is SQLite solving and how is that benefiting you?** No network access is needed and unlike oracle,Postgress it is easy to retrieve and establish connections ### 17. Best Portable Database **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.) **Reviewed Date:** March 27, 2019 **What do you like best about SQLite?** SQLite is known for being lightweight, robust and reliable at the same time. Since it is serverless, you don't need to install it or keep separate space for it. It's a standalone relational database which is ideal for mobile platforms whether IOS or Andriod. The syntax or query language of SQLite is quite easy to understand and you can go through their docs or online portals to find many examples and tutorials for the same. **What do you dislike about SQLite?** I think most of the people face this problem that it is not a multi-user database application which restricts it to a single user writing at a time. It also lacks some of the basic functionality that other competitor software provides like different Joins and Stored Procedures call. It is primarily used in our development cycle but it's not well suited to handle Enterprise level databases. **What problems is SQLite solving and how is that benefiting you?** We use it for all our development projects where the data is not that huge and a strict Timeout period is not applied to the database call. It gives us the data in a structured form in tables and that too in a size under 1 Mb. It doesn't require any space or server for installation. So, saves a lot of physical space and CPU resources. ### 18. SQLite - Easy, Light Weight and Reliable way to Store Data **Rating:** 4.0/5.0 stars **Reviewed by:** Apurv D. | Engineering Manager, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** December 07, 2018 **What do you like best about SQLite?** 1. As Sqlite is serverless tool, It requires no effort for setup and configuration. 2. It is very simple and so easy to learn. 3. It is supported on mobile OS as well. For iOS and Android application local data storage, SQLite is the best option. 4. As it makes only one file, it is really easy to port from one platform to other. This specially helps to test your product across different mobile platforms. 5. It has excellent documentation and community support. Most of the time, you can solve the problem on the tip of finger. 6. Now a days, many tools with great GUI available which makes it even easier to work with. **What do you dislike about SQLite?** 1. It has not sufficient types to handle decimal numbers. Sometimes you may have precision loss. 2. It is designed for single user and small scale applications. So for enterprise grade application, it is not suitable. 3. Store procedures are not supported. 4. No built in support to encrypt data which causes security issues (however many open source wrappers available to encrypt data stored in SQLite file). **Recommendations to others considering SQLite:** If the size of data is limited and is not suppose to be grow after certain level, SQLite is great. It is a De facto standard of storage for Mobile application. So, for iOS and Android applications, I highly recommend SQLite to persist data. **What problems is SQLite solving and how is that benefiting you?** We use Sqlite mainly to develop mobile applications. When mobile applications need to store relational data into local device itself, SQLite is the best choice. iOS has its native wrapper called Core-Data which also provides simpler way to store data on SQLite database. In a way where server and enterprise features are not required (specially for research and basic data analysis is required) , we use SQLite. ### 19. Lite but complete **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** April 23, 2019 **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. **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. **Recommendations to others considering SQLite:** very lite and user friendly **What problems is SQLite solving and how is that benefiting you?** Connecting and access to the database is easy from our various offices around the globe. Installing and the memory usage of SQLite is perfect. ### 20. "SQLite Great Start to your business!" **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.) **Reviewed Date:** February 07, 2019 **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). **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 **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. ### 21. Light weight database and easy to use **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in E-Learning | Enterprise (> 1000 emp.) **Reviewed Date:** July 30, 2019 **What do you like best about SQLite?** Light weighted process and easy to maintain table and SQL query **What do you dislike about SQLite?** Sqlite should be improved like room database . **Recommendations to others considering SQLite:** Should be improved like room database using obeserable **What problems is SQLite solving and how is that benefiting you?** Already play store live apps create extra column so some user got crash but I will solve by using alter query way ### 22. Would like to learn more on SQLite as a part of my project work **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** January 03, 2019 **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. **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. **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. ### 23. Standard now in this day and age **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** August 08, 2019 **What do you like best about SQLite?** Stores data as objects and not as relational data **What do you dislike about SQLite?** Can use up a lot of space very quickly because you’re storing objects **Recommendations to others considering SQLite:** Good if you don’t need a table management database **What problems is SQLite solving and how is that benefiting you?** Complex and customized data storage ### 24. Database architecture **Rating:** 5.0/5.0 stars **Reviewed by:** Himanshu K. | Manager, Enterprise (> 1000 emp.) **Reviewed Date:** October 24, 2018 **What do you like best about SQLite?** This software is used for database management. It is the light version of SQL. It is self- contained, serverless and require no setup. It is suitable for small embedded devices like cell phone, mp3 player, etc. It is based on command line interface. **What do you dislike about SQLite?** Sometimes it poses a risk on security. It is gets slow when data being handled increases. **Recommendations to others considering SQLite:** I would recommend this software to those who needs to handle small database for small embedded device or small websites. It is very simple, compact and easy to learn. **What problems is SQLite solving and how is that benefiting you?** I use this software to manage database for my embedded projects. It is very simple and easy to use. It requires no setup and is full featured like SQL. It has no extra dependency. It is best for small sized websites. ### 25. SQLite - Embedded version **Rating:** 4.0/5.0 stars **Reviewed by:** Krishna C. | Senior Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** March 20, 2019 **What do you like best about SQLite?** We use SQLite in an embedded mode within our java application as a temporary storage before streaming out to our external message broker. Very low memory footprint and handy. **What do you dislike about SQLite?** While I am not expecting a full blown database, it is just an OK for embedded database compared to H2. **What problems is SQLite solving and how is that benefiting you?** Embedded database Temporary storage within JVM. ### 26. Good, but limited **Rating:** 2.5/5.0 stars **Reviewed by:** Verified User in Education Management | Enterprise (> 1000 emp.) **Reviewed Date:** January 22, 2019 **What do you like best about SQLite?** The database client is pretty straight forward to use, compare to other, larger name enterprise SQL clients. Extremely easy to dump a client on a workstation quickly and pass around entire databases during development **What do you dislike about SQLite?** Interface in client seems "smooshed". Everything is being crammed into a small viewing pane out of the box. Haven't played with reconfiguring the view settings, but I feel like I shouldn't have to. **What problems is SQLite solving and how is that benefiting you?** We use SQLite primarily because some vedors that we partner with use it as a web app backend. The main benefit of this use case is that we can have more informed conversations with them while troubleshooting issues as opposed to dumping the entire support process on them. ### 27. No setup, quick and easy to implement database **Rating:** 3.5/5.0 stars **Reviewed by:** Joan L. | Data Analyst, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** December 23, 2018 **What do you like best about SQLite?** SQLite requires no setup. Create the sqlite or db file and you're good to go. It allows you to write and execute SQL scripts. It has ACID transactions that are reliable even on server crashes. **What do you dislike about SQLite?** SQLite is best used when studied carefully. Using it on medium-sized application might not be recommended. **Recommendations to others considering SQLite:** It's free. It's realiable and robust. And it's easy to use. **What problems is SQLite solving and how is that benefiting you?** Using it on small-scaled application has really helped us a lot for storing and accessing application data. ### 28. lite as the name says **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** June 04, 2019 **What do you like best about SQLite?** saving data in the app is easy using sqllite. supporting offline features made simple with sqllite **What do you dislike about SQLite?** nothing to dislike apart from writing those queries. Queries are at time complex to write. **What problems is SQLite solving and how is that benefiting you?** data management ### 29. SQLite review **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Retail | Enterprise (> 1000 emp.) **Reviewed Date:** March 15, 2019 **What do you like best about SQLite?** SQLite does not need to be "installed" for use, it's a very lightweight tool to access databse. **What do you dislike about SQLite?** We can't use SQLite in production because it doesn't support concurrency. **What problems is SQLite solving and how is that benefiting you?** Space issues, sqlite takes very less disk space and opensource tool ### 30. Sqllite **Rating:** 3.5/5.0 stars **Reviewed by:** Varun S. | Data Engineer, Computer Software, Enterprise (> 1000 emp.) **Reviewed Date:** December 26, 2018 **What do you like best about SQLite?** Very lightweight file-based database. Can be installed on multiple servers as it's just a file. **What do you dislike about SQLite?** file lock when read. This has a limitation that whenever the DB is being accessed it's locked even for reads. **What problems is SQLite solving and how is that benefiting you?** very lightweight, easy to setup ### 31. SQL Light **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** March 27, 2019 **What do you like best about SQLite?** It’s fast with all functionality of SQL and good for DA **What do you dislike about SQLite?** Can’t handle much complexity though for faster use case is just fine **What problems is SQLite solving and how is that benefiting you?** Data analysis ### 32. Simple-to-use, flexible database for lightweight loads **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** July 12, 2018 **What do you like best about SQLite?** Very simple to manage - no need to spend lots of time configuring a client-server connection, as everything is stored in files on the local file system. Moreover, SQLite is very faithful to the classic SQL language, allowing one to easily learn how to operate the database. **What do you dislike about SQLite?** Because everything is stored on a file, it is difficult to maintain a distributed, scalable replica of the database. If the server hosting the database goes down, it is impossible to recover the data. **Recommendations to others considering SQLite:** This product is useful in allowing quick iterations of a work in progress. It would be inadvisable to use this product in a fully-functional production system. However, for hobby projects, or small use cases, SQLite is much simpler to use than the typical relational database. **What problems is SQLite solving and how is that benefiting you?** We have used SQLite for light workloads where fault-tolerance and scalability were not key goals. It was useful for rapid prototyping, allowing fast iterations before moving to a more stable database. ### 33. Great for learning and prototyping **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** December 27, 2018 **What do you like best about SQLite?** SQLite was the first database I ever used. I used it to practice SQL and build more and more complex queries. Then later when I used it when learning web development using Django. **What do you dislike about SQLite?** I don’t dislike anything in particular about it but I haven’t worked with it in production scenarios. **What problems is SQLite solving and how is that benefiting you?** SQLite has been really helpful with developing fluency in SQL in an accessible, easy to use way. ### 34. Light and easy to use **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** January 23, 2019 **What do you like best about SQLite?** 1. No configuration is required. This makes IT person life easy. 2.It is portable, which means it can go with you anywhere. **What do you dislike about SQLite?** 1. Because it doesn't have a server, it is not possible to access through network. 2. User doesn't have a freedom to manage. **Recommendations to others considering SQLite:** Try it. you will like it! **What problems is SQLite solving and how is that benefiting you?** Deploy data. ### 35. Powerful tool **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** November 03, 2018 **What do you like best about SQLite?** Quick and easily available tool to store data. Good to use for debugging and optimizing your code. **What do you dislike about SQLite?** It lacks built in data encryption and cannot be used in multi user database management system. **Recommendations to others considering SQLite:** You can use it if you are not really that comfortable with SQL server management studio. My first preference would always ebe SSMS. **What problems is SQLite solving and how is that benefiting you?** Used it for generating huge amount of data for further analytics with reports and dashboards. ### 36. Great and easy to use! **Rating:** 5.0/5.0 stars **Reviewed by:** Suzanne M. | Enterprise (> 1000 emp.) **Reviewed Date:** September 21, 2018 **What do you like best about SQLite?** Easy to help customers with in the webhosting account. **What do you dislike about SQLite?** Can't think of anything. We didn't have it originally when I was doing tech support for hostgator but its a great database tool. **Recommendations to others considering SQLite:** Easy to use and troubleshoot any issues! Use it. **What problems is SQLite solving and how is that benefiting you?** Webhosting and helping customers install and use. ### 37. Fast and Reliable **Rating:** 4.5/5.0 stars **Reviewed by:** Ankit J. | Enterprise (> 1000 emp.) **Reviewed Date:** April 27, 2018 **What do you like best about SQLite?** A very powerful, embedded relational database management system. Best thing about SQLite is that when an application uses SQLite, the integration works with functional and direct calls made to a file holding the data rather than communicating through an interface of sorts **What do you dislike about SQLite?** Lack of possibility to tinker with for additional performance and No No user management for SQLite because of their use case. **Recommendations to others considering SQLite:** Just make sure you use it just to learn SQL and not to deploy some application with this as it is light weighted with no user management. **What problems is SQLite solving and how is that benefiting you?** I practice SQL queries on SQLite as it is light weighted and does not require you to do necessary stuff and makes your life easy while learning. ### 38. Compact and Simple Database Engine **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.) **Reviewed Date:** November 27, 2018 **What do you like best about SQLite?** Even though it is not a full featured database engine, it supports majority of relational and sql standards. **What do you dislike about SQLite?** Not all data types and joins are supported. Sometimes referential integrity is compromised when multiple users are making changes. **What problems is SQLite solving and how is that benefiting you?** We used it for few andriod and web based applications. ### 39. If you a Android developer then SQLite would be the route to take. **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** January 03, 2018 **What do you like best about SQLite?** For starting on Android Platform, SQLite would be the best for any kind of storage whether it is images, urls, data entry etc. As the name suggests, it is a lite version of the actual SQL which we have learnt right from our engineering days. However it is pretty vast for any kind of storage you looking for in your application. **What do you dislike about SQLite?** SQLite was the traditional method for storing data using relational database. Now that we have many different database formats like NOSQL, PostGress, even for Android we now make use of Realm database as it has similar operations like SQLite but much more robust and easier to implement. **Recommendations to others considering SQLite:** If you starting fresh on Android then go the SQLite route...once you become pretty efficient, you can them move to further simplified databases like Realm **What problems is SQLite solving and how is that benefiting you?** We had to build a banking application for use by one of the Fortune 500 companies who have billions of accounts under their hood and since we had to store huge lot of data, SQLite was the one which we happened to implement and we were easily able to scale that to millions of customers. ### 40. The best tool for your mobile apps **Rating:** 4.5/5.0 stars **Reviewed by:** Daniela C. | System Engineer, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** December 23, 2017 **What do you like best about SQLite?** SQLite is anything but difficult to introduce and utilize. There is likely no better database for tenderfoots to begin finding out about running and utilizing a database. This likewise settles on it a brilliant decision for persevering information in an improvement domain. The speedy setup and convenience shield it from being a blocker for setting up an advancement situation. SQLite has a phenomenal documentation. **What do you dislike about SQLite?** It isn't appropriate to expansive scale applications. It is intended for lightweight frameworks, not for big business applications, or applications that need to scale essentially. It additionally does not have a few highlights of the bigger scale databases like MySQL including security, consents, and sort highlights. **Recommendations to others considering SQLite:** Realize what you require from a diligent information source. On the off chance that you are searching for something lightweight and simple to utilize, this is an incredible choice. **What problems is SQLite solving and how is that benefiting you?** I have utilized SQLite to endure information being developed conditions where I am not as worried about execution or highlight issues. It works awesome for this reason since you can get steup up rapidly, and get into the real advancement work. ### 41. Relatively easy to use even for first-timers **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Higher Education | Enterprise (> 1000 emp.) **Reviewed Date:** June 12, 2018 **What do you like best about SQLite?** I like the options SQLite gives to allow for command line interface as well as the different platforms supported (ie., Windows, Mac and Linux). Also because of its “lite”ness I can analyze rather large datasets and files efficiently. **What do you dislike about SQLite?** Like all programming, there is a learning curve requirement for using SQL, however it is not a huge drawback. I do wish there was more documentation to help with commands **What problems is SQLite solving and how is that benefiting you?** As a bioinformatics Researcher, I’ve used SQLite for parsing of large files (CSV) corresponding to genomic datasets, which I then performed statistical analyses on R. In this sense, SQLite has made my life much easier. ### 42. Great product for right project **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** October 25, 2018 **What do you like best about SQLite?** This works extremely well for small projects, easy to use, and easy to manage. **What do you dislike about SQLite?** The documentation I have found seems to make things harder than it actually is. **What problems is SQLite solving and how is that benefiting you?** Database for small projects/services. ### 43. Easy to use for Mobile or Hybrid app development **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** July 30, 2018 **What do you like best about SQLite?** It is very light weight database and easy to integrate with the angular based mobile apps. **What do you dislike about SQLite?** There are some limitation compared with the traditional or full veraion databases. **What problems is SQLite solving and how is that benefiting you?** Locally Stored all the mobile app and user information ### 44. Perfect for smaller sites without need for comcurrency **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** July 31, 2018 **What do you like best about SQLite?** Exactly what my title says. Very nice and simple DB. Great command line features as well to make it very easy to use. **What do you dislike about SQLite?** It’s not concurrent, but it’s honestly not that big of an issue for most small to medium sized corps **Recommendations to others considering SQLite:** Again, it is for smaller simple projects. Ditch Access and use this instead. **What problems is SQLite solving and how is that benefiting you?** Simple, light, free, open source, and best of all: very easy to work with and maintain ### 45. Great database tool for applications **Rating:** 4.5/5.0 stars **Reviewed by:** Stefania S. | IT Specialist, Automotive, Enterprise (> 1000 emp.) **Reviewed Date:** December 20, 2017 **What do you like best about SQLite?** I made numerous portable applications, and I frequently workd with SQLite, and it is nice to work with SQLite to spare my in-application information. It is easy to use, quick and smooth. With this tool I can simple find information, seek and sort. **What do you dislike about SQLite?** For the moment I like all, no dislikes, and exceptionally content with SQLite for applications. I don't utilize SQLite for site for work area application since I think it is too little for those sorts of application. **Recommendations to others considering SQLite:** SQLite is a must-have in your versatile application to spare data, stacking information and finding - arranging information, incorporating data spared with information in it. **What problems is SQLite solving and how is that benefiting you?** Versatile applications.Simple to spare information, connecting information, and discovering, arranging information. All that I have to work with information can be simple do with SQLite ### 46. Database for small storage purposes **Rating:** 4.5/5.0 stars **Reviewed by:** Suraj D. | Embedded Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** December 07, 2017 **What do you like best about SQLite?** The best thing is light weight, Not too much big footprint. This can easily utilized in small memory projects. Like embedded system applications are good fit for it. I like the best all SQL queries are valid in it. You will feel like working in SQL. **What do you dislike about SQLite?** I had interface with C++ so i don't like the long connection strings. If hard to debug , keep track of the open and to close the all open connections,, otherwise can be different behavior. **What problems is SQLite solving and how is that benefiting you?** I used inside the Vehicle Infotainment system. In the Infotainment system there is a concept of different user logged in. So keep track of every user in the system, so you can see all the valid apps and other Vehicle Infotainment related settings. ### 47. Optimal DBMS **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Higher Education | Enterprise (> 1000 emp.) **Reviewed Date:** July 31, 2018 **What do you like best about SQLite?** Easy to use, secure and fast. SQLite is the most popular database engine. ACID properties are critical for transactions. **What do you dislike about SQLite?** Rigid structure, unlike MongoDB which is flexible and unstructured. **Recommendations to others considering SQLite:** Document-based structure would be better than table-based format. **What problems is SQLite solving and how is that benefiting you?** Organized data schema and RDBMS for data and operations. ### 48. Can't Beat Free But Tread Lightly **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Chemicals | Enterprise (> 1000 emp.) **Reviewed Date:** December 28, 2017 **What do you like best about SQLite?** That it's free and small to implement. Great for mobile development and has a large user case and community. **What do you dislike about SQLite?** That it can't support Stored Procedures and can be very difficult if you are going to have multiple processes accessing your data at once you are going to have a bad time. **Recommendations to others considering SQLite:** If you are considering SQLite for mobile development then I would stop considering and pull the trigger. It's similar to SQL and the feature is pretty great for a free alternative. **What problems is SQLite solving and how is that benefiting you?** The business problems I solved with SQLite are that I have a database I can use, for free when developing brand new mobile apps. It's very similar to SQL, which I use commercially, and supports enough features that it is a no brainer to use. There really any benefits other then I have a go to when starting a new mobile app that requires a database backend. ### 49. Easy to use and powerful **Rating:** 5.0/5.0 stars **Reviewed by:** Misagh N. | Biochemistry PhD student and Research Assistant in Computational and Systems Biology, Higher Education, Enterprise (> 1000 emp.) **Reviewed Date:** September 19, 2017 **What do you like best about SQLite?** What I like about SQLite is the simplicity of installation process and usage. It integrates easily with my python. With the minimum knowledge that I had about SQL systems, I could easily complete two nice projects with SQLite. **What do you dislike about SQLite?** I don't have a deep knowledge of the database software packages and therefore am not qualified to tell what could be better. But from what I experienced, I didn't have any specific difficulty with anything in SQLite software. **What problems is SQLite solving and how is that benefiting you?** I used SQLite for two smaller projects in my PhD. I organized many separate data tables of that had relations to one another using python and SQLite. The outcome was super nice, because I could quickly filter through large sets of data and specify a certain relationship and make a subset fulfilling that requirement. Some of these tasks could take a day on my desktop, while using SQLite It could be as fast as minutes. ### 50. SQLite can do easy database stuff easily **Rating:** 5.0/5.0 stars **Reviewed by:** Tanim I. | Design Physicist, Research, Enterprise (> 1000 emp.) **Reviewed Date:** January 09, 2018 **What do you like best about SQLite?** It just works, it's a simple file-based database. The python plugins to SQLite are very high quality. **What do you dislike about SQLite?** I can think of nothing I dislike. Sometimes even sqlite is overkill. A JSON file would be sufficient for many of my use cases. **Recommendations to others considering SQLite:** Great for simple use cases and applications. **What problems is SQLite solving and how is that benefiting you?** Configuration data. ## SQLite Discussions - [Where can i find better documentation for SQLite? Any tutorials?](https://www.g2.com/discussions/41315-where-can-i-find-better-documentation-for-sqlite-any-tutorials) - 1 comment, 1 upvote - [Is SQLite free to use?](https://www.g2.com/discussions/is-sqlite-free-to-use) - 1 comment - [View SQLite pricing details and edition comparison](https://www.g2.com/products/sqlite/reviews?filters%5Bcompany_segment%5D%5B%5D=181§ion=pricing&secure%5Bexpires_at%5D=2026-08-09+16%3A30%3A36+-0500&secure%5Bsession_id%5D=528ba8fa-0ac7-4292-8fa4-db75d3a697aa&secure%5Btoken%5D=acb602ebb0cc368148992ebf28f47d114eadfee4b38e0b8bf4b2945765102657&format=llm_user) ## SQLite Integrations - [Visual Studio Code](https://www.g2.com/products/visual-studio-code/reviews) ## SQLite Features **Management ** - Data Schema - Query Language - ACID - Complaint - Data Replication **Support ** - Text Search - Data Types - Languages - Operating Systems **Security** - Database Locking - Access Control - Encryption - Authentication **Performance ** - Disaster Recovery - Data Concurrency - Workload Management - Advanced Indexing - Query Optimizer **Database Features** - Storage - Availability - Stability - Scalability - Security - Data Manipulation - Query Language ## Top SQLite Alternatives - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) - 4.4/5.0 (2,128 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) - 4.4/5.0 (1,583 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) - 4.3/5.0 (935 reviews)