--- 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. Relatively easy to use even for first-timers **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Higher Education | Enterprise (> 1000 emp.) **Reviewed Date:** June 12, 2018 **What do you like best about SQLite?** I like the options SQLite gives to allow for command line interface as well as the different platforms supported (ie., Windows, Mac and Linux). Also because of its “lite”ness I can analyze rather large datasets and files efficiently. **What do you dislike about SQLite?** Like all programming, there is a learning curve requirement for using SQL, however it is not a huge drawback. I do wish there was more documentation to help with commands **What problems is SQLite solving and how is that benefiting you?** As a bioinformatics Researcher, I’ve used SQLite for parsing of large files (CSV) corresponding to genomic datasets, which I then performed statistical analyses on R. In this sense, SQLite has made my life much easier. ### 2. Great product for right project **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** October 25, 2018 **What do you like best about SQLite?** This works extremely well for small projects, easy to use, and easy to manage. **What do you dislike about SQLite?** The documentation I have found seems to make things harder than it actually is. **What problems is SQLite solving and how is that benefiting you?** Database for small projects/services. ### 3. Easy to use for Mobile or Hybrid app development **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** July 30, 2018 **What do you like best about SQLite?** It is very light weight database and easy to integrate with the angular based mobile apps. **What do you dislike about SQLite?** There are some limitation compared with the traditional or full veraion databases. **What problems is SQLite solving and how is that benefiting you?** Locally Stored all the mobile app and user information ### 4. Perfect for smaller sites without need for comcurrency **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** July 31, 2018 **What do you like best about SQLite?** Exactly what my title says. Very nice and simple DB. Great command line features as well to make it very easy to use. **What do you dislike about SQLite?** It’s not concurrent, but it’s honestly not that big of an issue for most small to medium sized corps **Recommendations to others considering SQLite:** Again, it is for smaller simple projects. Ditch Access and use this instead. **What problems is SQLite solving and how is that benefiting you?** Simple, light, free, open source, and best of all: very easy to work with and maintain ### 5. Very well-developed and researched. **Rating:** 4.5/5.0 stars **Reviewed by:** Fedor P. | Co-Founder/CEO, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** November 08, 2017 **What do you like best about SQLite?** There is a lot of obvious research that was put into making the language, which makes it a very good choice to use in small scale projects that don't require the corporate/advanced features that regular SQL has to offer. This software is also available for many different platforms, which is great for small-time developers that want to use professional database software like this for free. It is also extremely fast, as I've never personally had issues with the speed of retrieving data regardless of the platform I am using. **What do you dislike about SQLite?** A lot of people dislike the SQL language in general, and often specifically the difficulty to create one-to-many relationships in SQLite, or just the difficulty of the SQL language in general. There also isn't any default encryption, which is a huge flaw for any product that is going to be used publicly and commercially. SQLite is also a single-user system. So, if it is a requirement that your company using a collection of accounts to manage the database, this could become an issue very quickly. **Recommendations to others considering SQLite:** SQLite is a great option for those that are looking for an entry-level database management system that doesn't require any commercial licensing. However, be aware that some issues might arise in the later stages of product development, especially if you are looking to release a product like this publicly. **What problems is SQLite solving and how is that benefiting you?** IT is really nice to be able to use a platform like this free-of-charge. I suppose this solves the problem of having to finance database software or possibly receive licensing for commercial use of some type of database software. ### 6. 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 ### 7. Easy to learn with sql background **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Military | Small-Business (50 or fewer emp.) **Reviewed Date:** July 31, 2018 **What do you like best about SQLite?** I like the NaviCat GUI. It is easy to learn and follow. **What do you dislike about SQLite?** I do low level troubleshooting but I struggle with C. I would prefer they use a more widely used language like C++ in sql server. **What problems is SQLite solving and how is that benefiting you?** The rdbms is easy to work in especially with NaviCat. The training for new employees is easy and it has been very reliable for us. ### 8. Great database tool for applications **Rating:** 4.5/5.0 stars **Reviewed by:** Stefania S. | IT Specialist, Automotive, Enterprise (> 1000 emp.) **Reviewed Date:** December 20, 2017 **What do you like best about SQLite?** I made numerous portable applications, and I frequently workd with SQLite, and it is nice to work with SQLite to spare my in-application information. It is easy to use, quick and smooth. With this tool I can simple find information, seek and sort. **What do you dislike about SQLite?** For the moment I like all, no dislikes, and exceptionally content with SQLite for applications. I don't utilize SQLite for site for work area application since I think it is too little for those sorts of application. **Recommendations to others considering SQLite:** SQLite is a must-have in your versatile application to spare data, stacking information and finding - arranging information, incorporating data spared with information in it. **What problems is SQLite solving and how is that benefiting you?** Versatile applications.Simple to spare information, connecting information, and discovering, arranging information. All that I have to work with information can be simple do with SQLite ### 9. The best solution for mobile apps **Rating:** 5.0/5.0 stars **Reviewed by:** Jorge G. | It Manager, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** January 10, 2018 **What do you like best about SQLite?** SQLite is the easy way to develop mobile apps, you can use in Android, iOS and even Windows UWP, is lightweight, and bring almost all the need for local storage. **What do you dislike about SQLite?** Some function could be better specially the rules for update data, but is enough for resolve almost any kind of apps **What problems is SQLite solving and how is that benefiting you?** We develop mobile apps like smart community, an app for control the visit in building, neighborhood, work in android, iOS and Windows UWP. ### 10. Simple, Portable, Open Source, Deploy Anywhere **Rating:** 4.5/5.0 stars **Reviewed by:** Kat F. | Executive Administrator, Mid-Market (51-1000 emp.) **Reviewed Date:** February 16, 2018 **What do you like best about SQLite?** See title! One disk image, run on any system or smartphone, bindings for any language I've ever looked for (base is ANSI-C), stability **What do you dislike about SQLite?** There really isn't anything about SQLite to dislike. **Recommendations to others considering SQLite:** I'd recommend it even if you're put off by the "Lite" terminology...fully configured, it's a powerhouse, plain and simple. **What problems is SQLite solving and how is that benefiting you?** Single file can be combined quite quickly and easily into current project. There's help available for any questions you run into - someone's already solved your problem, so there's no down time, isolated transactions saved our bacon after destructive Hurricane. ### 11. Excellent dev database environment **Rating:** 5.0/5.0 stars **Reviewed by:** Scott S. | Chief Technology Officer, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** December 27, 2017 **What do you like best about SQLite?** This database has everything you need to get a web application up and running without the hassle of setting up a full database environment, it’s all in one easy file **What do you dislike about SQLite?** If your coming from a MySQL background you will quickly realize the simplified data types and if your deepening on your database to enforce those requirements you will be out of luck. SQLite doesn’t support dates, times, or timestamps **Recommendations to others considering SQLite:** If you need the power of MySQL on a mobile device use SQLite, it is the best solution around! **What problems is SQLite solving and how is that benefiting you?** SQLite is my go to solution for both local development and for mobile offline development. As long as you understand it’s limitations it is an excellent database ### 12. Database for small storage purposes **Rating:** 4.5/5.0 stars **Reviewed by:** Suraj D. | Embedded Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** December 07, 2017 **What do you like best about SQLite?** The best thing is light weight, Not too much big footprint. This can easily utilized in small memory projects. Like embedded system applications are good fit for it. I like the best all SQL queries are valid in it. You will feel like working in SQL. **What do you dislike about SQLite?** I had interface with C++ so i don't like the long connection strings. If hard to debug , keep track of the open and to close the all open connections,, otherwise can be different behavior. **What problems is SQLite solving and how is that benefiting you?** I used inside the Vehicle Infotainment system. In the Infotainment system there is a concept of different user logged in. So keep track of every user in the system, so you can see all the valid apps and other Vehicle Infotainment related settings. ### 13. Optimal DBMS **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Higher Education | Enterprise (> 1000 emp.) **Reviewed Date:** July 31, 2018 **What do you like best about SQLite?** Easy to use, secure and fast. SQLite is the most popular database engine. ACID properties are critical for transactions. **What do you dislike about SQLite?** Rigid structure, unlike MongoDB which is flexible and unstructured. **Recommendations to others considering SQLite:** Document-based structure would be better than table-based format. **What problems is SQLite solving and how is that benefiting you?** Organized data schema and RDBMS for data and operations. ### 14. The perfect solution for reliable unit tests **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** December 27, 2017 **What do you like best about SQLite?** SQLite is hands down, the simplest databse engine in the market. It is definitely not scalable but an essential tool in the software development process. **What do you dislike about SQLite?** The lack of visual development tools may make it hard for newcomers but it is still simple enough compared to the alternatives. **Recommendations to others considering SQLite:** There are for sure many use cases for SQLite, but make no mistake, as a tool for unit testing is where it shines. Give it a chance and replace all you database and sql query mocks for real database interaction in your unit tests and you will be able to measure the increase in your software quality. **What problems is SQLite solving and how is that benefiting you?** We use SQLite exhaustively for unit testing the data layer of a very large codebase and it has proven to be the best choice. The overhead is minimum and the benefits are enormous compared to other techniques, such as mocking or using stubs. Not having to rely on an external DB component, gives us faster deploy times and streamline our continuous integration efforts. ### 15. Can't Beat Free But Tread Lightly **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Chemicals | Enterprise (> 1000 emp.) **Reviewed Date:** December 28, 2017 **What do you like best about SQLite?** That it's free and small to implement. Great for mobile development and has a large user case and community. **What do you dislike about SQLite?** That it can't support Stored Procedures and can be very difficult if you are going to have multiple processes accessing your data at once you are going to have a bad time. **Recommendations to others considering SQLite:** If you are considering SQLite for mobile development then I would stop considering and pull the trigger. It's similar to SQL and the feature is pretty great for a free alternative. **What problems is SQLite solving and how is that benefiting you?** The business problems I solved with SQLite are that I have a database I can use, for free when developing brand new mobile apps. It's very similar to SQL, which I use commercially, and supports enough features that it is a no brainer to use. There really any benefits other then I have a go to when starting a new mobile app that requires a database backend. ### 16. The light database **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Commercial Real Estate | Mid-Market (51-1000 emp.) **Reviewed Date:** August 11, 2018 **What do you like best about SQLite?** It is the best option for mobile applications. Very easy to use, portable, and very lightweight. **What do you dislike about SQLite?** If you want to do something very complex, you might need another option. **What problems is SQLite solving and how is that benefiting you?** Simple applications for Android mobiles ### 17. Easy to use and powerful **Rating:** 5.0/5.0 stars **Reviewed by:** Misagh N. | Biochemistry PhD student and Research Assistant in Computational and Systems Biology, Higher Education, Enterprise (> 1000 emp.) **Reviewed Date:** September 19, 2017 **What do you like best about SQLite?** What I like about SQLite is the simplicity of installation process and usage. It integrates easily with my python. With the minimum knowledge that I had about SQL systems, I could easily complete two nice projects with SQLite. **What do you dislike about SQLite?** I don't have a deep knowledge of the database software packages and therefore am not qualified to tell what could be better. But from what I experienced, I didn't have any specific difficulty with anything in SQLite software. **What problems is SQLite solving and how is that benefiting you?** I used SQLite for two smaller projects in my PhD. I organized many separate data tables of that had relations to one another using python and SQLite. The outcome was super nice, because I could quickly filter through large sets of data and specify a certain relationship and make a subset fulfilling that requirement. Some of these tasks could take a day on my desktop, while using SQLite It could be as fast as minutes. ### 18. SQL that works on most of operation systems **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** July 30, 2018 **What do you like best about SQLite?** Easy to install at almost all of devices with different operation systems **What do you dislike about SQLite?** Sometimes is a problem to find current version and SQLite updates with bug fixes **What problems is SQLite solving and how is that benefiting you?** Tracking on Android and iPhone devices ### 19. Integrates Well **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.) **Reviewed Date:** July 31, 2018 **What do you like best about SQLite?** I love how easy the product is to use with python **What do you dislike about SQLite?** Storage isnt awesome. Otherwise great product. **Recommendations to others considering SQLite:** Best for analytics. Otherwise use a more powerful database **What problems is SQLite solving and how is that benefiting you?** Manipulating data in python ### 20. SQLite can do easy database stuff easily **Rating:** 5.0/5.0 stars **Reviewed by:** Tanim I. | Design Physicist, Research, Enterprise (> 1000 emp.) **Reviewed Date:** January 09, 2018 **What do you like best about SQLite?** It just works, it's a simple file-based database. The python plugins to SQLite are very high quality. **What do you dislike about SQLite?** I can think of nothing I dislike. Sometimes even sqlite is overkill. A JSON file would be sufficient for many of my use cases. **Recommendations to others considering SQLite:** Great for simple use cases and applications. **What problems is SQLite solving and how is that benefiting you?** Configuration data. ### 21. Easy to use **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** July 10, 2018 **What do you like best about SQLite?** Already set up by default with Django. Easy to understand. **What do you dislike about SQLite?** Not as many features as normal SQL OR MYSQL **What problems is SQLite solving and how is that benefiting you?** We are solving problems such as analyzing error logs and predicting when an outage will occur. ### 22. Essential for software that you will use everyday **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** January 02, 2018 **What do you like best about SQLite?** I like SQLite's availability and that it is serverless. This makes it extremely portable and lightweight (considering alternatives). This bridges a gap between the always connected tech landscape and the increases needs for efficient and portable devices. **What do you dislike about SQLite?** Security is lacking by design which significantly increases the risk of implementing sqlite **What problems is SQLite solving and how is that benefiting you?** By synchronizing files automatically based on network availability, I can be sure that I can work on the same information on multiples devices without having to transport the information myself (like emailing a document as an attachment) ### 23. Greate simple db for portable apps **Rating:** 4.0/5.0 stars **Reviewed by:** Felipe M. | Tech Leader | Cloud Engineer and Architect, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** April 03, 2018 **What do you like best about SQLite?** SQLITE is very portable! you can easily ship it along with your code without having to worry about configuring and maintaining servers. **What do you dislike about SQLite?** Sometimes it might be unperformant but it is totally understandable **What problems is SQLite solving and how is that benefiting you?** Android apps. GIS software using ogr2ogr and spatialite ### 24. Best database for mobile apps **Rating:** 5.0/5.0 stars **Reviewed by:** Nilesh D. | Full Stack Engineer, Internet, Small-Business (50 or fewer emp.) **Reviewed Date:** January 27, 2018 **What do you like best about SQLite?** One of the easy and cool database to setup for mobile data store, we were exploring couple of options and found SQLite is the best one which you can use for mobile database. **What do you dislike about SQLite?** Scaling of database is not that great. Security also needs to improve **Recommendations to others considering SQLite:** If you want good database for mobile, this is best you can get. **What problems is SQLite solving and how is that benefiting you?** Small database footprint where needed, and it fits right there. ### 25. SQLite lives up to its name **Rating:** 5.0/5.0 stars **Reviewed by:** Andreas O. | Senior Software Developer, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** December 15, 2017 **What do you like best about SQLite?** I love how simple and easy to use SQLite is. It doesn’t require administration and is very reliable. You don’t have to think or worry about it. Did I mention it’s free? **What do you dislike about SQLite?** Nothing! The product serves its purpose very well. **What problems is SQLite solving and how is that benefiting you?** Robust, reliable, and lightweight database for restaurant applications on embedded devices. ### 26. Lite SQL **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Services | Small-Business (50 or fewer emp.) **Reviewed Date:** December 13, 2017 **What do you like best about SQLite?** It is so easy to work with the SQLite. It is great for testing, personal or single user purpose as it is lightweight and can be used stand alone, with some IDE like DB Browser, Beaver DB, or through the Python as well... Light and powerful. **What do you dislike about SQLite?** Well, there are not too many things to dislike in SQLite. Only if I compare it to the other (but bigger ) db systems like Oracle, SQL Server... But that is not properly comparable. **Recommendations to others considering SQLite:** If you want something lighter than LibreOffice Base and MS Access, yet powerful and more like "big databases" or just for education or prototyping purpose, you don't need to look further. SQLite is the tool. **What problems is SQLite solving and how is that benefiting you?** Private data storage and testing purpose - for prototyping... ### 27. SQL db is good software **Rating:** 4.5/5.0 stars **Reviewed by:** Pritesh P. | Director of Product, Integrations, Mid-Market (51-1000 emp.) **Reviewed Date:** December 13, 2017 **What do you like best about SQLite?** The SQLite is a good database for a small application. It is very easy to use and very light and fast. **What do you dislike about SQLite?** SQLite cannot be used for a very big database to store a lot of information. It is better for internal applications. **Recommendations to others considering SQLite:** SQLite is a great SQL db for small uses **What problems is SQLite solving and how is that benefiting you?** I use SQLite for small internal application that we have to write, it is very easy to use and light to install into the application when deploying to clients. ### 28. Quick and easy database **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Research | Mid-Market (51-1000 emp.) **Reviewed Date:** June 27, 2018 **What do you like best about SQLite?** Ease of standup, lightweight and good for small-scale apps **What do you dislike about SQLite?** Some software limitations that make it less extensible **What problems is SQLite solving and how is that benefiting you?** Data storage for small scale projects ### 29. High Performance File Based DB **Rating:** 4.5/5.0 stars **Reviewed by:** Aung Thu Rha H. | Senior Security Engineer, Computer & Network Security, Enterprise (> 1000 emp.) **Reviewed Date:** October 31, 2017 **What do you like best about SQLite?** It's versatile and can use in various platforms and mobile/desktop applications. In-memory database option is one of my favourite feature that can create database on-the-fly. **What do you dislike about SQLite?** I can't really think of major drawbacks of SQLite DB but one thing that lacks is the incapability to run as the main thread process. **What problems is SQLite solving and how is that benefiting you?** It's open source database and this is one of the main benefit of using it. The website has full documentation for the developer to integrate with apps. ### 30. SQLite great database! **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Games | Small-Business (50 or fewer emp.) **Reviewed Date:** June 13, 2018 **What do you like best about SQLite?** It's a great database that does everything you need all in one file. **What do you dislike about SQLite?** It can't necessarily handle extremely large data sets. **What problems is SQLite solving and how is that benefiting you?** Data storage ### 31. SQL for tiny projects **Rating:** 3.5/5.0 stars **Reviewed by:** Diogo R. | CEO, Small-Business (50 or fewer emp.) **Reviewed Date:** July 14, 2017 **What do you like best about SQLite?** It's a serverless database system. You just need an API library to access the database, which is stored in a single file. Most common SQL operations are available. For small projects it works better than other file formats like JSON or INI. You can relate data and make SQL queries, with some little differences. Because it's in a single file, this means that it should work in memory, giving it speed. You can also create databases in memory, without storing them on the filesystem. It's quite useful when you have matrices and complex operations that you prefer to do using SQL. **What do you dislike about SQLite?** Although it's ideal for small projects, as soon as you grow you need to move to a proper RDBMS. Since SQLite uses a file, only one process should be accessing the database at any given time or you'll loose data. Also, having the database on a file means that your systems need access to the filesystem, which creates many security problems. Using another database system like MYSQL you can expose only the databases and tables you want by granting specific permissions. **Recommendations to others considering SQLite:** Don't use it if you know your data is going to grow or be used my multiple services. Use it for bootstrapping and testing projects. **What problems is SQLite solving and how is that benefiting you?** - Storing information in a structured form, with tables and relations between them; - Being able to bootstrap and test small projects on a laptop without having a database server; ### 32. Simple and useful for Mobile development **Rating:** 3.5/5.0 stars **Reviewed by:** Felipe N. | Analista Mobile Senior, Internet, Enterprise (> 1000 emp.) **Reviewed Date:** January 10, 2018 **What do you like best about SQLite?** All the basic sql options are present, so it's very useful for small mobile projects. **What do you dislike about SQLite?** Some commands are different, so I needed to check the documentation to change them. **Recommendations to others considering SQLite:** Remember to check the documentation for diferent commands and be sure sqlite is enough for your project. It is very reliable. **What problems is SQLite solving and how is that benefiting you?** I created a few apps with sqlite using titanium. ### 33. SQLite is pretty good **Rating:** 4.0/5.0 stars **Reviewed by:** Zil S. | Business Analyst/Product Owner, Food & Beverages, Mid-Market (51-1000 emp.) **Reviewed Date:** March 07, 2018 **What do you like best about SQLite?** Easily accessible and same as like SQL server **What do you dislike about SQLite?** The scheme pattern is bit hard to manage as compare to SQL **What problems is SQLite solving and how is that benefiting you?** It’s a basic tool for capturing data on mobile devices ### 34. Best native database solution for beginners **Rating:** 4.5/5.0 stars **Reviewed by:** Sarneet C. | Software Developer Intern, Management Consulting, Small-Business (50 or fewer emp.) **Reviewed Date:** August 09, 2016 **What do you like best about SQLite?** SQLite has the following features I like the most - Ease of Use - Open Source - Native and Portable - Good performance for small applications - easy to learn and apply - supported by almost all frameworks - great documentation **What do you dislike about SQLite?** There are some caveats to using SQLite - Stores data on raw files. Not safe from security point of view - For large applications, it fails due to high storage space and poor speed as compared to NoSQL - SQLite databases don't support encryption **Recommendations to others considering SQLite:** SQLite is best suited for small scale applications. It is supported by almost all frameworks and very easy to use. Great place to start for a beginner in database. **What problems is SQLite solving and how is that benefiting you?** SQLite is really easy to use and good for storing data natively. I have used it for storing data in small scale apps. ### 35. Best embedded database. I use it everyday! **Rating:** 5.0/5.0 stars **Reviewed by:** David A. | Software Engineer, International Affairs, Small-Business (50 or fewer emp.) **Reviewed Date:** April 18, 2017 **What do you like best about SQLite?** It is embedded. It is fast. It is customizable. It is fully featured. I use it everyday, not only supports standard SQL but also: ridiculously fast, interoperable between systems (same binary format), supports plugins, supports advanced operations (Full-text search, custom functions, JSON, etc.) and support for multi-type columns (each value, a type not tied to the schema). **What do you dislike about SQLite?** Nothing, really. If you use it correctly, you won't find any issue. Of course, if you want to use a client/server model you have to ship your own, but being embeddable is the big plus for me. **Recommendations to others considering SQLite:** Please, review features thoroughly against current versions. Most websites (stackoverflow included) state information that is no longer valid or false, because these opinions/information was deprecated. It is important to check current version and do proper testing. **What problems is SQLite solving and how is that benefiting you?** Lots! I use it for: - Storing configuration parameters. - Crunching data that does not fit in RAM. - Store big amounts of data, in a queryable format. - Mimic production environments for testing, without the use of a full database server. - (and the list goes on and on...) ### 36. SQL Lite - Great Open tool **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** December 27, 2017 **What do you like best about SQLite?** Open tool that I could used for development of my personal projects. Also could used it for analysing some of my the data. Database itself is embedded into end program **What do you dislike about SQLite?** It's NOT a client server DB tool; nor is it meant as highly scalable tool like the conventional MS SQL or Oracle DB **What problems is SQLite solving and how is that benefiting you?** Mainly internal small scale projects ### 37. Great cross platform database **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Biotechnology | Small-Business (50 or fewer emp.) **Reviewed Date:** December 15, 2017 **What do you like best about SQLite?** That the database the I use in my mobile app can be imported into my desktop app with no changes and it just works. **What do you dislike about SQLite?** Lack of some more advanced features like store procedures limits ease of use. Lack of free full featured UI for design and development. **Recommendations to others considering SQLite:** It’s great and free and available on almost every platform. **What problems is SQLite solving and how is that benefiting you?** Free cross platform database ### 38. A great companion for web app prototypes **Rating:** 5.0/5.0 stars **Reviewed by:** Jeremy B. | Enterprise (> 1000 emp.) **Reviewed Date:** January 10, 2018 **What do you like best about SQLite?** It's very very easy to setup and change with or without a gui tool. **What do you dislike about SQLite?** It doesn't have the advanced options of other sql implementations. **What problems is SQLite solving and how is that benefiting you?** Sqlite was used to accompany a web app prototype. It was very easy to setup, tear down and rebuild as the project evolved. ### 39. Great software **Rating:** 4.0/5.0 stars **Reviewed by:** Chris W. | Network Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** January 29, 2018 **What do you like best about SQLite?** Easy interface and good database for links **What do you dislike about SQLite?** I do not have any dislikes for sql lite. **What problems is SQLite solving and how is that benefiting you?** Stores required product information. Allowed building of parts database for copper parts that were carried in for service inventory. ### 40. SQL Lite - Good Database for Mobile Apps or Lightweight Database Work **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Higher Education | Mid-Market (51-1000 emp.) **Reviewed Date:** January 18, 2018 **What do you like best about SQLite?** It is very easy to install and to deploy. Easy user interface **What do you dislike about SQLite?** The database itself is stored as a file, which can be confusing **Recommendations to others considering SQLite:** I would recommend SQLite, particularly for mobile application development. It is a very easy to install and to administer. The file system implementation can be confusing but works well with Android platforms **What problems is SQLite solving and how is that benefiting you?** I have used this to store data on an Android phone for an app I have also used it for teaching courses ### 41. Sqlite is best for android **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Internet | Enterprise (> 1000 emp.) **Reviewed Date:** April 29, 2018 **What do you like best about SQLite?** Lightweight. Easy to use. Gets the job done efficiently **What do you dislike about SQLite?** Sometimes queries limitation could be a problem, otherwise its awesome. **What problems is SQLite solving and how is that benefiting you?** Using it to create tables on android. ### 42. Simple SQL application **Rating:** 3.5/5.0 stars **Reviewed by:** David F. | Guest Scientist Los Alamos National Laboratory, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** December 27, 2017 **What do you like best about SQLite?** small footprint, easy to use. It provides most of what is needed for a simple SQL interface. **What do you dislike about SQLite?** Doesn't implement enough SQL commands. so some SQL commands can't be used. **What problems is SQLite solving and how is that benefiting you?** Portable application with embedded database for more robust functionality than a simple configuration file would provide ### 43. Small, fast, and easy to use database **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Higher Education | Small-Business (50 or fewer emp.) **Reviewed Date:** July 31, 2017 **What do you like best about SQLite?** SQLite's most attractive feature is that the database is contained within a single file, so it's very easy to set up and test against, as well as migrating to other machines or platforms. It's also a surprisingly fast database, especially for queries. Finally, it has an excellent Python interface for integration into programs. **What do you dislike about SQLite?** SQLite lacks many fancy features of bigger database engines, such as stored procedures. It also doesn't handle concurrent writes very well (although reads are OK), so it wouldn't be a good choice on a heavily used website, for example. **Recommendations to others considering SQLite:** SQLite.org has a great page about the features and limitations of the product to see if it's right for you. However, it's quite easy to migrate data between SQLite and other engines (PostgreSQL or MySQL) so it's worth trying even if you're not sure about it. **What problems is SQLite solving and how is that benefiting you?** Some problems are solved quite naturally using SQL, so we store data in a local SQLite database and perform queries against it. The data are generally static for long periods so we're more concerned about handling concurrent reads rather than concurrent writes. Moreover, the query speeds in our experience are as good as PostgreSQL or MySQL without the management overhead of a full RDMS. ### 44. Easy to use **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** April 04, 2018 **What do you like best about SQLite?** Very simple and can be learnt in a short period **What do you dislike about SQLite?** Better ui can enable a more friendly experience **What problems is SQLite solving and how is that benefiting you?** Back-end for Java project ### 45. Very useful for mobile development **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** December 21, 2017 **What do you like best about SQLite?** Very powerful can create views and triggers **What do you dislike about SQLite?** Nothing as such. More in terms of writting stored procedures and functions if possible **Recommendations to others considering SQLite:** Very useful **What problems is SQLite solving and how is that benefiting you?** We are developing mobile applications and storing data on devices using sqlite ### 46. Used in conjunction with visual studio and works great. **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** November 30, 2017 **What do you like best about SQLite?** It became part of the package when developing websites. Allowed for quick connectivity without needing to load up a separate server. **What do you dislike about SQLite?** Set up for me repeatedly produced errors. Finding a solution took a fair amount of time. **Recommendations to others considering SQLite:** Highly recommended for use with visual studio **What problems is SQLite solving and how is that benefiting you?** I have used this when developing websites, it is a ideal solution when running on a single device. Doesn't require a server running in background draining resources. ### 47. Lightweight and quick **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Retail | Small-Business (50 or fewer emp.) **Reviewed Date:** January 10, 2018 **What do you like best about SQLite?** I prefer lite so alternatives like mongodb and postgre. **What do you dislike about SQLite?** I love using CLI but I'm not s huge fan of SQLite CLI. **Recommendations to others considering SQLite:** The syntax can be difficult but is very usable once you have a little experience. **What problems is SQLite solving and how is that benefiting you?** I'm building user dbs and it's query return speed is saving me time. ### 48. Good for a singleton application **Rating:** 1.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Small-Business (50 or fewer emp.) **Reviewed Date:** January 13, 2018 **What do you like best about SQLite?** SQLite is easy to use and powerful when embedded in applications **What do you dislike about SQLite?** There are very limited options for scaling **Recommendations to others considering SQLite:** Do not inadvertently use this where you may want to scale horizontally in the future. **What problems is SQLite solving and how is that benefiting you?** We used it in a key management tool with a lot of encryption ### 49. Simple, small and efficient **Rating:** 5.0/5.0 stars **Reviewed by:** Leonardo S. | Junior Developer, Transportation/Trucking/Railroad, Small-Business (50 or fewer emp.) **Reviewed Date:** October 28, 2017 **What do you like best about SQLite?** The simplicity of having a database of easy access and locomotion since all this is done through a single file. **What do you dislike about SQLite?** Problems of performance, I use for big project e it's is slow for big projects. **What problems is SQLite solving and how is that benefiting you?** A database local for the main project for tests and development. ### 50. SQLite Quick Review **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Non-Profit Organization Management | Small-Business (50 or fewer emp.) **Reviewed Date:** March 07, 2018 **What do you like best about SQLite?** Ability to manipulate queries and data as per requirements **What do you dislike about SQLite?** Complicated syntax makes it less user friendly **What problems is SQLite solving and how is that benefiting you?** Relational Databases ## 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=4&qs=pros-and-cons§ion=pricing&secure%5Bexpires_at%5D=2026-07-31+07%3A52%3A10+-0500&secure%5Bsession_id%5D=9a1df4f2-b002-4ed5-ad4c-be228d9eeb5c&secure%5Btoken%5D=b93f14b5b802042a0fbc93f5458c094360be2bfc9d63012601485c9e3841a4d6&format=llm_user) ## SQLite Integrations - [Python](https://www.g2.com/products/python/reviews) - [Visual Studio Code](https://www.g2.com/products/visual-studio-code/reviews) ## SQLite Features **Management ** - Data Schema - Query Language - ACID - Complaint - Data Replication **Support ** - Text Search - Data Types - Languages - Operating Systems **Security** - Database Locking - Access Control - Encryption - Authentication **Performance ** - Disaster Recovery - Data Concurrency - Workload Management - Advanced Indexing - Query Optimizer **Database Features** - Storage - Availability - Stability - Scalability - Security - Data Manipulation - Query Language ## Top SQLite Alternatives - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) - 4.4/5.0 (2,127 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) - 4.4/5.0 (1,581 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) - 4.3/5.0 (931 reviews)