You're an amazing person! I know you answered my question about the differences in Amazon Aurora and Dynamo DB in another video response of mine, but to take it a step further and create a video that thoroughly breaks down the differences and how and when they are used is literally something that I had no idea I wanted. I truly want to thank you for making difficult study undertakings so great for the average Joe. Please keep these videos coming as I'm watching as many as possible to make sure I can not only pass the test but to work in this field.
@BeABetterDev3 жыл бұрын
Thanks Noah! This video was inspired by your earlier question, and I hope you enjoyed the content! This comment means a lot to me and is part of the reason I find making videos so enjoyable. I truly appreciate your kind words and continued support. Stay safe during these uncertain times! Thanks, Daniel
@noahlomax13 жыл бұрын
@@BeABetterDev Daniel, the inspiration is definitely mutual. I really appreciate you helping me along my AWS path. Not only are your videos relevant to the certification test, but for life. I will continue to watch and learn even after passing the certification. I'm truly staying safe and I pray and hope the same for you and your family, Daniel. Thank you again.
@xVersioNz2 жыл бұрын
i can tell you put a lot of effort into this video! It was done perfectly, thank you!
@BeABetterDev2 жыл бұрын
Thanks Harry!
@namritp Жыл бұрын
Watched several videos to get concept of RDS vs Aurora vs Aurora Postgres, but none explained the way you did ! You have the ability to explain clearly in simple yet powerful way
@andrewsouthpaw2 жыл бұрын
The comparison of the different mental models and usage was brilliant. A perfect, simple look at the fundamental difference.
@BeABetterDev2 жыл бұрын
Thanks so much Andrew and glad you enjoyed!
@julianjacobs8956 Жыл бұрын
didn't expect to stick around for the Dynamo part but it was a great video :)
@BeABetterDev Жыл бұрын
Thank you!
@karimkhan99412 жыл бұрын
Daniel, you're a legend! Your video paved the way for us to make a decision on which data store to go for given our use case. Please keep up the good work and continue to post world-class quality videos like this one!
@BeABetterDev2 жыл бұрын
Thanks so much for the kind words Karim!
@nagu10802 жыл бұрын
Deserves million views. Very intuitive and practical reasoning. Thanks!
@BeABetterDev2 жыл бұрын
Thanks Nagu!
@timmyzheng60492 жыл бұрын
Thank you for uploading this video, the session is well organized and clean.
@abdulazeez.982 жыл бұрын
Excellent explanation. I finally understood the idea of DynamoDB. Thank you very much
@davidlean86742 жыл бұрын
Is anyone else having flashbacks to the early '80's. Exactly the same design points were discussed when choosing between the Network/Heirachical DB's people knew & this new-fangled Relational Technology. ie: IMS/CODASYL vs Ingres/System R/DB2/Oracle. It seems we've come full circle. New names but similar technical tradeoffs.
@BeABetterDev2 жыл бұрын
Hi David, I was actually born in the 80s! Guess I haven't been around enough to see the first iteration. You've given me a lot to read about. Cheers. Daniel
@bigstones84 Жыл бұрын
@@BeABetterDev I've read about this in a wonderful book called "Designing Data Intensive Applications" by Martin Kleppmann. Indeed he reports that the first databases where hierarchical, and RDB's were introduced also to solve the problem of duplication of data in the hierarchies. Honestly, it's probably the most beautiful technical book I've read.
@alibarznji20002 жыл бұрын
This channel is underrated
@ridaali9499 Жыл бұрын
I only get cloud concepts when you explain them! Thank you so much!!
@aminatashi3 жыл бұрын
Really liked the way you presented it! Awesome!
@BeABetterDev3 жыл бұрын
Thanks Amin! Glad you enjoyed :)
@srb18552 жыл бұрын
This was an exceptional video. The explanation using the four quadrants was particularly useful - especially for creating a mind map.
@manishmaharjann Жыл бұрын
Just a appreciation for making these sort of video. Thank you.
@sakarsr3 жыл бұрын
Thank you for this video. It really helped us a lot in deciding Aurora and DDB. Make a Cost analysis on this both.
@BeABetterDev2 жыл бұрын
Glad I could help Sakar!
@arkajitmondal73203 жыл бұрын
You should have considered cost in your explanation as well which is a pretty important factor in deciding the type of database to choose depending upon the size of storage and also the number of read/writes. I have seen many forums where many said even though dynamodb may look very cheap initially and one might feel like it's the ultimate solution for all your database problems, reads/writes can get expensive when storage increases as it requires multiple indexes and quering through large documents resulting in larger RRU/WRU or RCU/WCU.
@ralfrolfen5504 Жыл бұрын
33:01 I'd really like to hear you though/experience on the following model change of the table below: Columns: CustomerId, OrderId, OrderDetails ( shipping name, shipping address, ...) If you really need customer details, you can get them through the CustomerId in the "CustomerDetails" table. If I understand your explanation correctly, DynamoDB (or more general /Key-value databases/) are very good for record data, you would have written down on paper and archive, in former times (so stuff, that doesn't change in bulk, like "customer details"). And again, thank you very much for all the effort you put in all your videoS! They are helping a great deal!
@alturusatish3 жыл бұрын
Very well explained. Great content.
@BeABetterDev3 жыл бұрын
Glad it helped!
@galeop2 жыл бұрын
The actual comparison starts at 26:36 But great explanations :-) I have a few questions: 1) Will I get significantly improved performances even if I choose DynamoDB for Transactions ? 2) By "access pattern", do you also mean for writing data, or only reading data ? 3) DynamoDB seems to complicate things quite a lot, as one almost never knows how access patterns will change, and this de-normalization introduces complexity. But I would argue that for micro-services, it is still a good fit, as they have a narrow and clearly defined scope, and you rarely add new entities to your microservice's data model.
@BeABetterDev2 жыл бұрын
Hi Galeop, Good questions. For #1 - Its really hard to say. It would depend on the structure of your data and how many records need to get updated to perform the transaction. There's a great performance analysis article on Dynamo transactions here: www.alexdebrie.com/posts/dynamodb-transactions-performance/ For #2 - Access pattern typically refers to reading your data. For #3 - Dynamo does make things a bit more complicated when compared to traditional NoSQL or SQL databases. There are some tools such as GSI's that help you adapt to new patterns, but it can be cumbersome if faced with a brand new access pattern that just wont 'work' with your Dynamo table. I do agree though they are well suited for microservices with well defined models and responsibilities. For that, dynamo is a great choice. Hope this helps
@galeop2 жыл бұрын
Thank you very much for your answers
@celiagaylard4893 жыл бұрын
Practically understandable, thank you.
@BeABetterDev2 жыл бұрын
You're very welcome Celia!
@jazzsha3 жыл бұрын
Very well explained. Thank you!!
@BeABetterDev3 жыл бұрын
You're very welcome Jazir!
@SwapanD2 жыл бұрын
Brilliant. Superb. Hats off.
@BeABetterDev2 жыл бұрын
Thanks so much!
@Nashte.kibaat2 жыл бұрын
very nice video sorted and elaborate explanation .one stop for RDS vs Dynamo DB Thanks so much for sharing this .
@adamkinsey31392 жыл бұрын
You repeatedly state that "DynamoDB has better performance" (such as at 31:20), and suggest that NoSQL databases are faster than relational ones. I SINCERELY believe that you need to question this assumption. If the use case is for a glorified hash table, then that *might* be true, but RDBMSs are pretty fast at primary-key lookups, too. You also say that you don't have much experience with high-demand implementations of RBDMS systems, so I am surprised that you so confidently state that DynamoDB is *just better*. I would be happier to see your assertions backed by some kind of data. And thank you VERY MUCH for taking the time to make this video.
@hasnainahmadtanim1190 Жыл бұрын
Wow! brief explanation. Thanks a lot.
@assafcohen103 жыл бұрын
super clear and super professional! thank you!
@BeABetterDev3 жыл бұрын
You're very welcome Assaf!
@sanjeevkumaryadav91542 жыл бұрын
Thanks for explaining in detail the use cases, it helped me to decode for my own project, however, i feel if you can also talk about transaction support for both DB, it will be much helpful.
@ChanceMinus Жыл бұрын
Illuminating. Thank you.
@Minecraftzocker7662 жыл бұрын
Great video! Thank you!
@BeABetterDev2 жыл бұрын
You bet!
@PaulEllisBIGDATA2 жыл бұрын
Thank you!!! Appreciate your time and effort.
@BeABetterDev2 жыл бұрын
You're very welcome Paul!
@alekshernandez2 Жыл бұрын
Excellent video! Congrats
@stillmattwest2 жыл бұрын
Great overview, thanks!
@asfahanansari4669 Жыл бұрын
Excellent explanation
@nadaralpenidze95493 жыл бұрын
Great video. Thanks
@BeABetterDev3 жыл бұрын
Thanks Nadar
@XLpacman8058 ай бұрын
Great video
@imyashkale2 жыл бұрын
Your channel is awesome.
@toshyamg2 жыл бұрын
Great video 👍... Great content
@BeABetterDev2 жыл бұрын
You're very welcome
@ZAXSMAXBY3 жыл бұрын
Thank you so much!!!
@BeABetterDev2 жыл бұрын
Thanks so much Zach!
@naweedsyed15562 жыл бұрын
Amazing video
@BeABetterDev2 жыл бұрын
Thank you Naweed!
@shikhardev12 жыл бұрын
Really amazing video! Just a question when you are modelling the DynamoDB table at around @30:00, would it then make sense to split the information into 2 separate tables? A table with CustomerId as the partition key and OrderId as the sort key to answer the question "I want to be able to access all OrderIDs for a customer by their CustomerId", and another table with CustomerId as a partition key and one of other details as a sort key to find / update customer details?
@trekmotion Жыл бұрын
I would've been lot smarter if I found your videos years ago, I wasted hundreds of watch hours watching indian tech gurus reading slide shows. lol Thank you
@RafaganAbreu3 жыл бұрын
Very nice video
@BeABetterDev3 жыл бұрын
Thanks Rafagan! Glad you enjoyed
@kiranmaheshreddy74173 жыл бұрын
we can also change the access pattern of the dynamodb by creating new GSI, whenever we want it . is is right?
@BeABetterDev3 жыл бұрын
Hi Kiranmahesh, Yes this is true, but be aware that GSIs do cost extra which may affect your decision to use them. Daniel
@maazm47223 жыл бұрын
Hi , are u going to make a vid on aurora 2 ?
@pauldittus Жыл бұрын
Super helpful video. Question: Which DB would you recommend for WordPress?
@troyfrericks19042 жыл бұрын
At 06:00 you mention: Aurora Serverless... and at 08:00 you mention: DynamoDB is a pay-for-what-you-use model.... It's worth mentioning that Aurora Serverless is also a pay-for-what-you-use model.
@BeABetterDev2 жыл бұрын
Good point Troy. At the time only Aurora Serverless V1 which isn't what I could to be production capable. But as of now, I agree its viable and noteworthy. Cheers
@tn97532 жыл бұрын
Thank you Daniel for the content and insight. Would you use DynamoDB for Cognito (User ID & Auth)?
@BeABetterDev2 жыл бұрын
Hey TN, I would definitely consider DynamoDB for my backend and cognito for my authn/authz layer. In fact, this exact pattern is part of an application I am currently building right now at work! Daniel
@stiffyBlicky2 жыл бұрын
Great video, can you clarify the point around 36:34, "when you know in advance its good. idea to use dynamo and when you're convinced that its not going to change, def a good idea to use dynamodb, because you're going to be able scale a lot further if you use something like aurora" did you mean to say aurora here? I think you meant o say "you're going to be able to scale a lot further if you user something like dynamodb"?
@BeABetterDev2 жыл бұрын
Hi Mark, thank you for catching this. Yes I did mean to reference Dynamo instead of Aurora. I wish youtube had a way of adding popups so I could fix this :(
@stiffyBlicky2 жыл бұрын
@@BeABetterDev No worries, a response like this is sufficient, just wanted to make sure I understand what you are saying and now I do 100%. Thanks again.
@shivamanand61122 жыл бұрын
Extracting from PRAW Jsons. Load raw jsons in dynamo then staged table in s3 then db in rds Or store raw Jsons and staged tabled both in s3? Heard staging = load + staged so should one decouple? Or overkill?
@akin2420022 жыл бұрын
If you haven't done a video on it yet, could you do a video on Mariah DB vs Aurora DB.
@surfbug19 ай бұрын
it's hard to hear you. on your next videos please increase your vocal your voice volume everything is great that ur presenting thank u!
@visvajeet56093 жыл бұрын
Amazing work. 👏 Which one is best suitable for social media app?
@BeABetterDev3 жыл бұрын
Hi Visva, This really depends - I think starting with Aurora is always a fine choice. You can always migrate afterwards if you scaling needs evolve. Hope this helps.
@damienspectre4231 Жыл бұрын
13:35 - thats not correct. Multi-AZ replication is SYNCHRONOUS!! Its why its are Failover Candidates and is virtually instantaneous replication (as opposed to read replicas which are Disaster Recovery candidates which as ASYNCHRONOUS and have a replica lag) This is from the official docs: "Aurora synchronously replicates the data across Availability Zones to six storage nodes associated with your cluster volume"
@BeABetterDev Жыл бұрын
Thank you for pointing this out!
@pacoluna7969 Жыл бұрын
Hi! You think is a good idea to store all information related to an APP/SAAS in DynamoDB? I'm building it and I'm thinking of host the API in lambda (using your tutorials), I already know how to use pretty well postgres databases, but I'm new to DynamoDB, as is just an APP concept and not a business, I'm thinking ofDynamo due to the free tier, but I don't know if it will serve my purpouse. I'm talking about data like user info, posts from users, etc. I have the model well defined with a relational database, but with Dynamo I'm having troubles.
@tom_zanna3 жыл бұрын
Is Aurora a fork of open source DBMSs deeply integrated in the AWS ecosystem or a fully proprietary DBMS?
@miluna942 жыл бұрын
Is it possible to use something like a unique field in dynamodb?? Does that field need to be a PK/SK/GSI??
@ralfrolfen5504 Жыл бұрын
What tool do you use for the presentation?
@mraburles Жыл бұрын
How does DynamoDB compare to Amazon Neptune?
@BeABetterDev Жыл бұрын
Hi adria, DynamoDB is great for key-value storage. Neptune is more for graph type use cases such as a social network or a road network. Hope this clarifies.
@swanandrajure3 жыл бұрын
What if the MasterDB for Aurora fails? How does it restores
@BeABetterDev3 жыл бұрын
Great question Swanand. Aurora will fail over to a Read Replica and promote it to master.
@pikachu52232 жыл бұрын
@@BeABetterDev what?
@vishalkothari80653 жыл бұрын
So aurora is better for serverless lambda over RDS?
@BeABetterDev3 жыл бұрын
Hi Vishal, Currently, Aurora is the only option that has 'serverless' mode. Not sure if this will change in the future but that is current state. Hope this helps, Daniel
@vishalkothari80653 жыл бұрын
@@BeABetterDevOkay , btw it was a nice video
@SaiKiran-kd6cq3 жыл бұрын
Can you please create a whole tutorial on creating a serverless app using python
@BeABetterDev3 жыл бұрын
Hi there, have you seen the two below videos I made? They may be helpful for you: kzbin.info/www/bejne/jV7Xq6J9jrKZiqM kzbin.info/www/bejne/hH6Xh5dtm9WNjc0
@SaiKiran-kd6cq3 жыл бұрын
@@BeABetterDev Yes ..I have not missed any videos of yours till now 😊 Your videos are crisp and to the point .My point was if you can please make a whole tutorial on serverless app python Django starting from Dyanmo dB to Cognito ..
@BeABetterDev3 жыл бұрын
Ah thank you for clarifying Sai! I'll put this on my todo list for my practical project series. Thank you for the suggestion!