[Dbix-class] Paging all re nested sets

[Matt S Trout]

On Thu, Apr 10, 2008 at 07:53:42PM +0200, Sebastian Willert wrote:
> > Why locking support? SELECT FOR UPDATE should do the trick shouldn't it?
> 
> In MySQL with InnoDB yes, in MySQL with MyISAM and SQLite no, even
> crashing the process. No idea about all the other DBs out there. If
> 'SELECT FOR UPDATE' is considered compatible enough, I will gladly use
> it directly with a big fat warning in the POD. MyISAM and SQLite could
> be regarded as unfit for this purpose without anyone shedding a tear
> IMO.

SQLite won't allow parallel updates at all anyway so I figure it can be
convinced to lock the entire database for us.

Postgres handles FOR UPDATE. MyISAM can go anally violate itself with a
brick for all I care.

As for anything else, I think doc "needs FOR UPDATE, if your DB doesn't have
it patches welcome" and call it good for a first release - half-working code
is better than no code at all.

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director                    http://www.shadowcat.co.uk/catalyst/
 Shadowcat Systems Ltd.  Want a managed development or deployment platform?
http://chainsawblues.vox.com/            http://www.shadowcat.co.uk/servers/