What users are saying about

Amazon DynamoDB

Top Rated
52 Ratings

SQLite

23 Ratings

Amazon DynamoDB

Top Rated
52 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.2 out of 101

SQLite

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
7.9
SQLite
Performance
Amazon DynamoDB
8.0
SQLite
Availability
Amazon DynamoDB
8.4
SQLite
Concurrency
Amazon DynamoDB
9.0
SQLite
Security
Amazon DynamoDB
8.7
SQLite
Scalability
Amazon DynamoDB
9.7
SQLite
Data model flexibility
Amazon DynamoDB
4.0
SQLite
Deployment model flexibility
Amazon DynamoDB
7.3
SQLite

Pros

  • Amazon DynamoDB is infinitely scalable. It is fast and Amazon automatically allocates more resources.
  • No predefined schema is required. This ensures flexibility.
  • Minimum administrative cost since Amazon manages all that. This works for small companies since you don't need a DevOps headcount.
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

  • 64KB limit on row size and 1MB limit on querying
  • Increasing throughput is expensive
  • Secondary indexes are not supported
No photo available
  • 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 DynamoDB6.9
Based on 13 answers
Its more of a we are locked in and migration would be more time and resource intensive than is worth it. It is better to find ways to optimize dynamo usage like custom scaling, Redis based caches, or moving data to S3 than to leave the platflorm completely. It provides enough incentive and usefulness to continue to use
Adam Lauer profile photo
No score
No answers yet
No answers on this topic

Alternatives Considered

Sql is much more feature rich yet costly and harder to maintain. Requires physical servers while dynamo everything is in the cloud across multiple AZs. Redis is actually great to put on top of dynamo to use as a read cache which is much faster and cheaper, but the storage and retrieval options are not as robust and the reliability is decreased
Adam Lauer profile photo
I think there is no real competition between them.In "SQLite" you can hear "light" when you don't need to store a big amount of data and when you need something easy to deploy, SQLite is a good choice, I didn't find those qualities in other database systems I knew.
No photo available

Return on Investment

  • Better faster coding for data storage and retrieval
  • Can get very expensive very fast for some use cases, while really cheap for others
  • Hidden errors and short falls leads to very frustrating troubleshooting
Adam Lauer 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