Loading video player...
Check out our sponsor TestSprite: https://www.testsprite.com/?via=sd ======⚡⚡⚡====== Pessimistic and Optimistic Concurrency is a tricky topic when it comes to distributed transactions and working with databases. In this video, we're going to learn their differences, how it looks in raw SQL queries as well as in a Node.js application with Sequalize and Postgres. Consider becoming a member of the channel by joining me ❤️ https://www.youtube.com/channel/UCqAL_b-jUOTPjrTSNl2SNaQ/join ☕ Buy me a coffee: https://www.buymeacoffee.com/softwaredeveloperdiaries 🙌 Become my Patreon and get exclusive perks: https://patreon.com/softdevdiaries 💼 Follow me on LinkedIn and drop me a message if you'd like: https://www.linkedin.com/in/gadirovgs/ 💻 Also, let's connect on GitHub: https://github.com/gusgad 📚 Resources: Deadlocks explained: https://youtu.be/9Zw3ay3_tCQ Article on concurrency: https://www.geeksforgeeks.org/dbms/difference-between-pessimistic-approach-and-optimistic-approach-in-dbms/ Code: https://github.com/gusgad/youtube-tutorials/tree/concurrency 🕒 Timestamps: 0:00 What is concurrency 1:30 Pessimistic concurrency 6:05 TestSprite 7:33 Optimistic concurrency And don't forget to subscribe for more videos like this 😊