On: PHP 8: Before and After

[andi999]

I am wondering this: are people who do crud apps (in php or otherwise) do consider race-conditions in the database? Like one query and then based on that query another one which inserts/updates? And if so, where can I read about the standard techniques used in practice?

[jpalomaki → andi999]

Database transactions is the topic you should look into. There's ways to handle these in all environments.

https://en.wikipedia.org/wiki/Database_transaction

[andi999 → jpalomaki]

Thanks. So is the general industry practice? I read MySql only supports this since like 2004, somehow reading material doesnt seem to be too concerned about these.

[SPBS → andi999]

https://blog.coeo.com/a-cheat-sheet-for-isolation-levels-in-... The standard technique is deciding which isolation level you want to use for your queries.