Thanks for sharing your DynamoDB schema design! It'd be great to see more of this (schema design for specific access patterns) Also, consider using some type of notation for static text in the PKs and SKs vs referenced variables ... maybe something like SK: payment###.
@CompleteCoding2 жыл бұрын
Yeh it's always hard to write it in an understandable way. I might add that schema idea
@openupthecloud2 жыл бұрын
Yessss, love a good lightboard sesh!
@CompleteCoding2 жыл бұрын
Thanks. Planning a lot more coming up!
@hussainbharmal59982 жыл бұрын
This was wonderful, thank you
@CompleteCoding2 жыл бұрын
Glad you enjoyed it!
@hussainbharmal59982 жыл бұрын
Serverless but which? Firebase, AWS, Azure? Mistery clears at: 3:24
@CompleteCoding2 жыл бұрын
With this channel it's always going to be AWS. It's what I've been working with for the last 5 years and is in my opinion the best serverless provider
@hussainbharmal59982 жыл бұрын
@@CompleteCoding yep, i got the video as a recommendation. Didn't know about the channel till today. Also just subscribed!
@RahulAhire2 жыл бұрын
Please correct me if I'm wrong, you're saying that we can have two indexes. 1 for normal table containing overdue and another gsi for order successful, right? So let's say if we get successful payment subscription then do by using stream do we need to delete overdue sk record in first index? Second question, TTL in DynamoDB isn't very reliable and often time will need filter expression to check it's validity so how do you see this issue?
@CompleteCoding2 жыл бұрын
Yes we can have two index. A global secondary index is just a way to query the same data in a different way. All records would have the same fields * user 1 pays their bill on time, you change the status (and the value in the SK.) to paid * user 2 doesn't pay on time, it triggers the dynamo TTL which triggers a Lambda. That sends an email and updates the status for that payment to "overdue" Both records exist in the same table and are queryable on both indexes. The difference between the indexes is index 1 you query "Get all payments for this order" index 2 you query "Get all payments in this state"