Well, this may be a case where you'd want to use the right tool for the job.

You can use sql to do string manipulation (trim, substring, soundex, and so forth), but the sql server has to process those in addition to any joins, restriction, ordering, and so on.

I have found that passing a sql query using DBI and then using perl to do any text processing is far more efficient in terms of development and speed of execution than trying to do it all in sql. Especially if you are trying to create a dynamic web page with up-to-date information from a relational database.

Bottom line: SQL is the tool for querying relational databases; Perl is the tool for formatting the results. They work synergistically, and complement each other's strengths and limitations.

-----
"Computeri non cogitant, ergo non sunt"

In reply to Re: Re: Replacing SQL with perl by cadfael
in thread Replacing SQL with perl by marvell

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.