--- 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-08-04' 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, 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. 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. ### 2. 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 ### 3. Need Offline Feature in yory app, Lets use SQLIte **Rating:** 4.0/5.0 stars **Reviewed by:** Adnan N. | Manager, Computer Software, Mid-Market (51-1000 emp.) **Reviewed Date:** October 06, 2023 **What do you like best about SQLite?** Very easy to integrate and provides same queries set that we have in normal SQL **What do you dislike about SQLite?** Database versioning needs to be handled manually in the different versions of mobile application **What problems is SQLite solving and how is that benefiting you?** Persistent storage of mobile application data. To provide user with offline capabilities ### 4. Better DataBase for Androids **Rating:** 4.0/5.0 stars **Reviewed by:** Keerthi Perumal D. | DC Analyst, Small-Business (50 or fewer emp.) **Reviewed Date:** November 07, 2023 **What do you like best about SQLite?** It's ease to use, low cost and to develop Android apps this would be used. **What do you dislike about SQLite?** Documentation wise we don't see more details like it's competitive DBs **What problems is SQLite solving and how is that benefiting you?** We have used this to build a medium level Android application, it is easy to learn ans integrate with Application ### 5. SQLite A Cool Database **Rating:** 3.5/5.0 stars **Reviewed by:** Muhammad T. | Business Analytical Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** August 28, 2023 **What do you like best about SQLite?** There are following positive feature in SQLLite: 1) Secure 2) Portable 3) Easy to Use 4) Less Heavy **What do you dislike about SQLite?** May performance issues for large database **What problems is SQLite solving and how is that benefiting you?** Beacuse it is very lightweight, we can easly featch data from databse. we can face less performance issues. ### 6. Most used database in the world. **Rating:** 4.0/5.0 stars **Reviewed by:** Rujuta J. | Sr. Associate Projects , Small-Business (50 or fewer emp.) **Reviewed Date:** February 06, 2023 **What do you like best about SQLite?** It is a relational database designed to manage and provide a way for software applications on their own. It is serverless i.e. No Server processes needed to be configured It requires no configuration which makes it easy to use. Since it loads only the needed data the performance is good. **What do you dislike about SQLite?** It does not allow remote work, i.e. it can be worked on the machine itself. It is not suitable for large scale applications. So Desktop or phone are best devices on which it can be used. It is less optimal. Also it has a kimited database size i.e. size of data is limited on the disc on which it is stored. **What problems is SQLite solving and how is that benefiting you?** It is vital to keep localized data, a small amount of data. It is handy and easy to install and use. It also does not require much support from the OS, making it convenient. ### 7. Good experience with SQLite 3 **Rating:** 4.0/5.0 stars **Reviewed by:** Abhishek U. | Problem Setter, Small-Business (50 or fewer emp.) **Reviewed Date:** February 16, 2023 **What do you like best about SQLite?** It is lightweight software that can be very useful for small projects. I used it with my Tkinter project to store, manage and fetch data from the database and it was a great experience using, it's connectivity was great and quick. **What do you dislike about SQLite?** There was nothing to dislike about SQLite in my knowledge it was an amazing experience using this application. Still the interface of the application can be improved. **What problems is SQLite solving and how is that benefiting you?** I used it with my project of management system to store, manage and fetch data of various patients from the database. It is quick and simple to use for creating, managing and connecting it with our primary code. ### 8. 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. ### 9. 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. ### 10. Light weight db for application development **Rating:** 4.0/5.0 stars **Reviewed by:** Tins K. | Senior Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** February 25, 2022 **What do you like best about SQLite?** Its very light weight db so that we can integrate as our default db in the application. Django like web frameworks uses swlite as a default database. ORM support is also provided in sqlite. **What do you dislike about SQLite?** There are some limitations for the storage capacity. Aslo not suitable for large scale application. Sometimes we may face higher latency while querying is a big problem. **What problems is SQLite solving and how is that benefiting you?** Its very light weight so we can easily integrate with our applications. Caching data can be stored in sqlite so that while it can be uploaded to the main db when its come to online again. ### 11. 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. ### 12. It's a good db to save data localy **Rating:** 3.5/5.0 stars **Reviewed by:** hussein a. | Flutter Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** April 20, 2022 **What do you like best about SQLite?** Fast and secure local database (off line db) **What do you dislike about SQLite?** Not really easy way to store data localy **Recommendations to others considering SQLite:** I recomend to use sqlite if you have a background of sql commands **What problems is SQLite solving and how is that benefiting you?** Offline storage with minimal storage and Memory usage ### 13. 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. ### 14. Great solution providing fast and lightweight needs **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Management Consulting | Small-Business (50 or fewer emp.) **Reviewed Date:** January 04, 2022 **What do you like best about SQLite?** SQLite was a great solution for us when we needed a database to be stored for a simple tool that we were building. The performance seemed great and it was very stable. **What do you dislike about SQLite?** More complex solutions may struggle to use this tool, I think it is definitely for a particular use primarily. We had a bit of issue setting it up initially but it wasn't anything terrible. **What problems is SQLite solving and how is that benefiting you?** We utilized SQLite for working with a small database within our application of storing user preferences. It was much easier to work with for a simpler solution like this. ### 15. 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. ### 16. SQLite for small application **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Higher Education | Mid-Market (51-1000 emp.) **Reviewed Date:** June 10, 2021 **What do you like best about SQLite?** The foremost thing I like about this software is that it is super light-weighted, portable, and relatively faster than other databases like MYSQL, Postgresql, etc. Another thing I like about this is that you don't need to install and made any configuration in order to use this database. You can simply, download the SQLite libraries and use this in your application. The query is also quite similar to MYSQL, so this software can be easily learned and used by the user who has experienced with MYSQL. It can be easily used to built mobile applications. Storing the data as local storage in the android applications can be one of the best use of this SQLite. With its fast performance and light weightiness, SQLite stand out to be a good database for small applications that require minimum data storage. **What do you dislike about SQLite?** However, due to its light weightiness, SQLite does not have many features including store procedure. It is not suitable for complex and large system architecture. It has a limited data storage capacity of only 2 GB which is a bit unsatisfying. Despite, its weakness, it is still a good choice for a small application that requires minimum data storage and has simple architecture. **What problems is SQLite solving and how is that benefiting you?** To be honest, I have used SQLite once for my Android Application to store the add-to-cart data so that it would perform the operations quickly. Unlike the use of other databases, SQLite was fast and I can easily embed it into the applications. ### 17. SQLite very useful tool for backend developers **Rating:** 3.5/5.0 stars **Reviewed by:** Shivam G. | Technical Lead, Mid-Market (51-1000 emp.) **Reviewed Date:** December 27, 2021 **What do you like best about SQLite?** Query writing is very easy and SQLite is very easy for the new comers and also for the existing users **What do you dislike about SQLite?** Product costing little expensive compare to other tool **What problems is SQLite solving and how is that benefiting you?** Actually I am a software professional so this tool is very important for my query writing and database handy ### 18. Best way to store your data using very less queries and store and manage the data **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** January 19, 2022 **What do you like best about SQLite?** The performance,optimization, and for backup is best to use SQLite. **What do you dislike about SQLite?** The main reason to dislike is that it doesn't support concurrency. **What problems is SQLite solving and how is that benefiting you?** The problem I have faced in other database is data structured issue, in sqlite it was solved, data is in structured manner. ### 19. Fast and reliable DB engine **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** August 17, 2021 **What do you like best about SQLite?** The fast and reliable solution which could be used on desktop and mobile. **What do you dislike about SQLite?** Requires some SQL background. Limited scripting abilities. **What problems is SQLite solving and how is that benefiting you?** The best db engine solution for mobile platforms. It was easy to implement db storage on iOS. ### 20. Good for fast on the fly and client side mostly **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Automotive | Small-Business (50 or fewer emp.) **Reviewed Date:** April 20, 2021 **What do you like best about SQLite?** Lightweight and easy to use on multiple platforms **What do you dislike about SQLite?** Scalability. I can't use it across multiple servers as i would like without fuss. **Recommendations to others considering SQLite:** Start small **What problems is SQLite solving and how is that benefiting you?** Single instance javascript connection issues and synchronous communication. ### 21. Light weight Database **Rating:** 4.0/5.0 stars **Reviewed by:** Nasrullah N. | Application Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** July 28, 2020 **What do you like best about SQLite?** Great data storage Used for android development which is lighter and best use of queries to retrieve data the way we wanted **What do you dislike about SQLite?** SQLite has become old while new DB has being introduced in the today’s world where SQLite usage has dropped in development **What problems is SQLite solving and how is that benefiting you?** Easy use of writing real-time sql queries withing the app development and storing light data such as user details. SQLite can be used instead of share preferences ### 22. 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. ### 23. SQLite is beneficial for those without a coding background **Rating:** 4.0/5.0 stars **Reviewed by:** Allyson I. | Web Developer (University Communications), Higher Education, Small-Business (50 or fewer emp.) **Reviewed Date:** September 10, 2019 **What do you like best about SQLite?** I like how this product makes it easy for anyone to use sql. I used it to integrate a database into a website and it worked wonderfully. I am familiar with sql but a lot of people in my group weren’t and this was helpful for them. **What do you dislike about SQLite?** The software looks a little outdated. I think that you could make the interface prettier and have little information icons that you can hover that explain what each thing is. It would be nice to have an online version and not just the software you have to download. **Recommendations to others considering SQLite:** I do like it **What problems is SQLite solving and how is that benefiting you?** I needed to put a database into a website using JavaScript. It was super helpful to have all of the features that it has ### 24. Lightweight and powerfull embed database **Rating:** 4.0/5.0 stars **Reviewed by:** Andy Larry R. | Informaticien études et développement, Small-Business (50 or fewer emp.) **Reviewed Date:** May 20, 2019 **What do you like best about SQLite?** - Easy to setup and configure - Really fast to setup and to maintain - Very lightweight and usable for embedded applications - Open source and free to use - Very efficient and suitable for speed programming - Universal relationnal database language (SQL) **What do you dislike about SQLite?** - The database is store on file system which increase hacking risk - Need more optimisation to work with application which use multithreaded tasks. - Not suitabe for big data and datawarehousing (Business intelligence module) **Recommendations to others considering SQLite:** - Best for data storage within mobile applications - Really easy to use and no need to be an expert - Really fast for mobile application data transactions - I really recommend SQLite for anyone who want to build mobile application as fast as possible. **What problems is SQLite solving and how is that benefiting you?** - Data storage for embedded application such as Android apps or IoS apps. - Local data storage for mobile application (offline data manipulation after remote data synchronization) - Remote data synchronisation of web apps and mobile apps ### 25. very useful to create and manage databases **Rating:** 3.5/5.0 stars **Reviewed by:** Ali N. | Mr., Mid-Market (51-1000 emp.) **Reviewed Date:** July 26, 2019 **What do you like best about SQLite?** It is very simple to share databases. Just copy one file to do so. This is what makes it easy for me to provide you with the essential SQL sample database. **What do you dislike about SQLite?** SQLite doesn’t support the date or timestamp data types. This is a disadvantage as many SQL puzzles, thus learning opportunities, are out of our reach in the beginning. **Recommendations to others considering SQLite:** It s recommended to learn sqlite because obviously with its benefits, one day you will see it **What problems is SQLite solving and how is that benefiting you?** I always create small databases with sqlite ### 26. Simple and Performant **Rating:** 3.5/5.0 stars **Reviewed by:** Chintan D. | Small-Business (50 or fewer emp.) **Reviewed Date:** August 30, 2018 **What do you like best about SQLite?** SQLite offers very simple database solution. It is very generic and switching to another system is relatively easier. It's very easy and painless to setup. **What do you dislike about SQLite?** Simplicity comes at a cost of performance. It is not the most performant database. **Recommendations to others considering SQLite:** Use it for small and simple applications. But do not use it for big or high-performance applications. **What problems is SQLite solving and how is that benefiting you?** We are using SQLite as our database server. We have had productivity boosts from database admins. ### 27. 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. ### 28. "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. ### 29. Very Helpful for review my data stored **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** August 28, 2019 **What do you like best about SQLite?** The way it handling the data for user to check and review **What do you dislike about SQLite?** I dis not find much flaws in this , if there i will update **What problems is SQLite solving and how is that benefiting you?** i Can review what are things i am doing ### 30. 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 ### 31. SQLite **Rating:** 4.0/5.0 stars **Reviewed by:** Andrew F. | Founder, Small-Business (50 or fewer emp.) **Reviewed Date:** January 24, 2019 **What do you like best about SQLite?** SQLite is a very important database library that many open source software uses. It also has a self contained database system as well. SQLite is very small and fast. It also can be run and embedded in specific applications. **What do you dislike about SQLite?** I do not dislike much about SQLite except the fact that its difficult to use at times. Also sometimes its slow especially with big Databases **Recommendations to others considering SQLite:** Use only for embedded databases to make small scale applications work. (I.e. locally installed programs with no LAN or WAN connection) **What problems is SQLite solving and how is that benefiting you?** SQLite is just another free database and interface. It does what I need it to do. ### 32. Compact, light and easy to deploy **Rating:** 3.5/5.0 stars **Reviewed by:** George G. | GIS & Database Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** July 10, 2018 **What do you like best about SQLite?** SQLite is a full-featured SQL implementation which you can start using with zero configuration as no setup or administration is needed. It is a serverless compact database in a single cross-platform disk file with a really small code footprint. It is free and it comes with SpatiaLite - an open source library which expands it's capabilities to handling spatial data. **What do you dislike about SQLite?** The The old school SQLite management systems and a number of lacking features: database level locking (SQLite only supports one writer at a time per database file), materialized views, intricate spatial indexes (GIST, GIN). **Recommendations to others considering SQLite:** You should by all means use SQLite (and SpatiaLite) for device-local storage, for application file formating and as a website database to back small to medium-sized websites. SQLite is fast and reliable and it requires no configuration or maintenance. You should avoid SQLite (and SpatiaLite) if you are developing Client/Server Applications, if you plan to handle very large datasets and if you expect high user writing concurrency. **What problems is SQLite solving and how is that benefiting you?** I use SQLite to hold user/program settings, preferences or other front end related data needed for programms I develop, to store spatial data on GIS in mobile devices (tablets & smartphones) and to transfer data from my other client/server databases, edit them offline and synchronize them with the live databases again. ### 33. SQLite certified from Coursera **Rating:** 3.5/5.0 stars **Reviewed by:** Raja B. | Power BI & Tableau Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** March 02, 2019 **What do you like best about SQLite?** It a very innovative and fast with respect to performance and debugging. More like. Microsoft sql server but still helpful for creating insights **What do you dislike about SQLite?** Nothing much new if we see the other databases like oracle ibm db2 sql server and MySQL.. But still okay **What problems is SQLite solving and how is that benefiting you?** Finding insights from a large database consisting of millions of records in a very less time and building reports for the audience wisely. ### 34. SQL for mobile phones **Rating:** 4.0/5.0 stars **Reviewed by:** Julio G. | Software engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** September 12, 2018 **What do you like best about SQLite?** There are many things I like so much about Sqlite. We work with mobile devices and Sqlite is the best database administrator for that pruposes. We mostly deploy sales force automation solutions in mobile devices, so we need a light and free solution for our clients, because they have many devices and it not feasible buying licenses for all. Sqlite covers all our needs considering: speed, scalability, easy-to-use, SQL language based. It is very easy to install and to administrate. You don't need to have big knowledge to create a new database from scratch. It is portable, each database is only one file which you can copy and move easily. There are lots of free administrator software to open, manage and query a SQlite database. You can share this type of datebases between different OS devices, such us iOS or Android. They can be set in quite different ways, for showing the same data in different structures. Well, what more can I say, let's try it. **What do you dislike about SQLite?** It is not a type based database, this make it very flexible but sometimes it offers problems witn number precission. Sqlite offers a limited set of SQL language, which means you can not do some queries that you would do without any problem in other platforms. In that cases, you have to find workarounds to solve your issue. **Recommendations to others considering SQLite:** It is a free, light solution. You should try it. **What problems is SQLite solving and how is that benefiting you?** We mostly deploy sales force automation solutions. ### 35. 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. ### 36. 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. ### 37. 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 ### 38. 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. ### 39. 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. ### 40. 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 ### 41. 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 ### 42. 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 ### 43. 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. ### 44. 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 ### 45. 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. ### 46. 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. ### 47. 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. ### 48. 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. ### 49. 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 ### 50. Godd **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in E-Learning | Small-Business (50 or fewer emp.) **Reviewed Date:** July 17, 2018 **What do you like best about SQLite?** the best is the performance since the operations are more efficient and it is faster than MySQL and PostgreSQL and the portability is executed on many platforms and its databases can be easily carried out without any configuration or administration. **What do you dislike about SQLite?** Lack of documentation in Spanish: although there is already a Spanish-speaking community of SQLite, it would be important to find much more. documentation, books, review, etc. as many other database engines count today. **What problems is SQLite solving and how is that benefiting you?** Customer data management ## 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%5Bnps_score%5D%5B%5D=4§ion=pricing&secure%5Bexpires_at%5D=2026-08-06+06%3A51%3A37+-0500&secure%5Bsession_id%5D=12abe3ad-9d00-495b-a379-3ddaf698a064&secure%5Btoken%5D=0c417d2b88d5c1f083012a3a4e345a387989e86c241f875cc33427b623e3beaf&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,127 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 (933 reviews)