Тёмный

Concurrent Requests and Unique Keys on Web Applications 

Hussein Nasser
Подписаться 412 тыс.
Просмотров 7 тыс.
50% 1

In this video I explain how primary key cannot be duplicated even if concurrent transactions are executed in the same time.
🏭 Software Architecture Videos
• Software Architecture
💾 Database Engineering Videos
• Database Engineering
🛰 Network Engineering Videos
• Network Engineering
🏰 Load Balancing and Proxies Videos
• Proxies
🐘 Postgres Videos
• PostgresSQL
🚢Docker
• Docker
🧮 Programming Pattern Videos
• Programming Patterns
🛡 Web Security Videos
• Web Security
🦠 HTTP Videos
• HTTP
🐍 Python Videos
• Python by Example
🔆 Javascript Videos
• Javascript by Example
👾Discord Server / discord
Support me on PayPal
bit.ly/33ENps4
Become a Patreon
/ hnasr
Stay Awesome,
Hussein

Наука

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

 

30 июн 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 26   
@anonymous.youtuber
@anonymous.youtuber 4 года назад
As usual, a superb explanation!
@anthonyfarias321
@anthonyfarias321 4 года назад
This is very good stuff man.
@dominicwong5647
@dominicwong5647 3 года назад
Great stuff Hussein, love your videos
@javedutube10
@javedutube10 3 года назад
As Always, love your explanation.
@arunsatyarth9097
@arunsatyarth9097 4 года назад
Thanks for your videos Hussein. Really beneficial and love your presentation style...
@hnasr
@hnasr 4 года назад
arun satyarth thanks Arun!! ❤️ glad you like the content
@sachinkalkur
@sachinkalkur 3 года назад
These short videos are extremely informative.
@hnasr
@hnasr 3 года назад
Glad to hear that!
@IBITZEE
@IBITZEE 4 года назад
nice thinking... nice tests... CCC thx !
@AAZinvicto
@AAZinvicto 4 года назад
Thank you bro for such informative videos. Love from India. Ma-as-salama
@hnasr
@hnasr 4 года назад
AAZinvicto much love to all my subs from India 🇮🇳❤️
@ahmedkhudhair8035
@ahmedkhudhair8035 4 года назад
Very nice ❤️
@arpitpandey8797
@arpitpandey8797 4 года назад
You reminded of me Dora the explorer 😅... Great video
@6Sambora
@6Sambora 4 года назад
Was about to ask you to do the same with MongoDB until the end of the video, when you mention NoSQL does not have isolation level haha
@hnasr
@hnasr 4 года назад
Kid Amador we can do some of things of not all of it. 😊 MongoDB is a different beast with different set of features
@simon66668
@simon66668 3 года назад
At the document level, MongoDB already supports ACID transactions
@ramonberrutti
@ramonberrutti 4 года назад
Nice explain, you just forgot the deadlock case, inserting in a different order in each transaction
@hnasr
@hnasr 4 года назад
Nice idea for another video forgot to mention it! Thanks 🙏
@8Trails50
@8Trails50 3 года назад
Sorry can you expand, what do you mean by this?
@adarshupadhyay8265
@adarshupadhyay8265 2 года назад
But how you were able to see the insert result without Commit operation in the beginning?
@MrDecorative
@MrDecorative 3 года назад
If the database is replicated, and the leader is processing a write with id 1 , and then crashes for some reason before those changes has been yet replicated to the follower which is elected to be the new leader , this new leader wouldn’t be aware of the key 1 which already exists , and after a while when the system gets eventual consistency, boom 💥 a problem in the system. This bug happened at github in 2011 with auto incrementing key 🔐
@AShahabov
@AShahabov 4 года назад
But what about when two transactions insert duplicate values in a NON-INDEX column? One of the transaction also will be blocked?
@hnasr
@hnasr 4 года назад
Hey Adam, if the column doesn't have a unique index, it is absolutely fine to duplicate values between transactions.
@ankitraj9684
@ankitraj9684 4 года назад
A video on log structured merge tree?
@hnasr
@hnasr 4 года назад
Ankit Raj soon! Not yet, 👍
@NivekMoto59
@NivekMoto59 4 года назад
it not ACID the word you search??
Далее
🎙️ПЕСНИ ВЖИВУЮ от КВАШЕНОЙ💖
3:23:13
SSH Keys
10:12
Просмотров 102 тыс.
Coding a Web Server in 25 Lines - Computerphile
17:49
Просмотров 325 тыс.
How does Uber scale to millions of concurrent requests?
20:04
don’t use “offset” in your SQL
9:10
Просмотров 38 тыс.
When to use a Publish-Subscribe System Like Kafka?
8:53
Column vs Row Oriented Databases Explained
34:16
Просмотров 73 тыс.
Working With Database Transactions In EF Core
14:11
Просмотров 18 тыс.
ИГРОВОВЫЙ НОУТ ASUS ЗА 57 тысяч
25:33
Gizli Apple Watch Özelliği😱
0:14
Просмотров 4,5 млн