in reply to Re: Re: DBIx::Simple - Your opinions/review please
in thread DBIx::Simple - Your opinions/review please

I used to be proud of [the subquery emulation feature], because it enabled users of MySQL to use subqueries and a lot of people seemed to really want that. But MySQL now supports that natively and thus of course in a much better way. And I don't want to maintain the ugly code needed for it just for database drivers that aren't used much anyway.

Just for another viewpoint, I've not used DBIx::Simple, but your original post prompted me to skim the docs. The only thing there that seemed of possible interest to me was this feature - my work application targets MySQL v3, and while the next generation of the application will target a later version it is unlikely that the current generation will be re-targeted.

I've occasionally been hurt by the lack of subselects, and considered emulating them; discovering that someone has already done that was a pleasant surprise.

If it works, I'd suggest keeping it - don't expect MySQL v3 to disappear from production servers any time soon. (In fact, a quick check on http://www.mysql.com suggests that the subselects are in v4.1, while latest stable release is still at 4.0.20.)

Hugo

  • Comment on Re: Re: Re: DBIx::Simple - Your opinions/review please

Replies are listed 'Best First'.
Re: Re: Re: Re: DBIx::Simple - Your opinions/review please
by Juerd (Abbot) on May 30, 2004 at 22:33 UTC

    I'd suggest keeping it

    Oh, it'll stay for a while. At least until I've upgraded my own production systems to a more recent mysql (or better yet: something that isn't mysql). It'll certainly be removed when big changes happen, though. And - if you really want to depend on this feature (note that it cannot be fast and that it cannot be atomic), it's not too hard to copy the code now and subclass DBIx::Simple when the time comes. Actually, maybe I'll do so myself and release that.

    Update - It'll be in DBIx::Simple::SQE.

    Update - In March 2007, with DBIx::Simple release 1.27, support for subquery emulation was dropped completely.

    Juerd # { site => 'juerd.nl', plp_site => 'plp.juerd.nl', do_not_use => 'spamtrap' }