What users are saying about
Top Rated
55 Ratings
23 Ratings
Top Rated
55 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.3 out of 101
23 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.9 out of 101

Add comparison

Likelihood to Recommend

Amazon DynamoDB

DynamoDB is great for two cases. The first is for services that do not experience high loads or demand high availability. DynamoDB is inexpensive, and it provides great developer velocity. The second is for applications that demand high performance, have well-understood requirements, and a narrow range of queries.
No photo available

SQLite

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.
No photo available

Feature Rating Comparison

NoSQL Databases

Amazon DynamoDB
8.5
SQLite
Performance
Amazon DynamoDB
8.4
SQLite
Availability
Amazon DynamoDB
9.2
SQLite
Concurrency
Amazon DynamoDB
9.2
SQLite
Security
Amazon DynamoDB
9.0
SQLite
Scalability
Amazon DynamoDB
9.7
SQLite
Data model flexibility
Amazon DynamoDB
6.6
SQLite
Deployment model flexibility
Amazon DynamoDB
7.3
SQLite

Pros

  • No need to worry about hosting and ease of scaling and operations
  • Distributed and flexible as Amazon DynamoDB does not have a fixed schema
  • Based on load, options to increase throughput
No photo available
  • 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.
Aaron Bratcher profile photo

Cons

  • Because of the lack of relations in AmazonDynamoDB, mapping very complex objects that you would typically decompose into related entities is difficult. Amazon DynamoDB is typically not great for this use case.
  • Amazon DynamoDB doesn't do strong type checking (there is typing, but it's relatively limited), so depending on your language you may have to expend some effort to properly map an Amazon DynamoDB object to a programmatical entity.
  • Depending on how much need you have for Amazon DynamoDB's performance, it can be a major pain to maintain... especially if you also have a relational database. In my current project, we utilize Amazon DynamoDB alongside PostgreSQL and entities live in one, the other, or both as appropriate. Synchronizing the database is a pain point.
Jordan Bayles profile photo
  • 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.
No photo available

Likelihood to Renew

Amazon DynamoDB8.0
Based on 17 answers
Many of our projects are too small to fully appreciate the value of Amazon DynamoDB. I would be enthusiastic if I felt the use case warranted Amazon DynamoDB, otherwise it's just a major pain.
Jordan Bayles profile photo
No score
No answers yet
No answers on this topic

Alternatives Considered

Richard Rout profile photo
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 profile photo

Return on Investment

  • We have had to back out some entities out of Amazon DynamoDB in favor of a relational database, which has been a major issue costing us around 20 man days of effort.
  • Amazon DynamoDB has given us extremely fast search, by indexing dynamo entities in Amazon CloudSearch and then doing fast lookup in dynamo of the key stored in Amazon CloudSearch.
  • Overall, Dynamo has been a pain point due to smaller situations typically requiring a simple, relational database. I would be enthusiastic about Dynamo for large tables, but when needs are smaller it can be overkill.
Jordan Bayles profile photo
  • SQLite's market penetration provided a means to bring our product to market quickly.
  • Ease of use let us focus on the product development without needing to learn a large API.
  • Free applications let us design our schema without fuss.
Aaron Bratcher profile photo

Pricing Details

Amazon DynamoDB

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

SQLite

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details