1. Home
  2. Open-Source Database Software
  3. SQLite Reviews
  4. User Review of SQLite
Best Database for 2021- My SQLite
August 27, 2021

Best Database for 2021- My SQLite

Mantosh Kumar | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with SQLite

I am a regular user of the SQLite database in my several iOS projects. Even other teams also using SQLite in my organization. It is fast and I can say easy to install in existing and new projects. It supports many cross-platforms as well like iOS, Android, MAC, windows as well. SQLite is fully open source and developers can modify it according to their use. SQLite database can be used for small to large scale projects. It is available for a long time in the market so it has a very large community and easy to get any type of help from StackOverflow.
  • It supports many cross-platform like iOS, Android, MAC, Windows projects
  • It is open source, and all code are public, developers can easily modify.
  • Easy to integrate in existing or new projects
  • In many case SQLite wont support Relational database feature.
  • If a application which scale-out very fast, for that type of project we need to use carefully
  • It is free and open source
  • Easy in implement so it save time
  • Document are available for its Query
  • It have large community’s
  • Same SQLite structure we are using for both iOS and Android. So it save lot's of time to design Database Schema.
  • It support for JSON data
  • We can do manipulation into external file as well. (eg CSV files)
SQLite has many types of queries to do CRUD operations. and even do manipulation to external files as well. it is fast and easy to implement compared to other Databases.
SQLite support atomic behaviours, so app crash in any situation, the won't impact database or data within it. SQLite is best suited for desktop or mobile apps.

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

One SQLite database structure can be used by one or many other platforms like iOS, Android, even python as well. Many third-party ORM's and data layers are available in the market for SQLite, which make developer life easy. and it saves development time. It supports JSON and CSV files. SQLite can work with in-memory data or external files.