Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re: Terminology: Is DBIx::Class an ORM?

by Arunbear (Prior)
on Jun 02, 2021 at 22:22 UTC ( #11133443=note: print w/replies, xml ) Need Help??


in reply to Terminology: Is DBIx::Class an ORM?

I'd say it is an ORM, but ORM can refer to different architectural flavours, like Active record pattern and Data mapper pattern.

DBIC does support Active record but to a much greater extent is based on Query Object (i.e. DBIx::Class::ResultSet), hence its absurdly high degree of SQL friendliness.

  • Comment on Re: Terminology: Is DBIx::Class an ORM?

Replies are listed 'Best First'.
Re^2: Terminology: Is DBIx::Class an ORM?
by LanX (Sage) on Jun 03, 2021 at 12:52 UTC
    > I'd say it is an ORM, but ORM can refer to different architectural flavours,

    Many thanks, that explains a lot. :)

    > DBIx::Class::ResultSet

    I'd rather call this an SQL abstraction.

    It's much like SQL::Abstract and allows to cover (almost?) all semantics of SQL queries.

    But yeah, like I said I'm strongly associating ORM to "Active Records" and the resulting limitations.

    Cheers Rolf
    (addicted to the Perl Programming Language :)
    Wikisyntax for the Monastery

      And where do you draw the line between ORM and SQL abstraction?
        OO and relational algebra are very different paradigms.

        An ORM will force the class structure onto the RDB-schema.

        It's only using a subset of SQL and can be mapped back 1-to-1 to an object model (of the particular host language, here Perl).

        It's like a amputated creole, speaking English words with Latin grammar. But without the possibility to introduce new Latin particles to express the new grammar, forcing you to use costly workarounds.

        E.G. there is no "inheritance" in SQL.

        An SQL-Abstraction attempts to express all or most of the SQL-Space inside the host language, like with a query builder.

        It's effectively just a new SQL dialect, attempting to map 1-to-1 onto other dialects (like LIMIT vs TOP )

        My impression is/was that DBIC attempts to have the best of both worlds, which also explains it's complexity.

        For a long read why many people despise ORMs you may want to have a look at

        (I'll skip the first 6 pages about US-Vietnam-War though. :)

        This blog-entry had a heavy impact and was often discussed in both directions, you might want to google the responses...

        Cheers Rolf
        (addicted to the Perl Programming Language :)
        Wikisyntax for the Monastery

        update

        swapped "Chinese" with "Latin" for claritas in metaphora ;-)

        ) or is it rather speaking Latin with English grammar? :)

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11133443]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (4)
As of 2021-10-21 21:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My first memorable Perl project was:







    Results (85 votes). Check out past polls.

    Notices?