Laravel Race Conditions tutorial

Hello Laracasts

I can't find a Race conditions, locks and DB transaction Laravel tutorial.

Can you please suggest one?

Thank you,

Avraham

jlrdw

3 years ago

Level 75

If using MySql, the manual covers it.

https://dev.mysql.com/doc/c-api/8.0/en/getting-unique-id.html

And clearly states:

Quote

For LAST_INSERT_ID(), the most recently generated ID is maintained in the server on a per-connection basis. It is not changed by another client. It is not even changed if you update another AUTO_INCREMENT column with a nonmagic value (that is, a value that is not NULL and not 0). Using LAST_INSERT_ID() and AUTO_INCREMENT columns simultaneously from multiple clients is perfectly valid. Each client will receive the last inserted ID for the last statement that client executed.

Unquote

If mass inserting data, the laravel documentation covers upserts.