TrustRadius: an HG Insights company

SQLite Reviews & Insights

Score9.6 out of 10

45 Reviews and Ratings

Get a Demo

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.

SQLite Reviews

1 Review
Engineering

With Great Power Comes Great Responsibility

Rating: 8 out of 10
Incentivized

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.

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)
Vetted Review
SQLite
7 years of experience