Working with DynamoDB Tables - Partition Key and Sort Key - Dynamo Deep Dive

Download Your Cheat Sheet Here www.subscribepage.com/dynamoc...
✅ WATCH THIS VIDEO NEXT TO 👇🏼
📖 Prefer to read this tutorial? 👇🏼
completecoding.io/dynamodb-pksk/
✅ WATCH THIS VIDEO NEXT TO LEARN THE 7 PROJECTS YOU NEED TO LEARN SERVERLESS 👇🏼
• Become a Serverless Wi...
👇🏼 HOW WE CAN HELP YOU 👇🏼
----------------------------------------------------
📖 OUR COURSE 📘
completecoding.mykajabi.com/7...
----------------------------------------------------
🚨 WORK WITH US 🚨
completecoding.io/consulting-...
----------------------------------------------------
💻 🎥 THE KIT & TOOLS I USE 💻 🎥
completecoding.io/recommended...
----------------------------------------------------
👋 SOCIAL MEDIA 👋
📹 INSTAGRAM - @completecoding
#️⃣ TWITTER - @SamCompleteCode

[@gonzalofernandez1]

The best dynamo explanation i have ever heard, thanks. And the cheat sheet is excellent.

[@CompleteCoding]

Thanks! Glad you liked the cheat sheet

[@deepeshkumarr5687]

Thanks for the video. Expecting LSI and GSI soon ❤️

[@CompleteCoding]

Yes, they're in the next few videos coming up!

[@Eldeirdro]

How would you get a list of all customers in the db if the single table has other entity types e.g. products, store

[@charlesandrews2273]

You deserve more subscribers. The best video on this topic I've come across!

[@CompleteCoding]

Wow, thank you! I'm slowly growing, I'm sure we'll be at 1,000,000 in no time :p

[@amrmonzir]

Thank you. Great work!

[@CompleteCoding]

Glad you liked it!

[@cloudagnostic]

Hi Sam, is there a way to auto increment the primary key when a new record is created?

[@CompleteCoding]

No there isn't. And there's a reason for that. Dynamo is designed to be massively distributed. There would be no way to be sure of the next key without querying every single distributed partition. A better option is to use unique identifiers for your primary keys. The best way to do that is with UUIDs. For you, is there a reason that the next record needs to have a key one larger than the previous, or is that idea just carried over from previous experience?

[@cloudagnostic]

@@CompleteCoding after reading the documentation I figured it out and went there isn’t an option. I’m used to using mongo and automatically having an id created

[@nastynashnash]

Question in the supermarket with state example. How would you do something like "get me all the supermarkets in a particular state?"

[@CompleteCoding]

for that you would have to structure your data a little bit differently ( or add another global secondary index) This would look like this id pk sk pk2 sk2 1334 wallmart washington#seattle#redmond#zipcode washington seattle#redmond#wallmart Now you can run a query on index2 where pk2 = washington. You could then refine that to query on index2 where pk2 = washington AND sk2 begins with seattle#redmond to get all the shops in redmond

[@diegomarzo4001]

Very good video, everything so well explained like always!!!!

[@CompleteCoding]

Thanks again! it means a lot

[@ogcontraband]

My first real problem to solve in dynamodb is essentially do an order by. I'm seeing people saying to use client side sorting. How can it be a 'db' with the most basic operation of sorting by a column can't be done

[@CompleteCoding]

It depends on what you want to sort. You can easily sort everything in a partition using the sort keys. Doing any action on a whole table is very inefficient in Dynamo as each partition is split on different physical machines

[@subowijeyesinghe3429]

Good one, thanks

[@CompleteCoding]

Glad you liked it!

[@shwenansuwai2481]

Thank you so much.

[@CompleteCoding]

Glad you liked it

[@akwashington1962]

Good information. In the future, consider adding visuals.

[@CompleteCoding]

Thanks, will do!

[@Mrstealurgrill]

Can you query by sort key only?

[@CompleteCoding]

No, you always need to pass a partition key. If you really need to do search on all data then you need to use a scan. This isn't very efficient though as it reads the whole table.

[@kaypakaipa8559]

Wow I was confused about these 2 keys when I read about it, but your explanation is 10/10, and the answers you gave in the comments were very helpful too. Thanks Man!

[@CompleteCoding]

Glad it helped!

[@shinj1323]

How can you get all of the items in the table?

[@CompleteCoding]

Only way is to do a scan. Ideally you'd never need to get all records from a database as it's going to be a large request.

[@xD-saleem]

Thanks for this

[@CompleteCoding]

My pleasure!

[@ChazWinter]

Contents actually start at 0:56

[@AshwaniKumar-yo1lk]

No practical only theory

[@CompleteCoding]

Would you have preferred an example as well?

[@durgadaskamath]

@@CompleteCoding Good explanation. Definetely example would make it much clearer as audience will know how the records are stored (same row, multiple row) and use of compound keys