--- 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-07-17' 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. SQLite is a great RDBMS to use for research and starter projects. **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** August 07, 2021 **What do you like best about SQLite?** Python integration, easy to port, same SQL scripts for DDL and DML. Queries execute very fast **What do you dislike about SQLite?** It is not Production ready and is good for small size data. There are bunch of bugs as well **What problems is SQLite solving and how is that benefiting you?** Storing test results, training machine learning models ### 2. SQLite the small and fast database engine for web and mobile applications **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** December 15, 2017 **What do you like best about SQLite?** SQLite is the fast ad small database, ideal for small or big application (web, mobile, server or desktop). Don't require a server software and the DB file is portable to other platforms (Windows, UNIX, etc). Most popular software use SQLite (eg. yum repositories, Firefox, Tenable, Android, etc.) Cover most of SQL syntax and it's possible to create table, view, index, virtual table (eg. from a csv file or from a directory) and custom functions (via programming language). SQLite is supported by PHP5, Perl, C, Tcl, C++, C#, Python, Rust, and more programming language. **What do you dislike about SQLite?** SQLite not offer built-in security facility (eg. login, ACL and encryption) **Recommendations to others considering SQLite:** SQlite is the best choice for application prototyping and for redistributable application **What problems is SQLite solving and how is that benefiting you?** SQLite is ideal with environment with less space or memory ### 3. Excellent featured and scalable relational database **Rating:** 5.0/5.0 stars **Reviewed by:** Anand V. | Enterprise Information Technology - Communication - Architect | Consultant | Auditor | Trainer, Mid-Market (51-1000 emp.) **Reviewed Date:** March 06, 2021 **What do you like best about SQLite?** Good tools for client/local storage for applications software.Also best used for embedded systems **What do you dislike about SQLite?** There is nothing I dislike about the product **What problems is SQLite solving and how is that benefiting you?** We are using SQLite for all our relational database needs for our internal systems. We have used for internal mapping finance database ### 4. Good but lightweight and is local **Rating:** 4.5/5.0 stars **Reviewed by:** Ilyas A. | Teaching Assistant, Small-Business (50 or fewer emp.) **Reviewed Date:** November 28, 2020 **What do you like best about SQLite?** It is very fast and requires very less space to actually store data. That is the reason why it is used in android. **What do you dislike about SQLite?** It cannot be used to sync with other apps or databases as it only works locally in the device **Recommendations to others considering SQLite:** Use Google Firebase instead. It will save a lot of the sync and connectivity issues. **What problems is SQLite solving and how is that benefiting you?** Benefit is that it is very fast because it's memory overhead is quite low and can be accessed by low memory/processor devices like mobile phones ### 5. 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. ### 6. 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 ### 7. Great database for modeling and rapid development **Rating:** 5.0/5.0 stars **Reviewed by:** Randall M. | Site Reliability Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** August 11, 2020 **What do you like best about SQLite?** Already installed ready to use rapid stand up rip and tear down stores everything is local files **What do you dislike about SQLite?** Scaling can be difficult , security features are linited **What problems is SQLite solving and how is that benefiting you?** Developing applications to require database backend but don’t want to deal with the complexities of also have to understand a post grass or any of the more traditional databases ### 8. SQLite a complete architecture to store locally on mobile or small end devices **Rating:** 4.5/5.0 stars **Reviewed by:** Mohit T. | Software Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** September 02, 2019 **What do you like best about SQLite?** One of the important thing in my point of view is that, its lightweight database as compare to other option available for small end system or mobile devices. It gives better performance as well, means reading and writing from the database table is very swiftly possible with the SQLite Database, which is a good thing. You don't have to worry about installation and other stuff regarding the configuration of database. It will configure we less headache. One another important thing is that its portable from one device to other without any extra configuration or migration process. **What do you dislike about SQLite?** By the all the features and facility provided with SQLite is until is sufficient because its open source free version which already gives lot of things for developers. The one thing which I want to show here is that they must increase its capacity from 2 GB to more. and also improve the HTTP request and response with the SQLite database. **Recommendations to others considering SQLite:** Yes, I really recommended SQLite for using in mobile application as well as in Embedded system where storage facility is less but we have to store some permanent things, like settings or flags or etc. It may help to sync important data when user comes under network coverage to give them better services. **What problems is SQLite solving and how is that benefiting you?** First thing I solve with the SQLite , get rid or storing large data related to application storage. Another thing is that storing offline some content which is useful when travelling or user has low latency network coverage so he can offline some content. Synchronization is another important factor comes when we are using such database. ### 9. SQLite A way to sync mobile and Web **Rating:** 4.5/5.0 stars **Reviewed by:** Sachin S. | UI/ UX Designer, Small-Business (50 or fewer emp.) **Reviewed Date:** August 27, 2019 **What do you like best about SQLite?** SQLite allows to store data on mobile storage devices, which means we can store the data in more like SQL format in SQLite. Local storage means that we can get more control on data in the same device as compare to getting data from some external source like from the server side. **What do you dislike about SQLite?** What I don't like in SQLite is that we can't store large amount of data in the database. The reason to this we can't hold large amount of data because if we hold data then it may be loss because of the device storage capacity. **Recommendations to others considering SQLite:** Yes I would be recommended when you want your application sync with your server database its good to have control over the device as well as the server. Its nice to get the syncing process very easy with local mobile data and the with server based database And the good thing about this is its totally free to use we don't have get the licence of it to use it. Implementation of SQLite is too easy and get the work done very conveniently. **What problems is SQLite solving and how is that benefiting you?** First it allows to sync the database remotely, it also useful to get the locally data over the server when we in contact with Internet. It is also useful to store temporary settings till not uninstalling the application. It gives facility to get rid of low network latency problem while we cant to do the communication with the network. ### 10. The most reliable SQL database platform **Rating:** 4.5/5.0 stars **Reviewed by:** Nadeeshani B. | Student, Mid-Market (51-1000 emp.) **Reviewed Date:** August 03, 2019 **What do you like best about SQLite?** The most used database in the world. It is very easy to get to learn even though you are new to learning SQL databases.Gives you fast access if the storage is enough. It can run on any machine and very smaller amount of space is taken to install.Much more comfortable in learning SQL based operations with SQLite. The most efficient one is that its cross- platform. If you are a student and want to learn SQL relational database management SQLite gives the best experience. **What do you dislike about SQLite?** There is not much to dislike about it. Sometimes the space will not be enough for larger companies. **Recommendations to others considering SQLite:** I highly recommend to use SQLite if you are using a relational database for your projects. **What problems is SQLite solving and how is that benefiting you?** As a student studying in the database management field I almost used every database and among them SQLite gave me the best experience. Very easy to get into relational database and very fast when working. very easy and efficient to integrate with other IDEs. I Used SQLite for both my netbeans shopping mall management system project as well as my android mobile application. ### 11. 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. ### 12. 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 ### 13. Using SQLite in desktop applications **Rating:** 2.5/5.0 stars **Reviewed by:** Marcio d. | Mr, Enterprise (> 1000 emp.) **Reviewed Date:** July 16, 2019 **What do you like best about SQLite?** Sqlite is very small database, with limited resources but, can be used to store internal configurations, replacing a XML file or txt configurations files, with great advantages. You can use ANSI sql commands to search for data, making more easy this tasks. The small size and his easy installation on any machin, make the SQLLite a good choice. **What do you dislike about SQLite?** One thing that i dislike was the frequent corruption files, when have a lot of inserts and deletions in database. We need keep a backup ready to use in this situations. **Recommendations to others considering SQLite:** Avoid use sqlite with big amount data. have a high risk of crash in files **What problems is SQLite solving and how is that benefiting you?** I replace all XML config files in my system, putting inside the sqlite. Is more easy keep all configurations in a database, and make only one backup for all. ### 14. 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 ### 15. Lite Database with awesome feature **Rating:** 5.0/5.0 stars **Reviewed by:** Mahesh K. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** January 15, 2019 **What do you like best about SQLite?** The best feature of sqlite which I like most is its very light weight with all the feature of RDMS (relational database management system) . This database is very easy to integrate with any application. It can be used with from small to heavy applications because of its nice features. SQLite is structured query based tool which support all the queries of relational database. It has schema based database.It is very easy to maintain database system. **What do you dislike about SQLite?** The things which i dislike in the sqlite is it have less support for any issue. It is not supported some function which we used in other RDMS systems like truncate that's why we have to use delete in the sqlite. In the addition it is not support database size more than 1 GB so we can't use for huge applications. **Recommendations to others considering SQLite:** As sqlite has great feature of RDMS I will recommend this tool to my all of friends & colleague so that they also can get benefits of sqlite which i got. **What problems is SQLite solving and how is that benefiting you?** In our organization we have multiple web & other desktop application and we have to maintain backend database so in this way sqlite help us the most. It resolved the many problems for backend database. It is more easy to maintain other than RDMS. Because of its great feature we switched to sqlite for our many applications. In addition it is very cost effective tool so that we can get this easily. It have many benefits which help the our organization to perform in more effective way & faster our backend query system. ### 16. 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 ### 17. Database server **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Animation | Small-Business (50 or fewer emp.) **Reviewed Date:** May 22, 2019 **What do you like best about SQLite?** Sqlite database server with this application user can make any kind of application like website or mobile application. If user going to make mobile application and user can use this server and make database programmatic. **What do you dislike about SQLite?** This application will not work for high amount of value of data. Because it is not easy to handle big data amount. **Recommendations to others considering SQLite:** It is good application to use for mobile and website application. you can develop any kind of application and make your automatic mobile application database. **What problems is SQLite solving and how is that benefiting you?** I solved many problem with mobile application or website server. this had helped my site to make it done with fast. It good with process and make your application great. ### 18. Simple And Stable **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** September 23, 2019 **What do you like best about SQLite?** Open source database used by applications due to its compact size, cross platform stability and server less functionality. Easy to integrate and easy to migrate is one of the best advantage of SQLite. **What do you dislike about SQLite?** As compare to object oriented DB its performance is quite back word. **Recommendations to others considering SQLite:** Object oriented data bases is options or alternate for SQLite. **What problems is SQLite solving and how is that benefiting you?** Its inbuilt in android framework so no need to add external DB library . Size of application is maintained by SQLite. ### 19. Awesome alternative for storing your data locally **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Internet | Small-Business (50 or fewer emp.) **Reviewed Date:** November 25, 2019 **What do you like best about SQLite?** You don't have to have a server and active network connection in order to use sqlite **What do you dislike about SQLite?** It is not optimised for advanced calculations and heavy i/o, but if you know that, you should implement something more advanced. **What problems is SQLite solving and how is that benefiting you?** Storing data locally in my iOS app ### 20. 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. ### 21. Very bad performance **Rating:** 0.5/5.0 stars **Reviewed by:** Evaristo C. | abogado, Small-Business (50 or fewer emp.) **Reviewed Date:** January 28, 2019 **What do you like best about SQLite?** is lite and do not consume much rosources of the device. **What do you dislike about SQLite?** 1.- Is only compatible with android devices 2.- It does not have consistency with other type of data elements 3.- It does not display tables as a database manager , is more like a excel 4.- It does not have a query executor 5.- Only works on windows 6.- Is almost not infomation at all for this **Recommendations to others considering SQLite:** if you must use the tool , beware that is going to be a big problem to read and write data outside the android aplication. For the people of SQLite , try to focus on the user , no matter is a It people tool , but does not have to be this problematic , you should reconsiderer the UI , the query language and finally the integration with diferents Operating Systems **What problems is SQLite solving and how is that benefiting you?** i'm developing an android aplication and was runing on a emulator but i want to see de data that was store in the device emulator but it was pretty dificult to read and obtain the data . I used because of hos low consuming requeistes and for trying a new tool ### 22. SQLite review **Rating:** 5.0/5.0 stars **Reviewed by:** Vilok L. | Assistant System Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** August 30, 2019 **What do you like best about SQLite?** The best thing is it is lightweight ,no network access and it is standalone database **What do you dislike about SQLite?** The security features are not well equiped **Recommendations to others considering SQLite:** Highly recommend **What problems is SQLite solving and how is that benefiting you?** No network access is needed and unlike oracle,Postgress it is easy to retrieve and establish connections ### 23. I try to use it but is almost imposible **Rating:** 1.5/5.0 stars **Reviewed by:** Alan I. | Gerente de Consultoria ABAP, Small-Business (50 or fewer emp.) **Reviewed Date:** January 18, 2019 **What do you like best about SQLite?** More than a like is the need to use it , was a database from another software i was trying and has a type of file than only aceppt this IDE , to install is pretty simple and super lite , has a free version and that would be the best of this. Does not consume much disk space so can be install in almost any server o machine. **What do you dislike about SQLite?** This is the first time a dislike a lot a software , sorry for the users of this but my opinion is base on my expirence because as i said , the database file a try to open was only manage by this, but i was terrible to work , to see just a table has to go over 3 screens and does not show al the data , make a query was really weird to do , was almos like working with excel . Is not compatible with more complex data types **Recommendations to others considering SQLite:** If you have to use it like me , use it just as last resort , was a pretty bad expirence , i think the developer team should get more practical with this software **What problems is SQLite solving and how is that benefiting you?** Just to open a mobile aplication database , no more no less, the benefits are that is really lite , and fast instalation , and was the provider choise to use this tool instead of other more efficient but is not the best for the job. ### 24. SQLite is a great relational database management system for electronic devices like cell phones, etc **Rating:** 5.0/5.0 stars **Reviewed by:** Rahul A. | Full Stack Web Developer, Information Services, Small-Business (50 or fewer emp.) **Reviewed Date:** January 18, 2019 **What do you like best about SQLite?** SQLite creates complex databases in the form of a single file with a size of hardly 500-700kb even though the database is too large. As compare to SQL server or any other RD system SQLite is lightweight and easy to implement and connect, as per my consideration. SQLite file manages all data in the form of object data-type. All the tables, relationships, events, data, and everything is stored and managed in one single file. As per my recommendation, SQLite is best option for portable devices for storing and accessing offline database. Devices like cell phones, video recorders, wifi routers, etc those need some database. **What do you dislike about SQLite?** I have no dislikes as of now for this product **Recommendations to others considering SQLite:** SQLite gets integrated to any development environment with ease if having proper knowledge. From a large community support online it is very easy to learn. Use this light weight database system for offline devices and applications. **What problems is SQLite solving and how is that benefiting you?** It helps in database solutions for many applications especially for mobile applications. We have developed many Android apps which uses SQLite as a database system. The great ability of relationships between entities is also helping in managing the database dynamically, a very important part of any Relational database out there, so SQLite has everything in a small bundle. Secondly, we won't require any online server or dedicated server to keep and manage databases, yes in case of backups are use cloud storage but that is totally optional. ### 25. Lightweight, Low Cost, and Easy to Use **Rating:** 5.0/5.0 stars **Reviewed by:** Brad R. | Database Administrator, Mid-Market (51-1000 emp.) **Reviewed Date:** January 17, 2019 **What do you like best about SQLite?** One of my favorite things about SQLite is the community behind it. The fantastic SQLite team provides incredibly solid docs and examples. The SQL syntax support is excellent and more importantly, well documented. **What do you dislike about SQLite?** Honestly, there's not much to dislike about SQLite. Older versions had some quirks that required strange workarounds (like not being able to alter a table, so you had to clone it, drop it, and create a new one - it was weird). But in recent years, things are in great shape. **Recommendations to others considering SQLite:** SQLite is an excellent choice for a fast and stable database, especially in a local, single-user environment. There are projects out there to enable network use as well, but it really shines as a local database. **What problems is SQLite solving and how is that benefiting you?** We have an ancient AS/400 that we still use for just a few functions (it's being phased out, but that takes time). Some people in our business office and human resources department need to run reports on that data, but those reports require dozens and dozens of queries, which can get very bogged down with a web front end to the AS/400. So we pull that data into a local SQLite database on each user's computer and run the reports locally - it's blazingly fast. Plus, I can build a custom desktop UI that's very easy for each person to use. ### 26. Best Portable Database **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.) **Reviewed Date:** March 27, 2019 **What do you like best about SQLite?** SQLite is known for being lightweight, robust and reliable at the same time. Since it is serverless, you don't need to install it or keep separate space for it. It's a standalone relational database which is ideal for mobile platforms whether IOS or Andriod. The syntax or query language of SQLite is quite easy to understand and you can go through their docs or online portals to find many examples and tutorials for the same. **What do you dislike about SQLite?** I think most of the people face this problem that it is not a multi-user database application which restricts it to a single user writing at a time. It also lacks some of the basic functionality that other competitor software provides like different Joins and Stored Procedures call. It is primarily used in our development cycle but it's not well suited to handle Enterprise level databases. **What problems is SQLite solving and how is that benefiting you?** We use it for all our development projects where the data is not that huge and a strict Timeout period is not applied to the database call. It gives us the data in a structured form in tables and that too in a size under 1 Mb. It doesn't require any space or server for installation. So, saves a lot of physical space and CPU resources. ### 27. Good lightweight database management system **Rating:** 4.5/5.0 stars **Reviewed by:** Aanu B. | Assistant Consultant, Small-Business (50 or fewer emp.) **Reviewed Date:** June 27, 2019 **What do you like best about SQLite?** - Good for lightweight databases that do not require a full-fledged server (like android) **What do you dislike about SQLite?** - Since it runs on a single computer, it does not have full functionality that most databases have (like indexing or handling large data sets) **What problems is SQLite solving and how is that benefiting you?** It was used to build a database used on android applications and it was really convenient given the capabilities of the android OS. ### 28. One of the best database app. **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** September 11, 2019 **What do you like best about SQLite?** SQL lite one of the best server for use globally and user can use this server free globally. SQL lite provides a secure database platform for everyone. **What do you dislike about SQLite?** Sql lite not supported the maximum programming language, like php wordpress. **Recommendations to others considering SQLite:** Yes, if little bits knowledge about SQL server **What problems is SQLite solving and how is that benefiting you?** Its very user friendly and any one understands these server standards. ### 29. Great relational database **Rating:** 5.0/5.0 stars **Reviewed by:** Michael C. | Test Engineer Intern, Hospital & Health Care, Small-Business (50 or fewer emp.) **Reviewed Date:** May 17, 2019 **What do you like best about SQLite?** This is a great relational database that suits most needs for a database. Response times are fast and integrating is a breeze. **What do you dislike about SQLite?** There's nothing to dislike about SQLite aside from its pronunciation, which is SQL Lite (or sequel lite). **Recommendations to others considering SQLite:** Consider other SQL apps as well such as PostGreSQL and MySQL. **What problems is SQLite solving and how is that benefiting you?** I no longer have to create a new data structure for each data storage problem. A relational database solves most data storage issues for most computer systems. ### 30. My review for sqlite **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Banking | Mid-Market (51-1000 emp.) **Reviewed Date:** September 23, 2019 **What do you like best about SQLite?** It execute the query very fast. All the major. Functionality are available.. **What do you dislike about SQLite?** As such I don't dislike anything about sql lite **What problems is SQLite solving and how is that benefiting you?** I use it for ETL Process. Extract transform and load data. I am into fraud detection team so I use it for customer data's to get the insights ### 31. 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. ### 32. SQLite is a Lightweight Databse **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Online Media | Small-Business (50 or fewer emp.) **Reviewed Date:** January 25, 2019 **What do you like best about SQLite?** SQLite is easy to use if you are already familiar with SQL. It's deployment is fairly easy. Like the name suggests, it is very light weight, and works best for storing small particularly local data that mimics your large SQL databases. It is free. **What do you dislike about SQLite?** It crashes if you go beyond its storage capacity. You can only use SQLite for small to mid-sized applications. **Recommendations to others considering SQLite:** The software is free, and that is the biggest benefit. However, ensure you a aware of the storage capacity. SQLite works only with limited amounts of data. It is a light weight software but provides you with the capability of popular SQL databases such as MySQL, and SQL Server. **What problems is SQLite solving and how is that benefiting you?** SQLite works great as the backend for simple mobile application or websites. ### 33. SQlite is embeddable relational database management system. **Rating:** 4.5/5.0 stars **Reviewed by:** Dianne W. | ICT Professional , Small-Business (50 or fewer emp.) **Reviewed Date:** April 29, 2019 **What do you like best about SQLite?** SQLite is a very light weighted database and its Read and write operations are very fast for SQLite database. Its portable and accessible through a wide variety of third-party tools. **What do you dislike about SQLite?** SQLite is used to handle low to medium traffic HTTP requests. and the Database size is restricted to 2GB in most cases. **Recommendations to others considering SQLite:** I would give SQlite 7 of 10 **What problems is SQLite solving and how is that benefiting you?** Due to its optmization capability, SQlite has improved productivity by saving precious time in accessing data. ### 34. Lite but complete **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** April 23, 2019 **What do you like best about SQLite?** As the name says, it is liter version of a complete RDBMS with almost all the features. This can be integrated with a variety of ETL tools with ease. Organizing data is very easy across the organization globally. Customer support is excellent and available to answer if there are any issues. **What do you dislike about SQLite?** Previous version had few bugs which are now rectified in the latest version. Stored procedures part is kind of tricky with SQLite. **Recommendations to others considering SQLite:** very lite and user friendly **What problems is SQLite solving and how is that benefiting you?** Connecting and access to the database is easy from our various offices around the globe. Installing and the memory usage of SQLite is perfect. ### 35. "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. ### 36. 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 ### 37. SQLite for Android **Rating:** 5.0/5.0 stars **Reviewed by:** Marc C. | Senior Deployment Engineer | Full Stack Engineer, Telecommunications, Mid-Market (51-1000 emp.) **Reviewed Date:** November 16, 2018 **What do you like best about SQLite?** I love SQLite! It's so easy to use and there are tons of information online you can search if you get stuck since it's a pretty common database for mobile phone app development. **What do you dislike about SQLite?** I actually cannot think of anything, but i guess i wish there's a GUI to view the data and dont have to code everything just to query something. **Recommendations to others considering SQLite:** If you want to have a very lightweight, free database when doing mobile phone applications, this is my go to database. You wont go wrong on this one, you have so much information from the internet which can get you going whenever you get stuck. **What problems is SQLite solving and how is that benefiting you?** It's a free way to store information in a mobile application. Specially if your'e just starting off and dont have much funds to go big, SQLite is a perfect database and it's so lightweight. ### 38. developer **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Design | Mid-Market (51-1000 emp.) **Reviewed Date:** April 02, 2019 **What do you like best about SQLite?** SQLite is fast, as well as its centralization is awesome. Actually, it is sometimes easily accessible through variety of third party tools which makes SQLite best for me. **What do you dislike about SQLite?** some particular functions are removed which I seriously do not like about SQLite. These functions include, right join, drop column. Also, SQLite is not supported by multi client concurrency. So, omitting all of these makes what I donot like about SQLite **What problems is SQLite solving and how is that benefiting you?** it is lite database with some interesting features. In fact, SQLite is good whenever you need to be fast since it does not need any effort for set up as well as its speed, availability, easy to use features are awesome. ### 39. Simple and light **Rating:** 4.5/5.0 stars **Reviewed by:** Krishna P. | Blogger, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** February 04, 2019 **What do you like best about SQLite?** It's awsmm and light, really like the way it can integrate. **What do you dislike about SQLite?** Documentation can be little better and can add inspiration from nosql database **Recommendations to others considering SQLite:** As mentioned above, you have a good market of microservices. You can approch popular framework and create your direct plugin with them, so that it can easily implemented with them and you will get more contributer and users to use **What problems is SQLite solving and how is that benefiting you?** Like simple integration with spring framework where I don't want MySQL to be installed. Main advantage it's like mobility. It can easily ship with applications. But I am afraid spring framework e2 storage could take over ### 40. 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 ### 41. Would like to learn more on SQLite as a part of my project work **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** January 03, 2019 **What do you like best about SQLite?** SQLite is a DB engine and the most excited piece of this tool is like this tool is built on C language. This tool has a very good feature to work in mobile applications like us in Pega Platform. The coolest part of this tool is like it is an Open source to public and is free to everyone to use for any purpose. **What do you dislike about SQLite?** I don't see any such dislikes for me in this tool. Probably I may have to work in deep on this tool to know more about the limitations of this tool. For now, I am a beginner on this tool and still I need more expertise on this to make a comment on it. **What problems is SQLite solving and how is that benefiting you?** In our mobile application, Pega is using this SQLite DB calls to make a connection and fetch the data from the DB tables in our Javascript code. To meet our biz requirement without any performance issues in mobile, we need to follow Pega directions and moreover Pega is using this tool internally in their product. With this DB call settings from Pega, we are fetching and populating the data on UI quickly and biz is happy with this approach. ### 42. 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. ### 43. sqlite, a light and easy to use software **Rating:** 5.0/5.0 stars **Reviewed by:** Prince K. | Mid-Market (51-1000 emp.) **Reviewed Date:** October 16, 2018 **What do you like best about SQLite?** Sqlite is a very light software for database management. Due to its light feature it can be easily used on mobile devices. It is very easy to install. Sqlite functions can be called very easily through small functions which reduces latency or any kind of delay. It is a server less software so require less or zero configuration. It is best suitable for embedded devices where no human intervention is required. It is the best software for relational database management for mobile users. **What do you dislike about SQLite?** As it is not multi user type so only one user can write at one time. It is not secure. **Recommendations to others considering SQLite:** I would recommend users to use Sqlite in case of small devices to handle the relational database. It is very compact and easy to use. **What problems is SQLite solving and how is that benefiting you?** I have this to handle the database in my embedded devices in my projects. It is best for this because it doesn't require any kind of administration. It is the light version of SQL so very effective in case of small devices. It is very fast in its work as there is negligible amount of latency. It is very compact and easy to use software. ### 44. Standard now in this day and age **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** August 08, 2019 **What do you like best about SQLite?** Stores data as objects and not as relational data **What do you dislike about SQLite?** Can use up a lot of space very quickly because you’re storing objects **Recommendations to others considering SQLite:** Good if you don’t need a table management database **What problems is SQLite solving and how is that benefiting you?** Complex and customized data storage ### 45. 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. ### 46. Used for Android **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** July 21, 2019 **What do you like best about SQLite?** It is very light weight and easy to use. **What do you dislike about SQLite?** There is nothing to put as a dislike. I like the features I used for development. **What problems is SQLite solving and how is that benefiting you?** I used it for android development and it is very powerful. ### 47. 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. ### 48. 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. ### 49. Database architecture **Rating:** 5.0/5.0 stars **Reviewed by:** Himanshu K. | Manager, Enterprise (> 1000 emp.) **Reviewed Date:** October 24, 2018 **What do you like best about SQLite?** This software is used for database management. It is the light version of SQL. It is self- contained, serverless and require no setup. It is suitable for small embedded devices like cell phone, mp3 player, etc. It is based on command line interface. **What do you dislike about SQLite?** Sometimes it poses a risk on security. It is gets slow when data being handled increases. **Recommendations to others considering SQLite:** I would recommend this software to those who needs to handle small database for small embedded device or small websites. It is very simple, compact and easy to learn. **What problems is SQLite solving and how is that benefiting you?** I use this software to manage database for my embedded projects. It is very simple and easy to use. It requires no setup and is full featured like SQL. It has no extra dependency. It is best for small sized websites. ### 50. 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. ## 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=2&qs=pros-and-cons§ion=pricing&secure%5Bexpires_at%5D=2026-07-23+08%3A34%3A58+-0500&secure%5Bsession_id%5D=ee734d55-6586-4985-b9ea-5783c9910711&secure%5Btoken%5D=a32d0d28eda7df7e8c752716444ec022ac5c2773f804c66f1fe4abbdeee1cf30&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,580 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) - 4.3/5.0 (931 reviews)