SQLite Information Reviews & Insights

Score9.6 out of 10

45 Reviews and Ratings

Community insights

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.

Reviews

2 Reviews

Information

The best cross-platform embedded database is free

Rating: 10 out of 10

Incentivized

July 7, 2022

Use Cases and Deployment Scope

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.

Peter Chapman

Senior System Architect in Information Technology at Conglomo Limited (Computer Software, 1-10 employees)

Vetted Review

3 years of experience

With Great Power Comes Great Responsibility

Rating: 8 out of 10

Incentivized

April 11, 2018

Use Cases and Deployment Scope

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.

Verified User

Engineer in Engineering (Computer Software company, 11-50 employees)

Vetted Review

7 years of experience

Loading Reviews List....