[Koha-devel] Oracle nerfs MySQL, calls it MySQL classic, and charges $2, 000+ for features like InnoDB

[Tomas Cohen Arazi]

On Thu, Nov 4, 2010 at 1:50 PM, Galen Charlton <gmcharlt at gmail.com> wrote:
> Hi,
>
> On Thu, Nov 4, 2010 at 12:34 PM, Tomas Cohen Arazi <tomascohen at 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+