Why use DynamoDB over S3?
Unlike S3, DynamoDB provides a granular, item-level control suitable for web-scale applications. It's most beneficial when dealing with applications that require complex queries and rich data models, on-demand capacity, and real-time processing needs.DynamoDB helps customers handle their high-traffic, extreme-scaled events seamlessly with nearly unlimited throughput. Discover how Amazon DynamoDB can power your use cases such as localizing content, building a well-architected customer data platform, deploying shopping carts, tracking inventory, and more.When not to use DynamoDB: When multi-item or cross table transactions are required. When complex queries and joins are required.

What is DynamoDB best suited for : Storage of inconsistent schema items

Since DynamoDB is a NoSQL data model, it handles less structured data more efficiently than a relational data model, which is why it's easier to address query volumes and offers high performance queries for item storage in inconsistent schemas.

Why not use S3 as a database

Disadvantages of AWS S3 as a Database:

Lack of Native Querying: While S3 provides excellent storage capabilities, it does not natively support traditional querying capabilities like a dedicated database. You need to rely on additional tools or libraries to query the data stored in S3 efficiently.

Is DynamoDB more expensive than S3 : Dynamodb is cheaper for small object size but s3 is cheaper for large object size.

DynamoDB will work well in a lot of various scenarios, but you need to be aware of the downsides. Primarily, that it doesn't allow for traditional SQL queries and access patterns, which means for things like free-text search or ad-hoc queries, you'll likely need to export data to a different system.

Disadvantages of DynamoDB

Limited Secondary Indexes: DynamoDB has limitations on the number and types of secondary indexes that can be created, which can affect query flexibility.

Does Netflix use DynamoDB

To provide a personalized viewing experience, Netflix relies on Amazon DynamoDB for high-performance database management. DynamoDB's NoSQL database service enables rapid and flexible data retrieval, allowing Netflix to tailor content recommendations to individual user preferences.Key issues with Delta Lake on top of S3 as the platform for a data lake include: The architecture does not address the creation of changesets, which can be quite challenging to create. It is quite complex to implement and support enterprise-grade, resilient Extract, transform and Load (ETL) solutions.The pricing of S3 is cheaper compared to RDS. But it is to be noted that S3 is only a storage layer and if you have processing requirements, you will need to pay for another service from Amazon. S3 pricing is specified in terms of storage requirements and network requirements.

You need to optimize your throughput, to balance out cost vs. performance, if you're hoping to make DynamoDB work for you. At 1,000 rows per second, it takes 3 hours to insert 10 million rows, and cost $2.22. At 10,000 rows per second, it takes 17 minutes to insert 10 million rows, but cost $7.44.

Why is DynamoDB so fast : DynamoDB provides faster lookup times as the data is structured in a document-based format. Additionally, DynamoDB does not require a pre-defined schema that helps scale data easily.

Why MongoDB is better than DynamoDB : MongoDB supports many more data types, including dates. Second, DynamoDB enables querying via key-value lookups and table scans. However, its table scan performance is lacking. For more complex or ad hoc-style queries, your best option is to export to a different database.

Is DynamoDB good for long term storage

The DynamoDB Standard-IA table class is ideal for use cases that require long-term storage of data that is infrequently accessed, such as application logs, old social media posts, ecommerce order history, and past gaming achievements.

Netflix uses Amazon Simple Storage Service (Amazon S3) to store and distribute its media files. Amazon S3 provides scalable object storage with high availability, durability, and low latency. Netflix employs a multi-region deployment strategy to ensure reliable content delivery and disaster recovery.Data Storage — MySQL and Cassandra

Netflix employs a combination of SQL and NoSQL databases, each serving a unique purpose. MySQL, with its strong consistency and reliability, serves as the source of truth for most business data.

When should you not use S3 : TL;DR – If you're hosting a website with medium-large amounts of traffic with regularly scheduled updates, it is much more cost efficient to host assets yourself and use external CDNs (or even things like DigitalOcean CDN) instead of using S3 and CloudFront (where data traffic rates are through the roof).