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

Подписаться 17 тыс.

Просмотров 21 тыс.

50% 1

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

Наука

Опубликовано:

2 сен 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 36

@gonzalofernandez1 3 года назад

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

@CompleteCoding 3 года назад

Thanks! Glad you liked the cheat sheet

@charlesandrews2273 3 года назад

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

@CompleteCoding 3 года назад

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

@deepeshkumarr5687 3 года назад

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

@CompleteCoding 3 года назад

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

@ChazWinter 8 месяцев назад

Contents actually start at 0:56

@amrmonzir 3 года назад

Thank you. Great work!

@CompleteCoding 3 года назад

Glad you liked it!

@subowijeyesinghe3429 3 года назад

Good one, thanks

@CompleteCoding 3 года назад

Glad you liked it!

@shwenansuwai2481 3 года назад

Thank you so much.

@CompleteCoding 3 года назад

Glad you liked it

@akwashington1962 3 года назад

Good information. In the future, consider adding visuals.

@CompleteCoding 3 года назад

Thanks, will do!

@xD-saleem Год назад

Thanks for this

@CompleteCoding Год назад

My pleasure!

@Eldeirdro 9 месяцев назад

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

@diegomarzo4001 3 года назад

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

@CompleteCoding 3 года назад

Thanks again! it means a lot

@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!

@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

@ogcontraband 8 месяцев назад

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 8 месяцев назад

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

@cloudagnostic 2 года назад

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

@CompleteCoding 2 года назад

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 2 года назад

@@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

@Mrstealurgrill 3 года назад

Can you query by sort key only?

@CompleteCoding 3 года назад

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.

@shinj1323 2 года назад

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

@CompleteCoding 2 года назад

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.

@AshwaniKumar-yo1lk 2 года назад

No practical only theory

@CompleteCoding 2 года назад

Would you have preferred an example as well?

@durgadaskamath 2 года назад

@@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