Django - select_for_update() function / Locking Database Rows

Показать описание

In this video, we'll look at the Django select_for_update() function, that can be used to lock the rows that are being returned from the database. This function can lock a single row (model) or multiple rows (QuerySet) from being updated outwith the current transaction.

This is useful for situations where you need to avoid concurrent transactions updating the data that has been retrieved, and we work through a small example in this video.

☕️ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲:
To support the channel and encourage new videos, please consider buying me a coffee here:

📌 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
00:00 Intro
00:29 select_for_update() in Django
04:15 Installing PostgreSQL in Docker container
10:55 Locking rows with select_for_update()

▶️ Full Playlist:

𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:

📚 𝗙𝘂𝗿𝘁𝗵𝗲𝗿 𝗿𝗲𝗮𝗱𝗶𝗻𝗴 𝗮𝗻𝗱 𝗶𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻:

#python #django #webdevelopment #database #sql

BugBytes

Рекомендации по теме

Комментарии

You are best teacher.. Love from India..

DhavalAhir

Thank you, you helped me in my interview. 🙌

mithileshgautam

I like this level of intensity! Thanks.

dmitrymikhailovnicepianomu

Super usefull. Thank you for your django and htmx videos!

alexdubkov

Thank you for another great video! I think this one might have ended up out of order in your playlist. Should this be the video after the atomic() function video, rather than the video before?

daviddehoog

Brother... try to upload more videos about django channels, signals, custom Middleware...

jackoffjames

hi, do you have solution for Like:
Multiple table field Sum calculation from parent model to get stock qty each product (stock qty= purchase_qty - purchase_return_qty - sales_qty + sales_qty )

sha-us

also does select update works with LIMIT? say I only want to select and lock 1 row

rakeshmali

but product on line 29 was never implemented or am i mad????

psymon

if there are concurrent 100 requests and they all try to select and update 10000 rows, then the first request locks all these 10000 rows while other 99 requests wait, right?

rakeshmali

Django - select_for_update() function / Locking Database Rows

Django - select_for_update() function / Locking Database Rows

How to update a existing record in Django model easily | Use of Update function

Django Query Optimization / select_related & prefetch_related / django-debug-toolbar / N+1 Probl...

How to Update TO DO list using Django || How to Update form data using Django || Python

Django Framework | Complete CRUD operations Python | create, read, update, delete

Create a Dependent Select Field in Django With HTMX

Django: Boost your query performance!

Update / Delete Record in Django || How to

Django Class 9 - Django Framework (Part 6) #djangobootcamp #django #djangoframework #learndjango

Django select_related Examples |Django select_related and prefetch_related |Django n+1 Query Problem

Django Database Transactions / atomic() function

Make your django query faster | Select related and prefetch related Django

Update Staff | Staff Model Data Update Function | Python Django Tutorial

django tutorial updating video information

Django Dependent Drop Down List Example | Integration with Django Forms and Django Form Validations

Django 5.0 Just Made Forms Even Better

Django Select2 Tutorial | Django Dropdown | Django ajax Dropdown | Django Search and Filter

Django Framework Python | CRUD operations | Create, Read,Update,Delete Application

How to Build A Todo App With Django - PART 6 - Update Data

Python dictionary and HTML select options form in Django

Create Read Update and Delete (CRUD) Functions | Django Inventory Management System Web Application

Django edit and update data using jQuery Ajax #1

Django ORM - Select and Output individual fields example

24 Django E Commerce Update Change User & Profile Information English