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:
https://ko-fi.com/bugbytes

? ????????:
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:
https://www.youtube.com/playlist?list=PL-2EBeDYMIbQXKsyNweppuFptuogJe2L-

?????? ?????:
? Blog: https://bugbytes.io/posts/
? Github: https://github.com/bugbytes-io/django-orm-series
? Twitter: https://twitter.com/bugbytesio

? ??????? ??????? ??? ???????????:
Django select_for_update() - https://docs.djangoproject.com/en/4.2/ref/models/querysets/#select-for-update
Docker PostgreSQL image: https://hub.docker.com/_/postgres
PostgreSQL: https://www.postgresql.org/
Django DATABASES setting: https://docs.djangoproject.com/en/4.2/ref/settings/#databases

#python #django #webdevelopment #database #sql