Bug #128130 for DBIx-Class: Server-side Pg cursor support

Sat Dec 29 03:12:46 2018 mark [...] markandruth.co.uk - Ticket created

Subject:	Server-side Pg cursor support
Date:	Sat, 29 Dec 2018 11:12:23 +0300
To:	bug-DBIx-Class [...] rt.cpan.org
From:	Mark Zealey <mark [...] markandruth.co.uk>

Any chance you could have a look through my POC at https://github.com/mzealey/dbic-pg-server-cursors and suggest any changes/improvements, then I'll brush it up and do it as a new CPAN module? The syntax seems to be pretty standard SQL so I could probably generalize but I only have experience with mysql/pg/sqlite and I think pg is the only one from those that supports (or needs) proper cursors. Thanks! Mark

Sat Dec 29 03:36:27 2018 ribasushi [...] leporine.io - Correspondence added

Subject:	Re: [rt.cpan.org #128130] Server-side Pg cursor support
Date:	Sat, 29 Dec 2018 09:36:08 +0100
To:	bug-DBIx-Class [...] rt.cpan.org
From:	Peter Rabbitson <ribasushi [...] leporine.io>

On 12/29/2018 09:12 AM, Mark Zealey via RT wrote: Show quoted text

> > Any chance you could have a look through my POC at > https://github.com/mzealey/dbic-pg-server-cursors and suggest any > changes/improvements, then I'll brush it up and do it as a new CPAN > module?

Hi! I am currently at a conference, and with $work stuff am unlikely to be able to look at this in-depth until mid~January. However there is a (really :((( ) old piece of implementation for DBIC core directly, but because the underlying architecture did not allow for sufficient configurability it did not progress. You should compare to that implementation and see what can and can not be reused/improved on your end. https://github.com/Perl5/DBIx-Class/compare/c6805def7c At present I am not planning to include this into the DBIC dist ( the issue that blocked the original implementation is still valid ). Your path of a separate storage subclass is currently the best way forward Thanks!

Sat Dec 29 03:36:28 2018 The RT System itself - Status changed from 'new' to 'open'