.NET Data Community Standup - Database concurrency and EF Core: Beyond optimistic concurrency - Ep 3
Рет қаралды 6,606
Күн бұрынIn the 3rd installment of our series on concurrency, we'll dive deep into SQL isolation levels, how they work (and work differently!) across SQL Server and PostgreSQL. We'll hopefully learn a bit about how database locks, snapshots and isolation levels work together to bring some sanity into the world of concurrency.
Watch the 3-part Database Concurrency series:
• Database Concurrency -...
⏲️ Chapters:
00:00 Countdown
02:40 Welcome to .NET Data Community Standup
04:22 State of the Unicorn
06:36 Optimistic concurency overview
08:57 SQL Isolation levels overview
21:39 Demo - Read uncommitted
40:26 Repeatable read
42:22 Demo - Repeatable read
55:05 Scan direction and Multiversion Concurrency Control (MVCC)
01:01:36 Demo - Read committed snapshot isolation
01:08:00 Snapshot Isolation
01:12:20 Demo - Snapshot Isolation mode
01:16:20 Serialization Anomaly vs. Snapshot
01:18:45 Q&A
01:37:30 Thank you
Catch up on the 1st and 2nd installments:
Database concurrency and EF Core: ASP.NET and Blazor
kzfaq.infoxVyYrtetDeA
Links: www.theurlist.com/trexfpd
Featuring: Shay Rojansky, Arthur Vickers
#sql #dotnet #efcore
@Bourn77 2 ай бұрын
Very detailed explanation, Shay was great. So the takeaway from this session is Postgres is superior to SQL server in terms of standards and reliability. 😅
@rapzid3536 Ай бұрын
Not sure ya'll got into this but one interesting difference between MySQL and Postgres is that Postgres does not do gap locking.
@flygonfiasco9751 2 ай бұрын
Kudvenkat had a similar demo explaining transactions in a similar way. Very helpful!
@s.hosseinhosseini8330 2 ай бұрын
Great talk.
@oneshot2579 2 ай бұрын
What is the name of this tool for MS SQL and PostgreSQL?
@pavlindrom 2 ай бұрын
It says JetBrains Rider, but I never saw that view while using it. Not the thing I expected to learn from this video haha
@carlinhos10002 2 ай бұрын
Maybe the Jetbrains database IDE?
@oneshot2579 2 ай бұрын
You are right. It is DataGrip
@markwb0410 2 ай бұрын
bad intro!...
Intellipaat
Рет қаралды 227 М.
Fabiosa Best Lifehacks
Рет қаралды 6 МЛН
Nihira Techiees
Рет қаралды 13 М.
Andrew Huberman
Рет қаралды 2,7 МЛН
FISPECKT
Рет қаралды 137 М.