Skip Menu |
 

This queue is for tickets about the DBIx-Class CPAN distribution.

Report information
The Basics
Id: 128130
Status: open
Priority: 0/
Queue: DBIx-Class

People
Owner: Nobody in particular
Requestors: mark [...] markandruth.co.uk
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



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>
Download (untitled) / with headers
text/plain 418b
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
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>
Download (untitled) / with headers
text/plain 959b
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!


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.