The best cross-platform embedded database is free
July 07, 2022

The best cross-platform embedded database is free

Peter Chapman | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with SQLite

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
  • Excellent compatiblity
  • Wide range of supported platforms
  • Excellent feature set
  • Impressive speed and fault tolerance
  • No licensing fees has a net increase on ROI
  • The active community has kept support costs low, further increasing ROI
  • The wide range of supported platforms and high level of compatibility has increased ROI by reducing time spent porting the database model to any platform specific solutions.

Do you think SQLite delivers good value for the price?

Yes

Are you happy with SQLite's feature set?

Yes

Did SQLite live up to sales and marketing promises?

Yes

Did implementation of SQLite go as expected?

Yes

Would you buy SQLite again?

Yes

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.

Comments

More Reviews of SQLite