TrustRadius Insights for SQLite are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Pros
Easy to Use: Many users have found SQLite to be easy to use, with a simple and intuitive syntax. Some reviewers have appreciated its simplicity in operation and integration, making it a convenient choice for developers.
High Compatibility with Android Applications: Several users have highlighted that SQLite is highly compatible with Android applications, making it easy to use in mobile development. This compatibility allows developers to seamlessly integrate SQLite into their Android projects without any major issues.
Frequent Updates and Active Maintenance: Reviewers have mentioned that SQLite is frequently updated, indicating that it is actively maintained and improved. This continuous improvement ensures that the database remains up-to-date with the latest features and enhancements, providing a reliable solution for developers.
We have been using SQLite for a long time now along with Python. it is excellent as it works as an independent Database thus allowing us to create easily scalable applications. WE use it in our machine learning application to store static data which needs regular retrievals of for Data cluster creation.
Pros
SQLite is easy top install and portable.
Table creation is easy with SQLite when using Python.
Cons
Not being Multi user it doesn't allow multiple user to create concurrent queries
no inbuilt Data viewer is available for SQLite
Likelihood to Recommend
I First Used SQLite with Python when I was a fresher and didn't know much about Databases. SQLite helped me create initial projects with ease and helped me understand RDBMS. Currently, we use SQLite to store DATA outputs which are in the form of JSONS produced by our Algorithm containing Hirerachical trees of the datasets from sample data which are later used by our application for processing.
Alternatives
Microsoft SQL Server
SQLite is faster and also Light weight as compared to Microsoft SQL Server. Also being open source it reduces the application development cost drastically
VU
Verified User
Professional in Information Technology (Hospital & Health Care company, 11-50 employees)
SQLite is an excellent tool because it's easy to use with many languages, especially C#. Because SQLite is quicker and easier to integrate, we use it for C++ applications. And yes, we also used it with web and mobile applications when we needed instant access to a small database. It's the most widely used database with many high-profile applications. We can use it to create long-term storage for our applications without installing anything. It is a transactional SQL database engine self-contained, serverless, and requires zero configuration. This software is fast, reliable, suitable for small and big projects, user-friendly, and easy to learn.
Pros
Easy-to-use.
An easy-to-use query.
Simple to understand syntax.
Simple in both operation and integration.
In Android applications, it is simple to use.
Frequently updated cross-platform database.
Cons
The transaction moves slowly.
Too many search windows are confusing.
Database size is limited to about 2GB, which is not good.
Likelihood to Recommend
SQLite is a lightweight and efficient database management system. With SQLite, performance increases as memory are added. It's reliable and well-tested before release. SQLite handles memory allocation and I/O errors gracefully. SQLite provides bug lists and code-change chronologies. All bugs are disclosed, and it's compatible with iOS, Android, MAC, and Windows. SQLite is open-source, allowing developers to tailor it to their specific needs.
Alternatives
Microsoft SQL Server
SQLite has CRUD queries and manipulates external files. Cross-platform support includes iOS, Android, Mac OS X, and Windows. Compared to other databases, it is fast and straightforward to implement. Even if an application crashes, there is no effect on the database or the data it contains. The user interface is best for input and output. It's best for developing skills and project deliverables.
SQLite is my number one choice when I am looking for an embedded database for any cross platform solution. With SQLite, we have been able to create one database model and deploy it across all platforms, including mobile, desktop, and embedded systems. I have not found a better supported multi-platform solution than SQLite. For example, in a recent mobile app upgrade, we were able to roll out full text search across iOS, macOS, Windows, and Android, all from a prepopulated database generated once and deployed multiple times.
Pros
Compatibility across many platforms
Speed and low resource use
Full Text Search out of the box
Excellent user community and adoption across the industry
Cons
Scaling beyond embedded instances will require moving to another platform
Vendor supplied tools are not as comprehensive as other RDBMS solutions
The documentation lacks the professional polish of its competitors
Likelihood to Recommend
Nothing beats SQLite if you are wanting an easy to use embedded database solution that runs out of the box across a wide range of platforms. If your solution is not likely to scale into a N-tier or client-server architecture, you will find that SQLite serves you well for your application's lifetime.
Both Android and iOS provide comprehensive support for SQLite, and SQLite's own high level of compatibility between versions means that you only need to create a database once to deploy it across multiple platforms.
SQLite is used by the R&D department. SQLite is the database engine we have chosen to handle data from the measurement device we developed, which runs an embedded Linux.
Pros
Our products are using SQLite in embedded Linux and in Windows software.
It is truly a stable cross-platform database.
The fact that it is a zero-configuration database engine, it is particularly a nice advantage when you work in the embedded world.
Being a single database file, it provides ease for those who need to quickly transfer data to someone else, or quickly browse data.
Cons
We experienced a problem due to a bug in the Linux library of SQLite.
All devices we already sold to our customers were impacted.
We could solve it by deploying the new library version which included the fix.
But as always, a piece of software is always better if it's bugs free.
Likelihood to Recommend
I recommend the use of SQLite for embedded systems. If you need to store a large amount of data, store blobs, use triggers, handle multiple accesses at the same time, and need to optimize indexes, then I would recommend using another database system. SQLite should also be considered if the installation/configuration of a heavier database system is a problem.
Alternatives
ms access, MySQL and PostgreSQL
I think there is no real competition between them. In "SQLite" you can hear "light" when you don't need to store a big amount of data and when you need something easy to deploy, SQLite is a good choice, I didn't find those qualities in other database systems I knew.
VU
Verified User
Engineer in Engineering (Computer Software company, 11-50 employees)
It was being used for low scale data storage. It was easy to use and integrate to our application which made it the best choice.
Pros
SQLite is in the public domain and does not require a license making it perfect for smaller startups.
A lot of documentation available which will make training developers new to SQLite transition easily
Cons
Public code makes it more accessible however it makes it more vulnerable to possible attacks
Not as easy to scale into a larger application compared to Microsoft Sql Management Studio
Likelihood to Recommend
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.
Alternatives Evaluated
microsoft sql server management studio
SQLite stacks quite well against Microsoft SQL server management studio however we need the Microsoft security for our data MDSN documentation is poor but available.
