[Dbix-class] What's the situation with SQL::Abstract?

[Robert Rothenberg]

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.)

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.

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.



On Tue, Jul 14, 2020 at 2:05 AM Matt S Trout <mst at shadowcat.co.uk> wrote:

> On Wed, Jul 08, 2020 at 03:22:02PM +0100, Robert Rothenberg wrote:
> > It seems that SQL::Abstract has been forked into SQL::Abstract::Classic,
> > presumably so the former can be updated without breaking DBIC etc.
>
> Presumably, yes.
>
> Not that any of the SQL::Abstract developers were consulted as to whether
> that was necessary, but it is what it is.
>
> > Is there a roadmap for updating it? Long-term plans? etc
>
> There is a dev release towards verion 2.0 here:
>
> https://metacpan.org/release/MSTROUT/SQL-Abstract-1.90_03
>
> I'd love to hear about people's experiences using it (see the ::Reference
> POD for a lower level idea of the new implementation).
>
> I was originally planning to release a separate SQL::Abstract2 to begin
> with, but given the unannounced fork and the fact that every downstream
> maintainer other than Peter Rabbitson has been actively co-operating with
> ensuring compatibility is preserved, I'm not sure there's much point now.
>
> For the moment, I'd ask that people wanting to test it install the last
> pre-unexpected-fork version of DBIx::Class and the dev release and play
> around - I'd really quite like to get some feedback before committing to
> the
> idea that it *is* compatible, especially given I have to rely on the
> DBIx::Class userbase alone to determine this.
>
> When I have a minute, I'll check into how to make the real SQL::Abstract
> work with the new DBIC release, and will report back to the list once I do.
>
> --
> Matt S Trout - Shadowcat Systems - Perl consulting with a commit bit and a
> clue
>
> http://shadowcat.co.uk/blog/matt-s-trout/
> http://twitter.com/shadowcat_mst/
>
> Email me now on mst (at) shadowcat.co.uk and let's chat about how our CPAN
> commercial support, training and consultancy packages could help your team.
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive:
> http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20200812/528c9a83/attachment.html>