SQLite 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.

SQLite Reviews

3 Reviews

Mid-sized Companies (51-1,000 employees)

The great little database that could

Rating: 9 out of 10

Incentivized

May 3, 2021

Use Cases and Deployment Scope

We use SQLite for file based data integration and ETL's. Only the IT Department uses SQLite due to its technical nature.

Pros

In memory database is extremely fast
Supports nearly all database capabilities
Lightweight footprint for using on many types of devices (mobile, PC, consumer devices)

Cons

Not multi-user due to its file locking design, but this supports its efficiency and speed strengths
Doesn't offer all join options typically available in standard databases
High repetitive single table writes can be problematic

Likelihood to Recommend

[SQLite is well suited for:]

Mobile app development (storing user application data on a smart device)
Supporting fast ETL's in scripting type programs or console applications
Usable on embedded and low power hardware such as Raspberry Pi's

[SQLite is not well suited for:]

Would not be good as a centralized database where many clients are trying to read/write at the same time

Alternatives

Microsoft SQLExpress: More heavyweight, not as lean in terms of disk space or processing requirements. Involves Microsoft's tentacles to be involved.

Verified User

Professional in Information Technology (Utilities company, 201-500 employees)

Vetted Review

2 years of experience

SQLite is the better Database for Mobile Applications

Rating: 9 out of 10

Incentivized

March 3, 2020

Use Cases and Deployment Scope

We use SQLite in our mobile projects by the Application development team.

SQLite solves our problem for storage in the APP database for offline data.

Pros

Xamarin.Forms Compatibility
Free
Easy Implementation

Cons

Limited for many rows
Documentation

Likelihood to Recommend

SQLite is perfect for applications that need to save data offline and then synchronize. It is not good if you have many lines in the local SQLite base.

Alternatives

Realm

SQLite is already better known in the market. Developers already know how to implement and use good practices.

Rogério Rodrigues

Team Lead in Information Technology at SternTI (Information Technology & Services, 201-500 employees)

Vetted Review

6 years of experience

View profile

SQLite — First choice every time

Rating: 9 out of 10

Incentivized

July 29, 2016

Use Cases and Deployment Scope

SQLite provides a quick and easily accessible means to store data on the local mobile device. Because of it's broad inclusion in various devices, I can be sure of it's availability. When debugging applications, I can reliably get access to the contents of the file with a variety of available applications.

Pros

SQLite is readily available. It has been included with iOS for as long as there's been a way for 3rd party developers to write apps for it.
SQLite is small. When you think about the original iPhone and how little RAM it had, it's inclusion of SQLite is a testament to how little SQLite requires to work properly.
SQLite is fast. I've never had issues with the speed of data retrieval while using this product. When I think of local storage when creating an iOS app, the first thing I turn to is SQLite.

Cons

Better data recovery when the database becomes corrupt would be ideal. I've learned to minimize it by closing the database more frequently, but it can still happen.
Lack of built-in data encryption.
SQLite is a single-user DBMS. If a multi-user system is required, then an alternative is required.

Likelihood to Recommend

Most situations for local data storage can be easily handled by SQLite. If data encryption is needed, there are special builds available. Moving beyond the mobile space, SQLite is not designed for extremely large quantities of data or multi-user . Special consideration should be made of how much data is expected over the life of the product use. It is also not designed for simultaneous multi-user access.

Alternatives Evaluated

Valentina

When looking at the original items available, Valentina was a serious contender. What was good about SQLite was the familiar SQL interface and way it accessed data. Valentina, at the time, had issues with index corruption requiring vigilance with the database maintenance making it difficult to use in the mobile space.

Aaron Bratcher

iOS Developer in Information Technology at AT&T (Market Research, 51-200 employees)

Vetted Review

3 years of experience

View profile

Loading Reviews List....

SQLite — First choice every time

Rating: 9 out of 10

Incentivized

July 29, 2016

Use Cases and Deployment Scope

Pros

SQLite is readily available. It has been included with iOS for as long as there's been a way for 3rd party developers to write apps for it.
SQLite is small. When you think about the original iPhone and how little RAM it had, it's inclusion of SQLite is a testament to how little SQLite requires to work properly.
SQLite is fast. I've never had issues with the speed of data retrieval while using this product. When I think of local storage when creating an iOS app, the first thing I turn to is SQLite.

Cons

Better data recovery when the database becomes corrupt would be ideal. I've learned to minimize it by closing the database more frequently, but it can still happen.
Lack of built-in data encryption.
SQLite is a single-user DBMS. If a multi-user system is required, then an alternative is required.

Likelihood to Recommend

Alternatives Evaluated

Valentina

Aaron Bratcher

iOS Developer in Information Technology at AT&T (Market Research, 51-200 employees)

Vetted Review

3 years of experience

View profile