AWS DynamoDB Schema Design | How to choose the right key

Поделиться
HTML-код
  • Опубликовано: 22 дек 2024

Комментарии • 204

  • @dbejjam
    @dbejjam 4 года назад +23

    Am a veteran RDBMS guy and new to NoSQL. I got to say, the way your describe NoSQL stuff is just phenomenal.

    • @BeABetterDev
      @BeABetterDev  4 года назад +2

      Thank you so much for the kind words!

  • @venkatesh6384
    @venkatesh6384 5 лет назад +69

    This is one of the most useful video I found on dynamodb keys. You made me your subscriber

    • @BeABetterDev
      @BeABetterDev  5 лет назад +7

      Thank you for the kind words. Its comments like these that motivate me to keep making more videos. Thanks again and take care.

  • @leetsai6220
    @leetsai6220 3 года назад +16

    Great job explaining the topic and exploring the limitations. The way you explain a complicated subject with simplicity without sacrificing knowledge is sheer elegance. Keep it up.

    • @BeABetterDev
      @BeABetterDev  3 года назад +2

      Thanks so much Lee! Your comments means a lot to me :)

    • @tyronefrielinghaus3467
      @tyronefrielinghaus3467 3 года назад +2

      Yes BABDev: simplitivity without sacrificing knowledge...spot on! I like the way you explain everything. When I'm learning from a tutorial I HATE having to spend half the time googling what was mentionef but not explained....thanks for NOTsoing this...it really helps.
      Ps...great voice too...clear&well modulated. Just easy to listen to.

  • @suhasbadhe
    @suhasbadhe 3 года назад +6

    This is by far the best video I found for DynamoDB Keys!

  • @fahimuel
    @fahimuel 4 года назад +4

    Best Dynamo DB Schema Tutorials with precision knowledge providing all the use cases. Many Thanks.

    • @BeABetterDev
      @BeABetterDev  4 года назад

      Thank you so much for your kind words!

  • @Xhez2slash
    @Xhez2slash 3 года назад +1

    Splitting up the RCU to depict the partition capacity is by far the best way I seen hot partition be explained.

    • @BeABetterDev
      @BeABetterDev  3 года назад

      Thank you!

    • @Xhez2slash
      @Xhez2slash 3 года назад

      @@BeABetterDev Thanks to you I got my Dev Associate!!!

  • @haris1558ssss
    @haris1558ssss 4 года назад +3

    You're such a gifted teacher. It's not easy to grasp all this information from the documentation. Thanks for the amazing video.

    • @BeABetterDev
      @BeABetterDev  4 года назад +4

      Thank you so much for your kind words. I actually kind of enjoy reading documentation and I'm glad I can translate that into easy to understand examples for all of my viewers.
      Thanks again!

  • @osamaa.h.altameemi5592
    @osamaa.h.altameemi5592 4 года назад

    Man you really simplified it. The original documentation will take you in circles all over the place. Fantastic video.

    • @BeABetterDev
      @BeABetterDev  4 года назад

      Thank you so much! I'm glad you enjoyed the video and helped you understand the concepts.
      Daniel

  • @andrestone
    @andrestone 4 года назад +18

    The whole hot partition concern and the WCU / RCU hard limits are pretty much a thing of the past. DynamoDB will automatically reshard your partitions behind the scenes down to a single item if the disproportional velocity access is there. It means you'll only reach hard limit throttling if you have a single item being responsible for more than 1000 WCU / 3000 RCU.

  • @srb1855
    @srb1855 2 года назад

    This was excellent - wish I had watched it 6 months ago! I was actually searching for "cardinality" and your vid came up among the first results.... Thanx again.👍

  • @ChauDuong1982
    @ChauDuong1982 3 года назад

    Best DynamoDb explained ever.

  • @sumaiyaahmed4948
    @sumaiyaahmed4948 4 года назад +1

    Thanks for explaining in a simplified way. Very useful

  • @MrMazharsamo
    @MrMazharsamo 4 года назад +1

    Simple and to the point explanation...Keep up the good work

  • @vijaygokarn
    @vijaygokarn 4 года назад +3

    you deserve more subscribers .. keep up good work

  • @marcoavendano6593
    @marcoavendano6593 5 лет назад +1

    I agree with all the comments here. Nice work describing this in simple terms.

  • @haciendadad
    @haciendadad 4 года назад +1

    Excellent video. Good speaker and provides content very well! Easy to learn from!!

  • @AIAnimationStudio
    @AIAnimationStudio 7 месяцев назад

    4 years alter... this run through is still very helpful. 👍

  • @mangeshxjoshi
    @mangeshxjoshi 5 лет назад +1

    Excellent video on DynamoDb partition key concepts , it would really help. If you could provide any video on DAX whenit can be used and its pros and cons

    • @BeABetterDev
      @BeABetterDev  5 лет назад

      Thank you for the kind words. A video on DAX is coming soon!

  • @akashseth7452
    @akashseth7452 4 года назад +2

    You just won a subscriber. High-quality stuff (y)

  • @shivamvats6146
    @shivamvats6146 3 года назад +2

    7:03 Why partion 3 row is in Partition 1 ? Shouldn't it be under a new partition 3 ?
    Please help, this is my only doubt left .

    • @oldoctopus393
      @oldoctopus393 3 года назад +1

      Double this question

    • @BeABetterDev
      @BeABetterDev  3 года назад +1

      The location the partition lands on is independent on the data. Rows that have differnt partition keys can land on the same partition.

  • @aliciacollymore220
    @aliciacollymore220 5 лет назад +4

    This was super useful, would be awesome if you could do a video on GSI and how that works, can't seem to wrap my head around it fully

    • @BeABetterDev
      @BeABetterDev  5 лет назад +2

      Thanks Alicia. You''re feedback means a lot. I have one coming out this weekend on DynamoDB Autoscaling, but definitely plan on doing one on GSIs in the next month or so. Thanks again!

    • @BeABetterDev
      @BeABetterDev  5 лет назад +7

      Hey alicia, check out this new video I just posted on GSIs! ruclips.net/video/ihMOlb8EZKE/видео.html

  • @sorover111
    @sorover111 3 года назад +1

    These are really good mane, keep it up 👍🏻

  • @ramamoorthyvasanth
    @ramamoorthyvasanth 5 лет назад +3

    This is super useful, please create a video on local secondary index as well

    • @BeABetterDev
      @BeABetterDev  5 лет назад +1

      Thanks Rama! I'll add LSIs to my backlog of ideas. Cheers.

    • @BeABetterDev
      @BeABetterDev  5 лет назад +1

      Hi Rama, in response to your feedback, I just created a video on Local Secondary Indexes - check it out here: ruclips.net/video/Y8gMoZOMYyg/видео.html

  • @wajay2006
    @wajay2006 3 года назад +1

    Excellent video !! Do you have any video on data modelling a relational database in DynamoDB

    • @BeABetterDev
      @BeABetterDev  3 года назад +1

      Hi Ajay, not yet but thanks for the great tip!

  • @atjams
    @atjams Год назад

    Fantastic video! Easy to learn. Thank you 🙏

  • @sankalpsipaulya584
    @sankalpsipaulya584 4 месяца назад

    At timestamp 2:29 , shouldn't there be three partition created.Or I am getting it wrong here

  • @gustavoangelochannel
    @gustavoangelochannel 3 года назад +1

    Awesome video, keep the good work!

    • @BeABetterDev
      @BeABetterDev  3 года назад

      Thanks Gustavo! Really appreciate the kind words.

  • @syedzainrehan
    @syedzainrehan 3 года назад +1

    Very well explained. Thank you!

  • @IanHuang-ch1cn
    @IanHuang-ch1cn 4 года назад +1

    Sorry, I would like to ask a question. At 6:18, you said that item with the partition key 3 will be stored in the same partition as item with partition key 1. But aren't they having different hash value after you put their partition key into the hash function? So why did they end up in the same partition?

    • @BeABetterDev
      @BeABetterDev  4 года назад

      Hi 黃翌軒,
      Depending on the size of your table, DynamoDB may store values with a different partition key on the same physical partition. As your data size or throughput demands grow, DynamoDB can re-split these partitions into smaller ones.
      Hope this helps.

  • @codebreakthrough
    @codebreakthrough 3 года назад

    Great stuff! Very helpful, thanks.

  • @siddheshlatkar9839
    @siddheshlatkar9839 4 года назад +1

    Very nicely explained.

  • @kshitijvats5261
    @kshitijvats5261 6 месяцев назад

    So does querying with parition and sort key will take logn time? Partition key will determine with hashing function the correct partition and then in that partition we will use sort key(log n time, where n is rows with same partition key value) to get to the reuqired row?

  • @ashguru
    @ashguru 3 года назад +1

    very well explained.. all stuff no fluff.

  • @XinWongDigital
    @XinWongDigital 4 года назад +1

    Thank u for sharing. Wud b cool if u mention filtering in the video

  • @XxGabberlordxX
    @XxGabberlordxX 4 года назад +1

    Hey! Your videos are very helpful and I learn a lot of things!
    For me and maybe another people it might be interesting to see an end to end project. You don't have to implement it but something like a general concept would be awesome.
    For example something like: Deploy a website and a REST service via AWS. Which services should we use and how to secure the backend and how to connect the REST API to a DB. Things like this would be absolutely awesome :)
    I'll definitely follow you and watch the other tutorials.
    Cheers mate :)

    • @BeABetterDev
      @BeABetterDev  4 года назад

      Thanks Neal! An End to End video has been on my radar for a while. Thanks for the suggestion!

    • @XxGabberlordxX
      @XxGabberlordxX 4 года назад

      @@BeABetterDev An additional suggestion that might be easier and also makes a lot in for example the whole aws rds context is a tutorial about bastions/jump boxes. I. e. host an RDS Aurora db in a private vpc and then you create a jumbox to connect to this db via SSH.
      Have a great day :)

  • @kyriacoslouca2799
    @kyriacoslouca2799 4 года назад +1

    Very nicely explained indeed. I have seen some examples where the Partition Key is an UUID value. However, in some cases, I need my primary key to be an auto-increment integer like the one many SQL databases provide. What is your suggestion?

    • @BeABetterDev
      @BeABetterDev  4 года назад

      Hi Kyriacos,
      Unfortunately auto-increment isnt supported in DynamoDB. Generally speaking, in a NoSQL database it is advised to use a meaningful primary key so you can quickly retrieve your data by said key. Your access pattern should define what your primary key should be (even a composite key could be used).
      Your requirements make me think a traditional relational database could be better suited for your use case.

  • @PulsePTYork
    @PulsePTYork 4 года назад +1

    How do you not have more subs? your channel is great!
    Keep it up mate!

  • @rohitkochar9022
    @rohitkochar9022 2 года назад +1

    also, with partiQL you can query table with a value without cretaing a GSI on that column. is that a new feature?

    • @BeABetterDev
      @BeABetterDev  2 года назад

      Hi Rohit, the thing you need to be careful about using PartiQL is that performing queries are non-indexed columns can result in a scan operation instead of a query. This can cause high costs and poor performance for these types of operations. Hope this helps clarify.

  • @HamzaAli-hv4md
    @HamzaAli-hv4md 3 года назад +1

    Great video. Thank you so much!

    • @BeABetterDev
      @BeABetterDev  3 года назад

      Thank Hamza, super glad it was helpful!

  • @niteshgupta8436
    @niteshgupta8436 2 года назад

    Great video. Just one doubt. How to design my table if i have more than 2 fields for uniqueness (let's say 3 fields defining uniqueness. For example, in vehicle, make+model+year is unique)

  • @vimalneha
    @vimalneha 3 года назад

    Very well explained!

  • @hetalraval3928
    @hetalraval3928 2 года назад

    In my case i want to scan all data each time to compare with my response to know where update occur or insert and according to that i want to perform other requests...so what could be the best possible way?

  • @blue_moon1_1
    @blue_moon1_1 2 года назад

    Impressed.... Very informative

  • @rohitkochar9022
    @rohitkochar9022 2 года назад +1

    How did you define a date as sort key? I do not see type date. Do you define date as string?

    • @BeABetterDev
      @BeABetterDev  2 года назад +1

      Hi Rohit date is just a string in this

  • @Tellalca
    @Tellalca 4 года назад

    6:20 How does the item with Account Id = 3 goes into Partition 1? Shouldn't it go to Partition 3 since the Account Id attribute is defined as partition key?

    • @rockylovesall
      @rockylovesall 4 года назад

      IN my understanding, When the hash function is applied on the account Id it generated the target as partition 1. E.g. id % 2 ==0 will go in partition 2 and rest in 1.
      Hope it helps

  • @alulaleak
    @alulaleak 2 года назад

    Is there a reason to use DAX over CloudFront??

  • @MiralkumarPatel
    @MiralkumarPatel 3 года назад +1

    Speaking of other strategies: How do you create composite primary key with 3+ columns?

    • @BeABetterDev
      @BeABetterDev  3 года назад

      Hi Miral,
      I think it would be as simple as just appending each value using a delimiter such as value1-value2-value3. Keep in mind though this pattern requires you to know all these values before querying in order to find your records in Dynamo.
      Hope this helps,
      Daniel

    • @MiralkumarPatel
      @MiralkumarPatel 3 года назад

      @@BeABetterDev Thank for reply. That's the catch, the third column value is a timestamp and for that reason, can't perform BatchGetItem.

  • @ashleyalex2713
    @ashleyalex2713 2 года назад

    Suppose if we design sort key as countrycode#date, how we will be able to sort date only as we have country code along with it

  • @lardosian
    @lardosian 4 года назад

    So in an amplify project for example, this schema is defined in the graphql schema yes? Do you have any such videos. I found a very good post on Dev.to from Nader Dabit about creating a robust graphql schema with directives, thanks!

  • @georgesoniarachel
    @georgesoniarachel 4 года назад +2

    Awesome tutorial !!

  • @NiclasGleesborg
    @NiclasGleesborg 3 года назад

    How can a row with partition key "3" end up on Partition 1? 3:25

    • @BeABetterDev
      @BeABetterDev  3 года назад

      Hi Niclas. Partition assignment is completely random. Hope this clarifies.

  • @EdwardLegaspi
    @EdwardLegaspi 3 года назад

    Hi. When designing a DB schema in DynamoDB how do you store the traditional lookup values like countries? In it's own table country with countryCode, countryName attributes? What's the best practice here? Thanks.

  • @griscz
    @griscz 4 года назад +1

    Very helpful thank you!

  • @ishaanme91
    @ishaanme91 3 года назад

    great explanation!

  • @vijayaprasadramachandran7603
    @vijayaprasadramachandran7603 5 лет назад +1

    Awesome .. Simply put

  • @geoa9722
    @geoa9722 4 года назад

    how to use update method with combination of partition key and sort key?

  • @cjj1120
    @cjj1120 2 года назад

    Is GSI a new feature since it’s not mentioned in this informative video

  • @yogithakakarla1716
    @yogithakakarla1716 3 года назад +1

    Most useful video

  • @pedrouriarterodriguez899
    @pedrouriarterodriguez899 4 года назад +2

    Excellent video and information, keep doing such quality content

  • @mohammedabdullah9537
    @mohammedabdullah9537 3 года назад

    Hey! how to find my table's details or description on AWS DynamoDB?

    • @BeABetterDev
      @BeABetterDev  3 года назад

      Hi Mohammed, this should be in the Overview tab on the console after clicking the table name.

  • @xiangyuncui373
    @xiangyuncui373 4 года назад

    Very clear, easy to understand, thank you!

  • @anup00717
    @anup00717 4 года назад +1

    Very useful.. thanks for the video, AWS docs are jargon :P

  • @georgemap
    @georgemap 2 года назад +1

    Great Video, thank you for all the information! I have a question about filtering - which solution would you approach if you wanted to filter with multiple conditions? Equivalent to: WHERE country=„…“ & age=„…“ & … and so on (note: country and age are not pk or sk and without using filterExpressions)
    Or is there not a nice solution with dynamodb to that and aurora would be a better choice?
    Thank you in advance

  • @sagarsinghrajpoot6788
    @sagarsinghrajpoot6788 4 года назад +1

    Very Nice Explanation :)

  • @fitnecessity7386
    @fitnecessity7386 4 года назад +1

    Nicely explained! Subscribed :)

  • @bhageerathbabuprathi1043
    @bhageerathbabuprathi1043 4 года назад

    Excellent video . It really helps. Thanks a lot.

  • @64kuroina
    @64kuroina 3 года назад +1

    how many items can I set in the same partition key?

    • @BeABetterDev
      @BeABetterDev  3 года назад +1

      Hi ruru,
      There is no limit. However keep in mind that there is a 10gb max partition size in dynamo. I believe the partition splits afterwards. If you have too much throughput on the same partition key you make get throttling errors.

    • @64kuroina
      @64kuroina 3 года назад

      @@BeABetterDev thanks for answering me, the video was very helpful😁👍

  • @rayprusia4753
    @rayprusia4753 3 года назад +1

    Great video Thanks

  • @mdhruv1
    @mdhruv1 4 года назад

    Please can we get a tutorial. Where I can use curl to create an presigned url for s3 bucket object to load an file and download a file .

  • @jeffryjohn2508
    @jeffryjohn2508 3 года назад

    Thank you for this tutorial 🙏🙏🙏

  • @surbhisingi5214
    @surbhisingi5214 4 года назад

    Is it possible for you to create a video on how to create DynamoDB table - having LSI and GSIs through Cloudformation script and add items in it using put_item from boto3 python SDK?

  • @gauravshetty1436
    @gauravshetty1436 4 года назад

    what if partition key itself is unique an there are 1 million records example email id as partition key in user table?will there be a problem with too many partitions?

    • @BeABetterDev
      @BeABetterDev  4 года назад

      Hi Gaurav,
      Dynamo would split your data across multiple partitions in that case. There is no limit that I am aware of regarding number of partitions.

  • @kunalvids
    @kunalvids 3 года назад

    Thanks for wonderful video

  • @rhushikeshlokhande9108
    @rhushikeshlokhande9108 4 года назад

    Very Knowledgeable video Clare my table schema confusion. Please do share the Github link for code reference for serverless application if you have any..

    • @BeABetterDev
      @BeABetterDev  4 года назад

      Thank you Rhushikesh! I will post github links soon. :)

  • @_cipriangg_
    @_cipriangg_ Год назад

    Thank you for the info!

  • @calvinedwards6338
    @calvinedwards6338 4 года назад +1

    wow only 1.93K subs.. what a crime. Subbed!

    • @BeABetterDev
      @BeABetterDev  4 года назад

      Thank you so much Calvin for your kind words!

  • @rakeshmishra8208
    @rakeshmishra8208 4 года назад +1

    Thanks, it's a great video :)

  • @sameerahmadbalaganur8958
    @sameerahmadbalaganur8958 3 года назад +1

    Really good

  • @andresm9051
    @andresm9051 4 года назад

    Great video, I got a question through an example If I had a sign up method in app and I can do it by email or phone number I was thinking about primary key because of cognito Id user, and that user sell products using many categories can have those products and categories under same table and row and query it by it's I'd, it's a good practice ? thanks

  • @emmanueladetutu8739
    @emmanueladetutu8739 4 года назад

    Awesome!! Thanks for this. It was very helpfull.

  • @jeffinj7707
    @jeffinj7707 3 года назад

    Great content

  • @akshaykalambe9054
    @akshaykalambe9054 5 лет назад +1

    Very nicely explained. Keep it up :)

  • @ThiruMurugan-d6r
    @ThiruMurugan-d6r Год назад

    how to pagination using dynamoose

  • @jean-louisgouwy
    @jean-louisgouwy 3 года назад

    Most of the time, we depend of business rules.
    I mean, recently, we create a table with just an uuid (for each object). Then later, The business would like to retrieve thoses objects but without knowing the uuid, they need to retrieve the object by the name And lastModificationDate (between two dates).
    How do you manage that ? You have to create some gsi...
    But we do not have always all the information when we start the archtecture. This is very complicated when your project evolves with anothers features that you do not anticipate.
    This is my pain using dynamodb over mysql before.

    • @JamesSmith-cm7sg
      @JamesSmith-cm7sg 3 года назад

      The use case for Dynamodb is driven by high performance, so ultimately the business needs to understand the complexity of new queries. You can also utilise something like dynamo streams to update something like elastic search or ETL the data into a relational DB for complex queries.

  • @rishabhkohli7170
    @rishabhkohli7170 5 лет назад +1

    Thanks amazing video

  • @lardosian
    @lardosian 4 года назад +1

    Thank you, just subbed. I'm about to get my hands dirty with AWS for the first time, use case is building an API and a PWA with React, was thinking of using the serverless framework, some advise to steer me in right direction would be greatly appreciated, I'm also doing my own research so it looks like I will need the combination of the following..API Gateway, Lamda functions, Dynamo DB, Cognito for backend, S3 for hosting, serverless for my framework, I'm sure theres more, thank you!

    • @BeABetterDev
      @BeABetterDev  4 года назад

      Hi Lardosian! Welcome to the channel.
      Great to hear you're getting familiar with AWS.
      In terms of your use cases, It sounds like you've identified the right AWS technologies for your use cases. Here are some additional videos I think could be helpful.
      IAM - IAM permissions are the bread and butter of AWS. You should get very familiar with them - ruclips.net/video/y8cbKJAo3B4/видео.html
      Lambda Introduction - ruclips.net/video/iUIWG0h2D84/видео.html
      Building a REST API with API Gateway + Lambda - ruclips.net/video/uFsaiEhr1zs/видео.html
      Basic DynamoDB Operations - ruclips.net/p/PL9nWRykSBSFgmcJMpr7XAk3BC0VPAK_i-
      Hope this helps!

    • @lardosian
      @lardosian 4 года назад

      @@BeABetterDev Thank you very much, apologies for the late reply.

  • @deladonics
    @deladonics 4 года назад

    I must be missing something fundamental about Dynamo because I keep looking up how to retrieve all items in my table in a sorted order, but I keep ending up on articles and videos like this where they talk about read capacity and partitioning. I want SELECT * FROM table ORDER BY time ASC. I get the feeling I could give everything the same partition key and unique sort key and have them come back ordered but that has to be the wrong way to achieve my goal.

    • @NoSQLKnowHow
      @NoSQLKnowHow 4 года назад

      I am not sure of your exact use case and why you need to do a Select * FROM table, but I am pure guessing from the way you state your comment that more than likely you are trying to apply a relational DB mindset onto a NoSQL database, in this case DynamoDB. If you want to expand your comment, I am happy to try and help you though.

    • @deladonics
      @deladonics 4 года назад

      @@NoSQLKnowHow I have been messing around with Dynamo to build a serverless version of my blog. The traffic I get would be well under the free tier limit for both Lambda and Dynamo, so I could have a blog hosted for cheap. As an example of what I'm trying to do, I would call Dynamo to retrieve my blog posts and have them return in order of the sort key which is a timestamp. So far, I can only call scan and sort them after they return but eventually I'll want to do pagination and only return ten of the most recent posts.

    • @BeABetterDev
      @BeABetterDev  4 года назад +3

      Hey Stephen!
      Based on your description, it sounds like you're trying to use Dynamo as if it were a traditional Relational Database. NoSql databases like Dynamo excel at quick retrieval for known values where you know the key (either singular or composite) that you are looking for. It can be extended to query for a key + a second attribute (sort key), but its functionality is pretty limited.
      Concerning your specific problem, you can solve this by having a table setup where your partition key is something like blog id (singular value) and your range/sort key is creation date. The combination of these values should be unique (as you can never create two blog posts at the same time). Using this approach, you can perform a paginated query in descending order on the sort key to get top X results (set your LIMIT to be X on your query). This isn't an ideal setup but should solve your problem.
      Hope this helps!

  • @jivanmainali1742
    @jivanmainali1742 3 года назад

    How many partition Key could dynamodb could have??

    • @BeABetterDev
      @BeABetterDev  3 года назад

      Hi Jivan, technically it is infinite.

  • @criticalflow8733
    @criticalflow8733 4 года назад

    Nice one !! i just subscribed

  • @abhaygodbole9194
    @abhaygodbole9194 4 года назад

    Thanks for this very insightful session. Just would like to know where I can ask questions. I have one doubt about PutItem, which is not related to this video.

    • @BeABetterDev
      @BeABetterDev  4 года назад

      Thanks Abhay! feel free to ask here

    • @abhaygodbole9194
      @abhaygodbole9194 4 года назад

      I have asked it in your other video related to inserting items in DynamoDB.. Thanks

  • @crimsonderrick
    @crimsonderrick 4 года назад +1

    Thank you

  • @usamasaleem5624
    @usamasaleem5624 2 года назад

    Can you please share the slides

  • @Fernando1989mg
    @Fernando1989mg 4 года назад

    nice video, thanks u!!!

  • @tejasdevgekar1154
    @tejasdevgekar1154 2 года назад

    thanks dude

  • @robertfrank2345
    @robertfrank2345 10 месяцев назад

    you rock!

  • @venkatk161
    @venkatk161 4 года назад +1

    Thank you. Well explained. Another subscriber here :-)

    • @BeABetterDev
      @BeABetterDev  4 года назад

      Thank you so much Venkat! Welcome to the channel.

  • @SatejPrabhu
    @SatejPrabhu 4 года назад

    Good video.. after spending over a decade in SQL database.. its challenging to understand how SQL schema could be translated/redesigned to NOSQL. If you could make a video by taking example of AdventureWorks to show how you would design that use case in NOSQL, that would be great.

  • @shamstabrez2986
    @shamstabrez2986 2 года назад

    Is this tutorial valid for 2022

  • @elenapaglia
    @elenapaglia 5 лет назад +1

    New subscriber here too. I'm really surprised you don't have a lot more views and likes. Your videos are very helpful and easy to follow. I don't know if this is a topic for another video or related to this video... does this key approach require one entity type per table ? I've been reviewing AWS Docs and tutorials (specifically this one - aws.amazon.com/getting-started/projects/design-a-database-for-a-mobile-app-with-dynamodb/4/) where multiple entity types can sit in one table. I would like to implement this approach but it doesn't translate well when you look at the console. Do you have a video that can help me out ?

    • @BeABetterDev
      @BeABetterDev  5 лет назад +1

      Hi Saturday! Thank you for the kind words of support, it means a lot to me!
      Regarding your question. It is possible to store multiple different types of entities within the same table. For example, in your example you have USER, PHOTO, REACTION, FRIENDSHIP entities. You can potentially store this data in one table by taking the following approach:
      Set your primary key to be IDENTITYTYPE_HashKey. One of your columns could be a serialized object in JSON representation of the entity type. The one caveat here is that the serialized data in your JSON column would be unsearchable from the dynamo perspective (range key search, global secondary index search, etc). However, if you are looking to store flat data of different types in one table - this approach will certainly work.
      Hope this helps and let me know if you have further questions!

  • @mrroboto4319
    @mrroboto4319 4 года назад

    "And for the lazy people, there is DAX" that killed me 😆. Nice guide!