<div dir="ltr"><div>My motivation for asking is that I have a couple of plugins for DBIC that provide support for non-universal SQL features like window functions or table sampling. (I've also thought about a Postgres-specific plugin that allowed one to use the WITH syntax for faster updates on multiple tables, but gave up, perhaps for the wiser.)<br></div><div><br></div><div>It would make sense if these were instead plugins for SQL::Abstract, and there was a reasonable way to configure DBIC to load SQL abstract with plugins.</div><div><br></div><div>I'm thinking something along the lines of Catalyst's traits-for-requests, which is cleaner than subclassing the request class with roles using the subclass instead.</div><div><br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jul 14, 2020 at 2:05 AM Matt S Trout <<a href="mailto:mst@shadowcat.co.uk">mst@shadowcat.co.uk</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Wed, Jul 08, 2020 at 03:22:02PM +0100, Robert Rothenberg wrote:<br>
> It seems that SQL::Abstract has been forked into SQL::Abstract::Classic,<br>
> presumably so the former can be updated without breaking DBIC etc.<br>
<br>
Presumably, yes.<br>
<br>
Not that any of the SQL::Abstract developers were consulted as to whether<br>
that was necessary, but it is what it is.<br>
<br>
> Is there a roadmap for updating it? Long-term plans? etc<br>
<br>
There is a dev release towards verion 2.0 here:<br>
<br>
<a href="https://metacpan.org/release/MSTROUT/SQL-Abstract-1.90_03" rel="noreferrer" target="_blank">https://metacpan.org/release/MSTROUT/SQL-Abstract-1.90_03</a><br>
<br>
I'd love to hear about people's experiences using it (see the ::Reference<br>
POD for a lower level idea of the new implementation).<br>
<br>
I was originally planning to release a separate SQL::Abstract2 to begin<br>
with, but given the unannounced fork and the fact that every downstream<br>
maintainer other than Peter Rabbitson has been actively co-operating with<br>
ensuring compatibility is preserved, I'm not sure there's much point now.<br>
<br>
For the moment, I'd ask that people wanting to test it install the last<br>
pre-unexpected-fork version of DBIx::Class and the dev release and play<br>
around - I'd really quite like to get some feedback before committing to the<br>
idea that it *is* compatible, especially given I have to rely on the<br>
DBIx::Class userbase alone to determine this.<br>
<br>
When I have a minute, I'll check into how to make the real SQL::Abstract<br>
work with the new DBIC release, and will report back to the list once I do.<br>
<br>
-- <br>
Matt S Trout - Shadowcat Systems - Perl consulting with a commit bit and a clue<br>
<br>
<a href="http://shadowcat.co.uk/blog/matt-s-trout/" rel="noreferrer" target="_blank">http://shadowcat.co.uk/blog/matt-s-trout/</a> <a href="http://twitter.com/shadowcat_mst/" rel="noreferrer" target="_blank">http://twitter.com/shadowcat_mst/</a><br>
<br>
Email me now on mst (at) <a href="http://shadowcat.co.uk" rel="noreferrer" target="_blank">shadowcat.co.uk</a> and let's chat about how our CPAN<br>
commercial support, training and consultancy packages could help your team.<br>
<br>
_______________________________________________<br>
List: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class" rel="noreferrer" target="_blank">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class</a><br>
IRC: <a href="http://irc.perl.org#dbix-class" rel="noreferrer" target="_blank">irc.perl.org#dbix-class</a><br>
SVN: <a href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/" rel="noreferrer" target="_blank">http://dev.catalyst.perl.org/repos/bast/DBIx-Class/</a><br>
Searchable Archive: <a href="http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk" rel="noreferrer" target="_blank">http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk</a><br>
</blockquote></div>