What users are saying about
Top Rated
102 Ratings
31 Ratings
Top Rated
102 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.5 out of 100
31 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.8 out of 100

Likelihood to Recommend

Amazon DynamoDB

It is ideal for those projects where you need to store a large amount of data, but you do not know how many will be so you need the database to increase its storage capacity together with the number of users, without having to spend extra money, it also has a great potential thanks to the fast connection it offers, so the data travels at high speed, and this speeds up the performance of the applications, excellent for projects where non-relational databases are used and what matters is to store large quantities of information and use them at high speed.
Winston Mendes | TrustRadius Reviewer

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.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

NoSQL Databases

Amazon DynamoDB
8.5
SQLite
Performance
Amazon DynamoDB
8.7
SQLite
Availability
Amazon DynamoDB
9.3
SQLite
Concurrency
Amazon DynamoDB
8.7
SQLite
Security
Amazon DynamoDB
9.0
SQLite
Scalability
Amazon DynamoDB
8.9
SQLite
Data model flexibility
Amazon DynamoDB
7.1
SQLite
Deployment model flexibility
Amazon DynamoDB
8.1
SQLite

Pros

Amazon DynamoDB

  • It's very easy to get started, creating a table with a partition/sort key and you're on your way.
  • You can scale up and down your read/write IO as needed.
  • You can store structured and unstructured data.
  • It works great with Web Development as it's JSON based.
Bob Smith | TrustRadius Reviewer

SQLite

  • The biggest one has to be that it is freeware and open source as well. It means for an entry level person who wants to learn relational database and even for a team in the early development stage where security and size of the data are not much, it is a perfect fit in those cases.
  • It requires no extra configuration or space because it a server-less installation and also done in just a few mins. So, installing this is never a blocker. It is the actual lite version of SQL as the name suggests and it very powerful and capable of doing all the things which SQL can do, but lacks some of the security and advanced features.
  • It prepares the data for us in a structured form in terms of Tables with a file size less than 1 Mb for the complete database entries. It saves us a lot of physical space.
  • It is the most suitable DB for Android systems because mobile apps do not have a lot of space or resources for a separate DB, but this one integrates with the whole ecosystem very nicely and we are able to make the most out of it and that too with a file lesser than 1 Mb in size.
Anonymous | TrustRadius Reviewer

Cons

Amazon DynamoDB

  • Complex searching (no support for case-insensitive or full-text search).
  • Only supports up to two-key indexes.
  • Requires choosing the indexes up-front when doing searches.
  • Does not have an SQL compatible query front-end.
  • No join-table support (requires putting all data into one table).
Chris Moyer | TrustRadius Reviewer

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 | TrustRadius Reviewer

Likelihood to Renew

Amazon DynamoDB

Amazon DynamoDB 8.7
Based on 34 answers
We will most likely continue to use DynamoDB for certain use-cases. If we stopped using DynamoDB as often, it would likely be because we started using Aurora Serverless more. Aurora Serverless may offer similar availability, management and cost benefits while allowing developers to use their MySQL tools and experience.
Anonymous | TrustRadius Reviewer

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 !!!
Anonymous | TrustRadius Reviewer

Support Rating

Amazon DynamoDB

No score
No answers yet
No answers on this topic

SQLite

SQLite 1.0
Based on 2 answers
I haven't needed support yet.
Rogério Rodrigues | TrustRadius Reviewer

Alternatives Considered

Amazon DynamoDB

We evaluated using MongoDB or Amazon DyanmoDB. For us, the biggest advantage is that there's no maintenance cost for Amazon DynamoDB. Mongo gets complicated when you setup sharding. With Amazon DynamoDB, it's literally a push of button to increase throughput. This saves time and money on DevOps resources.
Anonymous | TrustRadius Reviewer

SQLite

SQLite stacks quite well against Microsoft SQL Server management studio however we need the Microsoft security for our data MDSN documentation is poor but available.
Marco Lostaunau | TrustRadius Reviewer

Return on Investment

Amazon DynamoDB

  • Since the Amazon manages the instance, the amount of time a developer needs to spend configuring the database is less. For comparison, if we were to manage the same instance manually, we need to set up EC2 instance, install the DB, setup backup scripts, track backup failures, which is a great overhead for the dev. Using DynamoDB this overhead is reduced and hence having a great ROI.
  • Great documentation and easy setup makes an easy learning curve to transition to DynamoDB. Only caveat is as with any database, the data structure should be thoroughly analyzed for types of querying because there are limitations with the DynamoDB API.
  • Ties very well with rest of the Amazon eco system. Having rest of the applications in Amazon allows managing the application security a breeze.
Anudeep Palanki | TrustRadius Reviewer

SQLite

  • We could start immediately to work with SQLite.
  • It's very easy. The document is well done and easy to find.
  • Having such good database system, free of charge and for any purpose is good news.
Anonymous | TrustRadius Reviewer

Screenshots

SQLite

Pricing Details

Amazon DynamoDB

General

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

Amazon DynamoDB Editions & Modules

Edition
On-Demand - Write Operation$1.251
On-Demand Read Operation$0.251
On-Demand Data Stored$0.252
On-Demand Point-in-Time Recovery$0.202
On-Demand Snapshot$0.102
On-Demand Restoring a Backup$0.153
On-Demand Global Tables$1.8754
On-Demand Streams$0.025
On-Demand Data Requests Outside AWS Regions$0.096
Provisioned - Write Operation$0.000657
Provisioned - Read Operation$0.000137
Provisioned - Data Stored$0.258
Provisioned - Point-in-Time Recovery$0.208
Provisioned - Snapshot$0.108
Provisioned - Restoring a Backup$0.159
Provisioned - Global Tables$0.00097510
Provisioned - Streams$0.0211
Provisioned - Data Requests Outside AWS Regions$0.0912
  1. per million requests
  2. per GB per month
  3. per GB
  4. per million write operations replicated
  5. per 100,000 read operations
  6. per GB
  7. capacity unit per hour
  8. per GB per month
  9. per GB
  10. per Read Capacity
  11. per 100,000 read operations
  12. per GB
Additional Pricing Details

SQLite

General

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

SQLite Editions & Modules

Additional Pricing Details

Rating Summary

Likelihood to Recommend

Amazon DynamoDB
8.8
SQLite
8.7

Likelihood to Renew

Amazon DynamoDB
8.7
SQLite

Usability

Amazon DynamoDB
SQLite
9.0

Support Rating

Amazon DynamoDB
SQLite
1.0

Add comparison