How to Choose a Database on AWS

SQL or NoSQL? MongoDB or DynamoDB? AWS has a lot of database options. Get help deciding which database solution to choose using my simple flowchart.

🎉 SUPPORT BE A BETTER DEV 🎉

📚 MY RECOMMENDED READING LIST FOR SOFTWARE DEVELOPERS📚

🎙 MY RECORDING EQUIPMENT 🎙

💻 MY DESKTOP EQUIPMENT 💻

📚 References:

☁Topics covered include:
AWS RDS
AWS Elasticache
AWS DynamoDB
AWS DocumentDB
AWS Cloudsearch

🌎 Find me here:

#AWS
#Databases
#SQL
#NoSQL

[yawnnroar]

This video helped me land a new job during a system design interview!! Thank you!!!

[jriverox]

236/5000
Based on the fact that dynamodb is a key value databse, it works well for particular cases but for more advanced query scenarios such as paginated queries, ordering by several fields or aggregations, I would choose documentdb

[naimulsayed]

Great explanation. The things I was wondering for years, you solved in 6 mins ❤. Thanks a lot

[VenkateshJayapal]

You saved lot of my time to read through the docs for each and find the difference 🙏 thank you!

[LuisPerez-cefn]

Amazing explanation, no bs. You got a new follower

[daviisebarn]

Dude that video made everything in my head click you are a legend!

[prabhakarmishra]

I highly appreciate the way you have explained it all, lots of love from India

[GameboyZoneRocks]

Great video and well explained with a workflow.

[alejandropereira]

But ElasticCache is used for performance. It is a cache for databases. It can be used for an rds database to avoid the query go to the engine and also reduce latency. I think this is important to mention. At least it is useful for data that rarely is updated. If we have data that changes very frequently, then read replicas is the way to go.

[akin]

Keep it size and industry needs based:
- Mariah DB for transactional information and small business.
- AWS Redshift for large scale reliable variable SQL needs.
- Dynammo DB for choatic information using NoSQL (key value or document).

[cemmer]

Thank you, really good guidance right there.

[guesme]

Great explanation but I was surprised at the very end, where Elastic Cache is suggested as persistence layer. The cache doesn't guarantee data durability. The application will lose its data if the underlying infrastructure/hardware changes.

[ChetanNandikanti]

Current Database services in AWS simplified 😉. Thanks for quick summary!

[drkazn]

Quick Question, isnt RDS a managed service? Why does the arrow for unmanaged loops to RDS?

[TheEchinox]

Would you be kind enough to share the flowchart link?

[philipdodson]

Why automatically use elasticache if you don’t need relations or transactions? Isn’t it more expensive than RDS or dynamoDb?

[Hiroki-Takahashi]

Is it a bad idea to use Dynamo DB or Aurora Serverless for a prototype or a hobby project?
Dynamo DB's storage is free for the first 25 GB and $0.25 per GB-month thereafter. With Aurora Serverless, you only pay for the database capacity, storage, and I/O when it is active.
When your prototype app or hobby project is small, I think both services can be suitable because they are economical for small apps that don't have a lot of traffic. Am I missing something?

[explorethenewworld]

what about geo queries ????
which db is best for geo spatial ???

[dimatall]

Good explanation of RDS. But what about self hosted Postgres on EC2 instance ? Is it cost effective solution for small project or startup? Or it is not as reliable as RDS is?

[screwyou]

Where do RedShift and AWS Timeseries fall into?