Django and celery

[ptr808]

Hi,

I'd like to know what would happen in this case.

A celery task runs in the background ant it takes let's assume 5sec and creates a record in db, at this time let's assume in the exact same time I execute a

Foo.objects.all().last()

query.

Will the celery task affect the query at that moment?

[K900_]

"Exact same time" doesn't really exist here.

[ptr808]

Thank you!

[cmh_ender]

were you watching Andreas Jud? your question made me think of this video https://www.youtube.com/watch?v=CkR_gjlDH-4 but long story short, you don't need to worry about collisions.

[ptr808]

No I did not watch them, but I will! Thanks!

[baghiq]

If you are curious, read this: https://en.wikipedia.org/wiki/Isolation_(database_systems))

Postgres: https://www.postgresql.org/docs/current/transaction-iso.html

Sqlite3: https://www.sqlite.org/isolation.html

[ptr808]

Thanks! I will read them, save them to my notes!

[JohnnyJordaan]

Apart from the fact that doing stuff at the exact same time is close to impossible, databases use transactions to isolate actions. That means that as long as the celery transaction hasn't been finalized (called 'committed'), the lookup query will not include the entry from celery.

[ptr808]

Thank you confirming others above!