4 ms·
An ORMish thing that considers its primary purpose to enable metaprogramming SQL is actually useful. In http://p3rl.org/DBIx::Class http://p3rl.org/DBIx::Class
by mst 7y ago
An ORMish thing that considers its primary purpose to enable metaprogramming SQL is actually useful.
In http://p3rl.org/DBIx::Class http://p3rl.org/DBIx::Class perl has had such a thing for over a decade now.
It makes me cry that nobody's ever adequately cloned it into other languages. Eventually I'll probably do so myself.
- weberc2 7y agoIsn’t that just a query builder? I’m not familiar with Perl or your library, so maybe you could tell me where I’m wrong?
- mst 7y agoWhat I was trying (and evidently failing) to say is that a sufficiently powerful query generation system that's designed for people who actually like their database to be able to generate the exact SQL they would've written by hand is essential to the 'mapper' part of the equation being able to smooth out any impedence mismatches between the appropriate object model and the appropriate database schema. Hopefully that longer answer is a bit clearer than my first attempt.
- misterdoubt 7y agoI guess I don't know enough Perl to understand how this differs dramatically from something like SQLAlchemy in Python.
- mst 7y agoSQLAlchemy is pretty close. Been quite a few years since I've had a chance to get drunk with the authors and compare notes though, so I'm not going to try and get into details because I'm pretty much guaranteed to get some of them wrong.