With Great Power Comes Great Responsibility
Rating: 8 out of 10
IncentivizedUse 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.
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.
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.
Vetted Review
7 years of experience