Which AWS Database Should I Use?

A tour through the most popular AWS database options, and the questions you'll need to ask to know which one is right for your use case.
Covered in this video:
DynamoDB
DocumentDB
MemoryDB
ElastiCache
Redshift
Athena
RDS
Timestream
Neptune
00:00 Intro
00:18 Main Things to Consider
00:30 Fields Used In Queries
01:02 OLAP vs OLTP
01:34 Strict Schemas
01:54 Normalization
02:17 Sharding
02:43 Time Series
03:05 Graph based data
03:13 Durability Guarantees
03:36 Flow Chart for Choosing a Database
04:10 Migration from an Existing Database
04:43 Athena
05:04 Conclusion
Here is the video about AWS Timestream referred to in this video: • If You Have Time, Cons...

[@YoelvisM]

Amazing videos, subscribed!!

[@codetothemoon]

Thanks so much for the support, very happy to have you on board!

[@aazzrwadrf]

excellent summary

[@codetothemoon]

Thank you! Glad you liked it!

[@gnomeddev]

Why would an AWS DB be better than just sticking your data on a local/vps postgres server?

[@codetothemoon]

I think the answer to this is similar for any cloud based service - it's a means of outsourcing infrastructure setup. Instead of managing hardware (including upgrades/migrations), operating system updates, security patches, a fast internet connection, etc) the cloud service handles all of it for you. But if the rest of your infrastructure is local and there are no plans to move it to the cloud, it might not make sense to use a cloud provider for your database.

[@denisekohlmann9234]

Hehe… sharded