This is more of a quick note than comprehensive overview. I've looked over the various offerings for creating libraries of SQL and one new one hit CPAN today - DBIx::QueryByName.

In looking at it, the one thing I notice about the XML File Syntax is that there is no way for parameters to have default values if not specified.

Another thing is that XML File Syntax makes it difficult for a SQL mode in emacs to highlight and indent the code unless you do something with mixed mode so that it handles the XML and SQL gracefully.

The final thing is that the session management features of this module appear to be a violation of orthogonal integration of concerns.

  • Comment on SQL Library modules - DBIx::QueryByName

Replies are listed 'Best First'.
Re: SQL Library modules - DBIx::QueryByName
by zentara (Cardinal) on Oct 31, 2009 at 11:26 UTC
    appear to be a violation of orthogonal integration of concerns

    ... I know half the battle in understanding something is to grok the vocabulary, and I'll have to meditate a long time to figure that one out..... of course...I'm not much of an SQL person :-)

    P.S. ... ah, I think I understand now..high level design strategy

    I'm not really a human, but I play one on earth.
    Old Perl Programmer Haiku
[reply]
      orthogonal integration of concerns
      let's take DBIx::Password as an example, it confuses the concern of storing the configuration info for connecting to a database with the concern of connecting to a database.

      Connecting to a database is best handled by DBIx::Connector. Application configuration information is best handled by (pick your favorite config module, I like a Moose class myself). Orthogonal integration of these two modules is one way to get database connections. The other way is violation orthogonal integration of concerns and try to lump it all in a single module like DBIx::Password.

      Now, this SQL Library module does a similar thing. It tries to handle database sessioning AS WELL AS sql cataloging. Yet another violation of orthogonal integration of concerns

[reply]
        orthogonal integration of concerns

        from my background, if something is truly orthogonal, it means it adds another dimension to the set..... this seems desirable to me... more dimensions, which can or can't be used.... too much Matrix algebra in school... :-)

        but i do see the different context that you give to orthogonal

        I'm not really a human, but I play one on earth.
        Old Perl Programmer Haiku
[reply]
Re: SQL Library modules - DBIx::QueryByName
by metaperl (Curate) on Dec 05, 2009 at 19:44 UTC
[reply]

Back to Meditations