4 Nov
2010
4 Nov
'10
5:02 p.m.
On Thu, Nov 4, 2010 at 1:50 PM, Galen Charlton <gmcharlt@gmail.com> wrote:
Hi,
On Thu, Nov 4, 2010 at 12:34 PM, Tomas Cohen Arazi <tomascohen@gmail.com> wrote:
Is it possible to create db-agnostic row-level locks using DBIx::Class?
True row-level locking is purely a function of the DBMS; DBIx::Class can't create such locks if the backend database doesn't support them.
Yes, what I meant to ask was if switching to DBIx::Class could prevent us from using those kind of locks that could help on several areas where concurrency might be seen as an issue. I don't know postgres's syntax for START TRANSACTION or if the semantics of mysql's 'SELECT... FOR UPDATE' can me mapped by that library into that postgres uses. To+