--- title: SQLite Reviews meta_title: 'SQLite Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 261 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: 261 scale: '5' date_modified: '2026-06-24' 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:** 261 ## 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 and straightforward for various applications. (2 reviews) - Users appreciate the **ease of use** of SQLite, finding it fast and lightweight for mobile applications. (1 reviews) - Users appreciate the **impressive management system** of SQLite, enhancing their overall experience and usability. (1 reviews) - Users love the **speed and lightweight nature** of SQLite, making it perfect for mobile app development. (1 reviews) - Users admire the **impressive user interface** and management system, enhancing their overall experience with SQLite. (1 reviews) **What users dislike:** - Users find SQLite's **difficult learning curve** and limitations in handling large traffic challenging. (1 reviews) - Users note the **lack of features for the admin side** in SQLite, making management more challenging. (1 reviews) - Users find the **limited database support** of SQLite inconvenient for high traffic and lacking built-in user accounts. (1 reviews) ## SQLite Reviews ### 1. The best for quick database development **Rating:** 5.0/5.0 stars **Reviewed by:** Eduardo A. | Game Programmer, Small-Business (50 or fewer emp.) **Reviewed Date:** January 20, 2019 **What do you like best about SQLite?** Is built in directly on mobile devices. If you know Sql, this is pretty straightforward to follow in development. Is fast development for quick databases. **What do you dislike about SQLite?** May be a bit "hard" if you want to develop bigger databases with more complex relationships. It doesn't have a direct desktop IDE or something that helps you with the database creation (like mysql). **What problems is SQLite solving and how is that benefiting you?** Specifically for Android development, we need to store some data from games we have, and this is the best solution for doing that. ### 2. Best choice for testing purpose **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** May 29, 2019 **What do you like best about SQLite?** I like sqlite3 because it does not require a server to work with. And also it is much faster when compared to other databases. **What do you dislike about SQLite?** The one think I didn't like it because it is not much secure and not a best choice for production. **What problems is SQLite solving and how is that benefiting you?** I used it because it is well suited for testing purposes. ### 3. Super easy **Rating:** 5.0/5.0 stars **Reviewed by:** Arthur G. | MR, Small-Business (50 or fewer emp.) **Reviewed Date:** December 27, 2018 **What do you like best about SQLite?** Easy to install, configure, and administer on Linux, Mac, or Windows. **What do you dislike about SQLite?** We don't dislike anything. Even the performance is good enough for many purposes. We can easily switch to MySQL, MariaDB, or PostgreSQL, and rarely do so. **Recommendations to others considering SQLite:** Some cloud vendors make SQLite deployment difficult. Not SQLite's fault. **What problems is SQLite solving and how is that benefiting you?** Rapid application development, with less DB related effort. ### 4. 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. ### 5. SQLite as old MSSQL DBA **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Utilities | Small-Business (50 or fewer emp.) **Reviewed Date:** November 10, 2018 **What do you like best about SQLite?** Easy to use, manage and keep updated, simple to attach on your Projects, simple VS integration and develompent is good recived. Easy to package with your application, and fast compresion with you are packaging with a new App. Large compatibility with so mane OS and platforms, like Android, or IOS, well in my case I used with C# and embeded my DB with the application was easy, the idea to be just a simple file make my work easy in some many ways, you don't need a full RDBMS or install a portable server to use it, just a DLL and that's all. With a couple of payed tools you can sync data or even make a big data repository. **What do you dislike about SQLite?** No relative ubication path, the files are needed to use full path, thats sometimes hard to determinate and use. Reduced features like Unions and Joins by side for example, Right Join or even Triggers arn't well implemented. Reduced Data types are a Disadvantage too, Text works well but sometimes you need somenting more complete Numeric is usefull but you need more **Recommendations to others considering SQLite:** Absolutly YES!!!!!!!!!!!! so easy to use, well as DBA for Oracle and MSSQL any SQL variation are easy to use, but combined to C# development are great to use **What problems is SQLite solving and how is that benefiting you?** Use combined to create Electronic Invoices, quick and lightweight transaccion, low resourses consumptions, and easy to install on client PCs ### 6. LightWeight Database **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** July 02, 2019 **What do you like best about SQLite?** It is light weight db. We can use it in Mobile Applications. **What do you dislike about SQLite?** Some Queries does not work in this. We can not delete a column. **What problems is SQLite solving and how is that benefiting you?** Using it for development of apps for local storage. ### 7. Fantastic for what it is. **Rating:** 4.5/5.0 stars **Reviewed by:** Carson W. | CTO, Small-Business (50 or fewer emp.) **Reviewed Date:** February 01, 2019 **What do you like best about SQLite?** It is a flat file database so its portable, and simple. It is great if you are looking for those features. **What do you dislike about SQLite?** It has query limitations, but otherwise there isn't much to complain about, just don't use it for a main data intensive application database. **Recommendations to others considering SQLite:** Like anything use the right tool, don't hammer in a screw. This is a solution that in certain situations is fantastic. **What problems is SQLite solving and how is that benefiting you?** Portability ### 8. Most effective local database for my android mobile application developments **Rating:** 4.5/5.0 stars **Reviewed by:** Sachintha H. | Software Engineer, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** March 17, 2019 **What do you like best about SQLite?** Easy to work and configuration, it is database management tool for web developments. **What do you dislike about SQLite?** some SQL syntax are not support .string concatenation of schema it is difficult. **Recommendations to others considering SQLite:** easy to use even beginners. **What problems is SQLite solving and how is that benefiting you?** testing with sample stored data in android application ### 9. 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. ### 10. My SQLite Review **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Utilities | Small-Business (50 or fewer emp.) **Reviewed Date:** April 10, 2019 **What do you like best about SQLite?** The best database for beginners to learn how to tinker with database management systems. **What do you dislike about SQLite?** For being a lightweight version database they lack enough functions that normally a robust database has. **Recommendations to others considering SQLite:** It is a super light and easy to use database for light applications. **What problems is SQLite solving and how is that benefiting you?** I used this database extensively on online gaming servers and to learn how to deal with database management systems. ### 11. 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 ### 12. Quick and reliable database without a server **Rating:** 4.5/5.0 stars **Reviewed by:** Juan M. | Project Manager, Information Technology and Services, Small-Business (50 or fewer emp.) **Reviewed Date:** September 10, 2018 **What do you like best about SQLite?** SQLite is a relational database system that allows you to have a database without the boilerplate of a complete database server. It has a lot of database features and well defining your database the performance can be good enough for your requirements. **What do you dislike about SQLite?** If you are looking for a real relational database system with multiple access for different sources, better do not use SQLite. This affirmation is even stronger if you are using your database in a Windows filesystem. **Recommendations to others considering SQLite:** Always define well your tables, create indexes and primary keys. It will speed the performance of the access to the database. **What problems is SQLite solving and how is that benefiting you?** We are using SQLite for a lot of applications that need to save relational data for itself: a communications driver, a system services and many other projects. ### 13. Decent for simple queery **Rating:** 2.0/5.0 stars **Reviewed by:** Verified User in Computer & Network Security | Small-Business (50 or fewer emp.) **Reviewed Date:** June 22, 2019 **What do you like best about SQLite?** Simple sql implementation for basic queery **What do you dislike about SQLite?** Too basic, needs to be more intuitive for users **Recommendations to others considering SQLite:** It’s easy **What problems is SQLite solving and how is that benefiting you?** For simple quueries ### 14. My best experience with SQLite is the deployment. SQLite is an embedded database. **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Computer Networking | Mid-Market (51-1000 emp.) **Reviewed Date:** March 12, 2019 **What do you like best about SQLite?** the deployment. SQLite is an embedded database. So much so, that to use it in a .NET application it is enough to reference a single assembly. **What do you dislike about SQLite?** The problems with the installation of SQL Express are leading me to consider the use of embedded databases for an application that I develop in my work. **Recommendations to others considering SQLite:** It's a cheap software and easy use **What problems is SQLite solving and how is that benefiting you?** Cheap software of database and easy use. ### 15. Very effective **Rating:** 4.0/5.0 stars **Reviewed by:** Matt B. | software developer/ IT consultant, Small-Business (50 or fewer emp.) **Reviewed Date:** February 27, 2019 **What do you like best about SQLite?** Works great for all the stores procedures we use on the websites search and exchange **What do you dislike about SQLite?** Something that many team members don't like is the exporting of data does not allows transfer accurately **What problems is SQLite solving and how is that benefiting you?** Searching and exchange of data ### 16. Lightweigt, fast, easy to setup **Rating:** 4.5/5.0 stars **Reviewed by:** David Z. | Full Stack .Net Developer, Information Technology and Services, Small-Business (50 or fewer emp.) **Reviewed Date:** February 28, 2019 **What do you like best about SQLite?** It's lightweigt, fast, easy to setup. Nice development tools available. Integrates with latest .NET technologies really nicely. **What do you dislike about SQLite?** Unable to connect to database remotely in most situations. **What problems is SQLite solving and how is that benefiting you?** Backend database for crossplatform web application. ### 17. SQLite is a very light weighted database **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** March 02, 2019 **What do you like best about SQLite?** SQLite is very easy to learn. Reading and writing operations are very fast for SQLite database. It can be used with all programming languages without any compatibility issue. **What do you dislike about SQLite?** SQLite is used to handle low to medium traffic HTTP requests. Database size is restricted to 2GB in most cases. **What problems is SQLite solving and how is that benefiting you?** I was used SQLite in our node.js application to handle database.It is easy to learn and very fast in work. ### 18. Works good for removing unwanted builtin Windows 10 applications **Rating:** 5.0/5.0 stars **Reviewed by:** Lee L. | IT Technical Support Specialist, Mid-Market (51-1000 emp.) **Reviewed Date:** October 19, 2018 **What do you like best about SQLite?** I used this to remove unwanted builtin apps like xbox and MS Edge from my Windows 10 PC. **What do you dislike about SQLite?** I cannot think of any reasons why to dislike this application. **What problems is SQLite solving and how is that benefiting you?** Remove Microsoft Edge and unwatnted native windows 10 apps on a business PC. ### 19. Opensource small and easy to deploy databsae **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** August 12, 2018 **What do you like best about SQLite?** It is super easy to get up and running. All you need is a library for whatever language you are using to get up and moving using it. Doesn't require specific server installations or user accounts. You just need to have a library that supports it in whatever programming language you are using. It's very simple and easy to deploy. I can rotate databases very simply just by moving a file, which is great depending on your problem set. **What do you dislike about SQLite?** The biggest con is that you can't scale it or use it for anything complex. It stores everything in a single file, which can lead to slower write speeds, especially compared to more complex systems like MySQL, when you are using it for bigger things. That single file could get very large too, and be a problem if you are on a limited file system like say FAT32 (unlikely, but anything is possible). **Recommendations to others considering SQLite:** If you need something that you can get up and running fast. Use between systems, and runs light, then it's the solution for you. Doesn't have much for security and the like, but for small applications it can work really well. **What problems is SQLite solving and how is that benefiting you?** I'm using it for storing data gathered from the cryptocurrency market. It allows me to rotate the database super easy, and to have different data sets for testing against. Writing can be sluggish compared to storage in RAM or other database systems so you should only write when you need to. ### 20. 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 ### 21. 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 ### 22. Great tool for relationship database management **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** November 27, 2018 **What do you like best about SQLite?** I like that the tool is great relationship database tool for people who are not hard-core programmers. I started as a beginner program and quickly picked up SQLite. **What do you dislike about SQLite?** I don't like that the interface is not very intuitive and user-friendly. **What problems is SQLite solving and how is that benefiting you?** We are managing a lot of climate and weather data and the tool is great to keep the data organized. It is also useful to organize your business contacts. I realized that when you deal with a lot of data that have relationship with each other, Excel is no long sufficient. ### 23. SQL lite review **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** March 10, 2019 **What do you like best about SQLite?** SQL lite is a very robust and easy to use database engine. The file format is very stable and cross platform **What do you dislike about SQLite?** I don’t like how they haven’t updated it very much recently **What problems is SQLite solving and how is that benefiting you?** We used it for relational database management ### 24. Easiest database to set up and use **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** November 16, 2018 **What do you like best about SQLite?** It's the fastest database to setup and use. All of the data is stored in a single file. It's great if you want to test out a relational database with a small amount of data. **What do you dislike about SQLite?** Not much. For a while they didn't implement transactions. However, the use case is to use a lightweight database in your own development environment. **Recommendations to others considering SQLite:** This is a great database to use in your local developer environment. If you are learning how to use SQL, it is also a great education tool. **What problems is SQLite solving and how is that benefiting you?** It makes it easy to develop and prototype software. ### 25. Made for very little **Rating:** 2.5/5.0 stars **Reviewed by:** Juan Antonio M. | Analista programador, Small-Business (50 or fewer emp.) **Reviewed Date:** July 27, 2018 **What do you like best about SQLite?** It is a minimal database to be used from a mobile device and consumes very little memory, it works but has no relations. The best part is that it takes up very little space and is very easy to bring and carry. **What do you dislike about SQLite?** It has no relationships and is very linear, clients get hung up easily. Since it is such a linear database, data must be stored in that way, keeping in mind that it is to minimally feed data to the mobile device. **Recommendations to others considering SQLite:** A very small database **What problems is SQLite solving and how is that benefiting you?** for small mobile applications that need a database and small storage, our product is the solution. ### 26. SQLite in development **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** February 28, 2019 **What do you like best about SQLite?** ItSqlite is so easy use, if you have anything to very fast, it is the best choice **What do you dislike about SQLite?** I can not say that there are disadvantages, it is doing its job good **What problems is SQLite solving and how is that benefiting you?** I usually use for web development of ruby on rails ### 27. SQlite for mobile dev **Rating:** 4.0/5.0 stars **Reviewed by:** Victor M. | Mid-Market (51-1000 emp.) **Reviewed Date:** July 30, 2018 **What do you like best about SQLite?** It is a good alternative to store data locally and then be able to perform some synchronization with another online database. It is very fast to integrate and very easy to use **What do you dislike about SQLite?** Sometimes errors occur and the messages are not very descriptive. It is necessary to investigate to find the error and a lot of time is lost in it. For some operations it is not the best option since the reading is slow **Recommendations to others considering SQLite:** If you are going to read large volumes of data it is better to look for another alternative such as Realm for example **What problems is SQLite solving and how is that benefiting you?** We synchronize mobile devices to perform offline work in mining operations ### 28. Sqlite **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** February 25, 2019 **What do you like best about SQLite?** Sqlite is a library writen using C, To handle relationnal database. It s simple To use, the Best for demo projects. **What do you dislike about SQLite?** It cant handle big architectures, it become difficult To use. **What problems is SQLite solving and how is that benefiting you?** It s Great for développement mobile. ( Android ) ### 29. 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 ### 30. 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. ### 31. 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. ### 32. 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. ### 33. Best for educational purpose **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Oil & Energy | Mid-Market (51-1000 emp.) **Reviewed Date:** January 10, 2019 **What do you like best about SQLite?** The ease of use , UX and UI. Very relevant to the industry. **What do you dislike about SQLite?** Nothing in particular. It is all good as of now. **Recommendations to others considering SQLite:** Can be used upfront. One of the best in the market and hence a lotto people use it! **What problems is SQLite solving and how is that benefiting you?** Data Manipulation, data scaling and merging ### 34. Best light weight database **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** February 20, 2019 **What do you like best about SQLite?** Easy to setup and integrates well with other tools **What do you dislike about SQLite?** Documentation should be improved and there is not much to dislike. **What problems is SQLite solving and how is that benefiting you?** Best suited for light weight application ### 35. Indispensable tool for mobile development **Rating:** 5.0/5.0 stars **Reviewed by:** P R. | Head of Software, Mid-Market (51-1000 emp.) **Reviewed Date:** July 31, 2018 **What do you like best about SQLite?** Lite - there's a reason it's called that. So tiny and lightweight a footprint that it always comes first when wanting a database solution for an offline database. **What do you dislike about SQLite?** Very little - possibly Entity Framework's implementation is restrictive, but that's a Microsoft issue TBH. **What problems is SQLite solving and how is that benefiting you?** Offline, mobile database storage that scales and scales. ### 36. 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. ### 37. SQL Lite is perfect for mobile devices, quick/easy DB jobs **Rating:** 4.0/5.0 stars **Reviewed by:** Ryan G. | Advanced Clinical Applications and Analytics Coordinator, Hospital & Health Care, Mid-Market (51-1000 emp.) **Reviewed Date:** July 30, 2018 **What do you like best about SQLite?** SQL Lite essentially gives you the full functionality of standard SQL--with very little configuration. It's nice and compact, quick to install and will have you database exploring in no time. **What do you dislike about SQLite?** It does lack some of the depth of standard SQL however rich it is for a small compact version. I've had some issues with load times as well occasionally. **What problems is SQLite solving and how is that benefiting you?** For quick exploration of missing data or GIS information on mobile devices--this is the product. Find your IOS backup, start exploring. ### 38. Easy to use and easy on resources server side **Rating:** 5.0/5.0 stars **Reviewed by:** Chris S. | Assistant Information Systems Specialist, Small-Business (50 or fewer emp.) **Reviewed Date:** February 15, 2018 **What do you like best about SQLite?** It allows a lot of reads and writes simultaneously and when you have an entire office accessing your database at once, caching and parallel access is essential. **What do you dislike about SQLite?** Loading UI elements on the screen takes a long time on older computers. **Recommendations to others considering SQLite:** One thing to consider when using SQLite, is when you draw tables on a GUI, it will take a considerable amount of time for on screen elements to load unless you choose to have all items load in parallel. This requires a more robust workstation video card, but items will load more efficiently **What problems is SQLite solving and how is that benefiting you?** Running SQLite has allowed the doctors office I set up to move from traditional filing to e-filing on computers. This saves a tremendous amount of time. The benefit of SQL compared to CSV tables is obvious. The only factor in efficiency is the server bottleneck. When you use CSV tables or other types of database access, many times only one person at a time can access the data. However SQL is scalable and multiple sessions are supported with incremental changes allowed. ### 39. 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. ### 40. 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. ### 41. 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. ### 42. SQLite **Rating:** 4.0/5.0 stars **Reviewed by:** Carlos F. | Mid-Market (51-1000 emp.) **Reviewed Date:** October 10, 2018 **What do you like best about SQLite?** Light and fast for small developments **What do you dislike about SQLite?** It lacks many functions that other languages have. **What problems is SQLite solving and how is that benefiting you?** Save data for a BI. No need to install any additional software. ### 43. Very easy to use and effective **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Health, Wellness and Fitness | Small-Business (50 or fewer emp.) **Reviewed Date:** December 12, 2018 **What do you like best about SQLite?** I like how it is very easy to use and deploy **What do you dislike about SQLite?** It is very hard to find other other APIs that open its filetype **What problems is SQLite solving and how is that benefiting you?** Database management ### 44. I like SQLite **Rating:** 4.0/5.0 stars **Reviewed by:** Diana P. | System Engineer, Management Consulting, Mid-Market (51-1000 emp.) **Reviewed Date:** January 21, 2018 **What do you like best about SQLite?** I like SQLite because it is easy to install it and easy to use it. The updates are also easy to install without losing my old progress. It is compatible with my python. With the base information that I had about SQL, I could make many decent tasks with SQLite. **What do you dislike about SQLite?** I don't have a profound learning of the database programming and is hard for me to tell you about bad things. At the moment I don’t have bad experiences with SQLite. **Recommendations to others considering SQLite:** You don’t need a technical background in SQL language for this tool. **What problems is SQLite solving and how is that benefiting you?** I utilized SQLite for some big projects in my company. I sorted out many separate information like tables and columns I made the relations to each other utilizing python and SQLite. The result was a great database. My company got a fluid database and it’s working without gaps. ### 45. 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. ### 46. Review SQLite **Rating:** 3.0/5.0 stars **Reviewed by:** Laura E. | Analista - programadora, Small-Business (50 or fewer emp.) **Reviewed Date:** July 30, 2018 **What do you like best about SQLite?** The best thing is that it is a free and portable program, perfect for any small program. **What do you dislike about SQLite?** To make larger programs, it becomes somewhat tight when making the queries. **What problems is SQLite solving and how is that benefiting you?** For small projects, this program has been useful to us thanks to its great performance and easy installation. ### 47. Convenient portable functionality that works with a number of use cases **Rating:** 4.5/5.0 stars **Reviewed by:** Nexus W. | Web Developer, Internet, Small-Business (50 or fewer emp.) **Reviewed Date:** July 30, 2018 **What do you like best about SQLite?** SqlLite is easy to use, portable and performant. **What do you dislike about SQLite?** SQLite is not for every use case, and has limits. Although fast, it can not be used by more than one user at a time. **What problems is SQLite solving and how is that benefiting you?** Great for mobile apps and as as simple file based backend for web apps. ### 48. A strong system to build with **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** November 29, 2018 **What do you like best about SQLite?** The price and features you get with it , along with the easy install **What do you dislike about SQLite?** The support when some obscure issues happened **What problems is SQLite solving and how is that benefiting you?** Application database ### 49. Becoming the de facto built-in RDBMS solution for in-app storage needs. **Rating:** 5.0/5.0 stars **Reviewed by:** Andrew F. | Company Owner, Defense & Space, Small-Business (50 or fewer emp.) **Reviewed Date:** January 11, 2018 **What do you like best about SQLite?** SQLLite is a robust, one file solution. **What do you dislike about SQLite?** Based on its usecase nothing to dislike. **Recommendations to others considering SQLite:** If you’re looking at using SQLite then you know why you want to use it. It’s robust enough to be relied upon for what it is. It does not support multiple connections but this is basically a infinitely better solution over using the Jet driver. Good for mock testing, localized microservice storage and local app storage. **What problems is SQLite solving and how is that benefiting you?** In-App Structures Storage. Comes preinstalled on almost all modern Operating Systems. Windows 10 and OS X now ship with it. And it’s easy enough to embed if needed. The only down side is the likelihood and needing to compile it yourself is sometimes high. But it’s a single source file if SSL isn’t used. It’s easily embedable and makes for a robust Loca User/Session storage mechanism. Would not use for mission critical data storage. ### 50. 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. ## 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?page=3§ion=pricing&secure%5Bexpires_at%5D=2026-06-24+14%3A00%3A37+-0500&secure%5Bsession_id%5D=552121c3-183e-4670-a1cb-b1590f74f04a&secure%5Btoken%5D=4c4915f30d3702d4c765aeb2c11c44bef61a2e04b4e004e441251496e1548ecb&format=llm_user) ## SQLite Integrations - [Python](https://www.g2.com/products/python/reviews) - [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,127 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) - 4.4/5.0 (1,581 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) - 4.3/5.0 (929 reviews)