![]() |
CI4 Database Pessimistic Locking Row - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28) +--- Forum: CodeIgniter 4 Feature Requests (https://forum.codeigniter.com/forumdisplay.php?fid=29) +--- Thread: CI4 Database Pessimistic Locking Row (/showthread.php?tid=67672) |
CI4 Database Pessimistic Locking Row - arma7x - 03-23-2017 Does codeigniter 4 database library will have pessimistic locking feature like laravel eloquent does, https://laravel.com/docs/5.4/queries#pessimistic-locking RE: CI4 Database Pessimistic Locking Row - Narf - 03-23-2017 Do you know what a pessimistic lock is in the first place, or are you just asking just because Laravel? RE: CI4 Database Pessimistic Locking Row - arma7x - 03-23-2017 (03-23-2017, 05:00 AM)Narf Wrote: Do you know what a pessimistic lock is in the first place, or are you just asking just because Laravel? Yes, i know it. Just like how CI lock session row in database until finish updating it. And I want to lock the row until finished with it. RE: CI4 Database Pessimistic Locking Row - Narf - 03-23-2017 Well, if you know what you want to do with it - fair enough. Though, I asked more about the "pessimistic" part, as a) pretty much nobody uses that term in PHPland; and b) it is wrongly described in the Laravel manual you linked to - a shared lock is not pessimistic. RE: CI4 Database Pessimistic Locking Row - arma7x - 03-23-2017 (03-23-2017, 11:43 AM)Narf Wrote: Well, if you know what you want to do with it - fair enough. Not sharedlock() but lockforupdate() as mention in laravel eloquent, "Prevent the rows from being modified or from being selected with another shared lock". |