Reserving datasets from top to bottom of a list (database-table) for users avoiding race conditions (Django 4.1)

Question

I start developing a Django web app that ist going to be used by hundreds of user at the same time.

The app consits of a simple database table that lists unique tasks top-down. The first user that request some tasks should get the tasks from the top of the list. The next user that asks for tasks should get the next tasks and so on.

How do I prevent, that users get the same tasks from the table when they ask for datasets at the same time? Is there the possibility of a race condition?

Please post your code so that we can give a context specific answer. It makes a difference. Thanks. — Swift
– Swift, Commented Oct 27, 2022 at 22:00

Super sub · Accepted Answer · 2022-10-27 21:52:05Z

2

Try select_for_update or F expressions you can find more info here

F Expression

select_for_update

also I think this question might help

answered Oct 27, 2022 at 21:52

Super sub

3443 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Swift Over a year ago

You should expand on this answer

Thorben Over a year ago

Thanks for the answer. select_for_update should do the trick.

Collectives™ on Stack Overflow

Reserving datasets from top to bottom of a list (database-table) for users avoiding race conditions (Django 4.1)

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related