What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
Top Rated
79 Ratings
26 Ratings

Amazon DynamoDB

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
Top Rated
79 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.5 out of 101
26 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.8 out of 101

Likelihood to Recommend

Amazon DynamoDB

If you start with Amazon DynamoDB, you are over optimizing for the future. In my opinion, use Amazon DynamoDB only when SQL can not handle the load of your application.
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.6
SQLite
Performance
Amazon DynamoDB
8.9
SQLite
Availability
Amazon DynamoDB
9.2
SQLite
Concurrency
Amazon DynamoDB
9.1
SQLite
Security
Amazon DynamoDB
9.3
SQLite
Scalability
Amazon DynamoDB
9.5
SQLite
Data model flexibility
Amazon DynamoDB
6.6
SQLite
Deployment model flexibility
Amazon DynamoDB
7.2
SQLite

Pros

Amazon DynamoDB

  • Security and managing infrastructure are the first reason why we selected DynamoDB. It takes quite an effort to set other NoSQL databases up in EC2 instances. Since DynamoDB offers single click table (Collection equivalent in MongoDB) setup, it's pragmatic to give this a first shot.
  • It provides decent querying capabilities with excellent documentation. If you have a JSON structure that's relatively flat (not more than 2 nested JSON objects) that needs querying, DynamoDB would be a great choice for you.
  • Neat CLI API that allows for easy setup in a local development environment would make the life of a developer a breeze. This again brings the benefit of having great documentation.
Anudeep Palanki profile photo

SQLite

  • Our products are using SQLite in embedded Linux and in Windows software.
  • It is truly a stable cross-platform database.
  • The fact that it is a zero-configuration database engine, it is particularly a nice advantage when you work in the embedded world.
  • Being a single database file, it provides ease for those who need to quickly transfer data to someone else, or quickly browse data.
No photo available

Cons

Amazon DynamoDB

  • 64KB limit on row size and 1MB limit on querying
  • Increasing throughput is expensive
  • Secondary indexes are not supported
No photo available

SQLite

  • 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.
Aaron Bratcher profile photo

Likelihood to Renew

Amazon DynamoDB

Amazon DynamoDB 8.7
Based on 27 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

SQLite

No score
No answers yet
No answers on this topic

Usability

Amazon DynamoDB

No score
No answers yet
No answers on this topic

SQLite

SQLite 9.0
Based on 1 answer
I have had a wonderful experience with SQLite because in my every project I use SQLite in the development phase because it's really fast, doesn't crash and very easy to maintain as well. It saves a lot on physical memory and dedicated server usage. It has all the basic functionality you would need to get the job done and that too at no cost at all. What more could you ask for !!!
No photo available

Alternatives Considered

Amazon DynamoDB

Amazon DynamoDB is a strong contender for an enterprise NoSQL database. We chose Amazon DynamoDB due to:
  1. easy inclusion in our AWS architecture
  2. fast performance with no setup
  3. appropriate balance of object retention and speed compared to other databases available in AWS
Jordan Bayles profile photo

SQLite

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

Amazon DynamoDB

  • Very cheap to set-up and run in production.
  • Great ROI compared to running a managed solution or database servers.
Arjun Komath profile photo

SQLite

  • 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

Add comparison